News for hackers. Stuff that matters.
Re:How To Use UTF-8 Throughout Your Web Stack by cpeterso on Friday August 19, 2011 @06:55PM (#2905203)
MySQL seems to be the cause of many of the web's character encoding problems; search for keywords like "mysql utf8 hell" and you will get many hits.

Are the MySQL developer doing anything to improve the situation? Here are some possible improvements of the top of my head. I won't call them solutions. <:)

  1. Use UTF-8 internally, converting based on the client's encoding.
  2. Use UTF-8 internally and force client's to do their own conversions.
  3. Tag all string data with its encoding type for run-time checks.
  4. At the very least, default to UTF-8 rather than latin1-swedish-ci!
Re:How To Use UTF-8 Throughout Your Web Stack by Joakal on Friday August 19, 2011 @07:28PM (#2905282)
There's many utf8 collations so you should specify something specific to default to. I recently read to use utf8_unicode_ci [0] is the best.

[0] http://philsturgeon.co.uk/blog/2009/08/UTF-8-support-for-Cod...