multilanguage web application with mysql database?

2007-05-04 Thread YL
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. At anytime, a web user can switch the language and the

RE: multilanguage web application with mysql database?

2007-05-04 Thread Jerry Schwartz
Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: YL [mailto:[EMAIL PROTECTED] Sent: Friday, May 04, 2007 10:19 AM To: mysql@lists.mysql.com Subject: multilanguage web application with mysql database? I have many tables like

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*