I did nothing special to the mysql database for my english-chinese multi-language web applications. And it worded just fine.
column 'first_name' in this case is replaced by multiple columns according to the number of languages: first_name, b5_first_name, gb_first_name Language is a session variable and the application will based on it to select the right value(column) to compose the web page or update the data from inputs. The only thing important is to make sure the web page forcing the client browser to switch to the right language encoding. Especially when pulling data from client, you need to make sure the db table column for certain language will be feed by that language. +---------------+-----------------------+------+-----+ | Field | Type | Null | Key | +---------------+-----------------------+------+-----+ | first_name | varchar(24) | YES | | | gender | char(1) | YES | | | last_name | varchar(24) | YES | | | middle_name | varchar(12) | YES | | | person_id | mediumint(8) unsigned | NO | PRI | | b5_first_name | varchar(12) | YES | | | b5_last_name | varchar(12) | YES | | | gb_first_name | varchar(12) | YES | | | gb_last_name | varchar(12) | YES | | | property_dict | text | YES | | | added_date | datetime | YES | | | birth_date | date | YES | | | status_code | tinyint(4) | YES | | +---------------+-----------------------+------+-----+ ----- Original Message ----- From: "Peter Lauri" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Friday, December 02, 2005 1:25 AM Subject: Database in Thai > Best groupmember, > > > > I am in the situation to develop an web site for a Thai school and it will > be in Thai and English. How can I setup so that my tables understand the > Thai decoding (think it is UTF-8)? > > > > Thanks > > Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.11/191 - Release Date: 12/2/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
