KyleMassacre Posted February 9, 2012 Share Posted February 9, 2012 What is the best setting for forum posts in my game? My posts keep getting cut off because im assuming its set to varchar (255). Quote Link to comment Share on other sites More sharing options...
Sim Posted February 9, 2012 Share Posted February 9, 2012 TEXT or BLOG Quote Link to comment Share on other sites More sharing options...
Spudinski Posted February 9, 2012 Share Posted February 9, 2012 TEXT or BLOG There's no such data type as "BLOG". @OP: It depends, normally I would suggest LONGTEXT for forum posts, but TEXT type is treated as character set so they have a character set. That's all fine if you plan on using one language throughout the posts, but if you plan on using Eastern languages I'd suggest BLOB, where data is treated as byte-strings. Quote Link to comment Share on other sites More sharing options...
a_bertrand Posted February 9, 2012 Share Posted February 9, 2012 maybe he mixed blog with blob => binary large object which mysql support. On oracle you can also have clob which is character large object which on mysql is called text (tinytext,text, mediumtext or longtext) Quote Link to comment Share on other sites More sharing options...
Spudinski Posted February 9, 2012 Share Posted February 9, 2012 maybe he mixed blog with blob => binary large object which mysql support. On oracle you can also have clob which is character large object which on mysql is called text (tinytext,text, mediumtext or longtext) I didn't know that, but I'll keep in mind when I work on an Oracle database(unlikely, since I dislike Oracle very much these days). Thank you Quote Link to comment Share on other sites More sharing options...
a_bertrand Posted February 9, 2012 Share Posted February 9, 2012 You are welcome ;) Quote Link to comment 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.