Re: Re: PDO don't know which is mysql server charset?

On 21 May 2010 10:47, Lester Caine <lester@lsces.co.uk> wrote: > Peter Lind wrote: >>> >>> The problem here is that PHP still does not know how to handle UTF8 >>> >  properly > >> It's not*just*  that PHP isn't handling utf8 perfectly. Encoding >> between database and server is a rather complex issue, you're dealing >> with: >> * database encoding >> * database connection encoding >> * php internal encoding >> * output encoding >> >> Messing up just *one*  of these will give bad output - so you need to >> make sure that all of them are aligned. > > And not simply assume that because everything is SET to UTF8 - that is > actually what is being handled :( > The holes in the process such as with MySQL/PDO need to be well documented, > which is what tikiwiki are working through now, but should be in the PHP > documentation? > A good reference in the PHP docs would be valuable - otherwise you're searching wikis and blogs for the answer. Regards Peter -- <hype> WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 </hype>