[wp-hackers] Character encoding?

[Ryan Boren]

On 1/30/07, Ryan Boren <ryan at boren.nu> wrote:
> 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.

Let's track this with ticket #3517.

http://trac.wordpress.org/ticket/3517

I added a patch and a comment.

Ryan