TGWSE_GY Posted June 1, 2009 Share Posted June 1, 2009 Okay I am wondering what the data type and colation need to be for fields in the database that I want to store text including special characters and punctuation. Like an About Me box on a profile. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/160503-solved-mysql-storing-text/ Share on other sites More sharing options...
Alt_F4 Posted June 2, 2009 Share Posted June 2, 2009 Text IS the datatype, but depending on where and how you are outputing this data you MAY still need to use escape characters (emphasis on the MAY) as for the colation i'm not to sure what you would use Quote Link to comment https://forums.phpfreaks.com/topic/160503-solved-mysql-storing-text/#findComment-847439 Share on other sites More sharing options...
fenway Posted June 6, 2009 Share Posted June 6, 2009 Don't mark topics solved unless the solution appears in the thread. Quote Link to comment https://forums.phpfreaks.com/topic/160503-solved-mysql-storing-text/#findComment-850496 Share on other sites More sharing options...
TGWSE_GY Posted June 25, 2009 Author Share Posted June 25, 2009 I used blob Quote Link to comment https://forums.phpfreaks.com/topic/160503-solved-mysql-storing-text/#findComment-863304 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.