View Single Post

   
  #2 (permalink)  
Old 06-17-2008, 04:02 AM
John Nagle
 
Posts: n/a
Default Re: Any real reason need to use UTF8 as table character set?

setesting001@gmail.com wrote:
> Currently I am justing using Latin1 as Table character set to store
> UTF8 data, it work very well.


If you think that's working, you're not testing enough.
>
> I don't need those collation stuffs for my data, are there any real
> reason I need to use UTF8 as table character set then?


If you use ">" or "<" or ORDER BY on those fields, and the
fields actually have UNICODE data in them, the results will be weird.
None of the string operators, like CONCAT, will work right.

If you're going to treat UTF8 data like that, you might just
store it as a BLOB, viewed as opaque by the database. That
locks out all the operations which will do the wrong thing on
misinterpreted data.

John Nagle
Reply With Quote