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
Re: Database in Thai
UTF-8 is the encoding would want to use for Thai. Also see: http://dev.mysql.com/doc/refman/4.1/en/charset-asian-sets.html Cory. Peter Lauri wrote: 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)? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database in Thai
Nope it 's tis-620. Man. Please feel free to reply to this email if you have additional questions or concerns ??? 01-7499093 ? ???, ???, ? ???. 01-749-9093, 02-938-8301 http://www.EasyHorpak.com - ???, ?, ??, ??? http://www.EasyHorpak.com/webdesign - ??? http://www.EasyHorpak.com/internet - http://www.EasyHorpak.com/software - http://www.EasyHorpak.com/move - ?? http://www.EasyHorpak.com/coin - ? - Original Message - From: Peter Lauri [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 02, 2005 3:25 PM 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database in Thai
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]