Xyphon Posted June 27, 2008 Share Posted June 27, 2008 I have a news file and for News_Post my files are NORMALLY over 255 characters, then they don't display.. How can I let it display anyways? Link to comment https://forums.phpfreaks.com/topic/112113-solved-expanding-ove-255-characters/ Share on other sites More sharing options...
cooldude832 Posted June 27, 2008 Share Posted June 27, 2008 what? Link to comment https://forums.phpfreaks.com/topic/112113-solved-expanding-ove-255-characters/#findComment-575578 Share on other sites More sharing options...
Xyphon Posted June 27, 2008 Author Share Posted June 27, 2008 Like, my database is Varchat(225).. Is there anyway to make it like,, 800, 10000? Link to comment https://forums.phpfreaks.com/topic/112113-solved-expanding-ove-255-characters/#findComment-575579 Share on other sites More sharing options...
.josh Posted June 27, 2008 Share Posted June 27, 2008 use a bigger char type like blob or longblob Link to comment https://forums.phpfreaks.com/topic/112113-solved-expanding-ove-255-characters/#findComment-575581 Share on other sites More sharing options...
cooldude832 Posted June 27, 2008 Share Posted June 27, 2008 use a bigger char type like blob or longblob If its a text field blob isn't the best choice text is better leaving options to fulltext index. Blob is designed mainly for binaries/maining less text that is basically binary I believe the newest version of MySQL has support for extended varchar upwards of 10k characters but don't quote me. Link to comment https://forums.phpfreaks.com/topic/112113-solved-expanding-ove-255-characters/#findComment-575583 Share on other sites More sharing options...
Xyphon Posted June 27, 2008 Author Share Posted June 27, 2008 My host doesn't support the newest, I don't think. And what's a 'char type'. Link to comment https://forums.phpfreaks.com/topic/112113-solved-expanding-ove-255-characters/#findComment-575585 Share on other sites More sharing options...
cooldude832 Posted June 27, 2008 Share Posted June 27, 2008 Char type is the field type in phpmyadmin you can adjust it very easily alternatively you can use the query ALTER TABLE `TABLE` CHANGE `FIELDNAME` `FIELD NAME` NEW TYPE NOT NULL Link to comment https://forums.phpfreaks.com/topic/112113-solved-expanding-ove-255-characters/#findComment-575587 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.