KyleMassacre Posted February 9, 2012 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
Spudinski Posted February 9, 2012 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
a_bertrand Posted February 9, 2012 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
Spudinski Posted February 9, 2012 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
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.