[wp-hackers] Character encoding?

[Ryan Boren]

On 1/30/07, Lloyd Budd <lloydomattic at gmail.com> wrote:
> Posts like http://climbtothestars.org/archives/2007/01/29/invalid-argument-supplied-for-foreach-in-wp-capabilitiesphp-case-cracked/
> and the regular questions on the forums is a near continuous reminder
> that WordPress needs a comprehensive solution to character encoding.
>
> http://trac.wordpress.org/ticket/3517 seems to have good context, but
> it is not an area that I have strong technical knowledge. I am about
> smart enough to read
> http://www.joelonsoftware.com/articles/Unicode.html , but that is
> about it.
>
> Does someone on these lists have the expertise to make these problems history?

We have to be careful about doing any of this to upgraded
installations.  New install are a different matter.  When creating the
tables we can try things like using ENGINE instead of TYPE for MySQL >
4.0.18 and 4.1.2 and setting CHARACTER SET = utf8 for MySQL > 4.1.

Ryan