Welcome Guest, Not a member yet? Register   Sign In
TEXT vs Varchar : need your advice.
#5

[eluser]jpi[/eluser]
I believe you can't set a varchar with a length greater than 255.

From mysql doc :
Quote:Before MySQL 5.0.3, a CHAR or VARCHAR column with a length specification greater than 255 is converted to the smallest TEXT type that can hold values of the given length

Quote:As of MySQL 5.0.3, a CHAR or BINARY column with a length specification greater than 255 is not silently converted. Instead, an error occurs.


Messages In This Thread
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 04:07 AM
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 05:33 AM
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 05:40 AM
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 07:55 AM
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 08:00 AM
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 10:30 AM



Theme © iAndrew 2016 - Forum software by © MyBB