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? Quote 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? Quote 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? Quote 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 Quote 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. Quote 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'. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.