> Hello, > > I have a table with the following column among others: > > text VARCHAR(120) CHARACTER SET utf8 > > The provider I am using however only offers MySQL version 3.23.58, > so I cannot use this statement. At first I thought I was not going > to be able to store UTF8. So I changed the column to the following: > > text VARCHAR(120) > > However, when I submit data from a web interface, much to my > surprise, I was able to store some Chinese characters, which > no doubt take up two bytes in UTF8. > > Great!!! > > Can anyone explain why this is and what > exactly is going on under the hood?
With the earlier versions you are able to store utf8 data but you cannot take advantage of case-insensitive character comparisons or correct sort order etc. You should probably change the Chinese columns from VARCHAR to one of the BLOB types so the data is treated as binary. > Just curious, > > Thanks, > > Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
