RE: multilanguage web application with mysql database?

2007-05-04 Thread Jerry Schwartz
Are all of your fields using the UTF8 character set? I think that's necessary. We use UTF8 and have stored Chinese characters successfully using UTF8 with a PHP web application. (At least, they look right to me - I don't know Chinese at all.) Regards, Jerry Schwartz Global Information

Re: multilanguage web application with mysql database?

2007-05-04 Thread Michael Monaghan
I have many tables like the table Person:below, in mysql database. person_id, first_name,last_name, mi, gb_first_name, gb_last_name, b5_first_name, b5_last_name, gender, dob where different columns storing strings in different encodings. All the strings/fields etc. need to be in the *same*