Re:How To Use UTF-8 Throughout Your Web Stack
by justincormack on Friday August 19, 2011 @05:44PM
(#2905009)
Actually utf8 in MySql is 16 bit utf8 ie compatible with the obsolete UCS2 and you should be using utf8mb4 for real utf8. http://dev.mysql.com/doc/refman/5.6/en/charset-unicode.html
[ Parent
| on HN ]
Re:How To Use UTF-8 Throughout Your Web Stack
by cpeterso on Saturday August 20, 2011 @01:46AM
(#2905919)
Thanks for the warning! I know the MySQL developers have a huge challenge to maintain compatibility with existing data and clients, but it almost seems like they're trying to make Unicode difficult to use correctly when they: default to Latin1 encoding; call it something accurate yet surprising like "latin1_swedish_ci"; silently convert and corrupt data if the client connection specifies a different encoding; add a Unicode encoding called "utf8" but don't support everything that other UTF-8 does; and finally add real UTF-8 support but call it something different like "utf8mb4".