Database in Thai

2005-12-02 Thread Peter Lauri
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

2005-12-02 Thread Cory @ SkyVantage
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

2005-12-02 Thread EasyHorpak.com

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

2005-12-02 Thread YL
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]