How to configure MySQL 3.23.30-gamma for FreeBSD 4.2 w/o crash?

2001-03-21 Thread Apisilp Trunganont
Dear all, Now I'm using binary distribution of MySQL 3.23.30-gamma for FreeBSD 4.2. The size of mysqld is 1339436 bytes. It can work well without any crash. But I need to use charset tis620 so I use 2 parameters when I call mysqld. --character-sets-dir=/usr/local/share/mysql/charsets --default-

Problem in SELECT for Thai language.

2001-03-21 Thread Apisilp Trunganont
Dear, I use MySQL 3.23.30-gamma for unknown-freebsdelf4.2 (i386) and found some problem when I try to use SELECT for Thai text. Ok... I try to use this query... SELECT Nickname FROM resume WHERE Nickname='ÀÕÁÐ'; ÀÕÁÐ = ASCII #192 #213 #193 #208 but I get the result 'ÀÕÃÐ' instead. ÀÕÃÐ = ASCI

Problem in SELECT for Thai language.

2001-03-21 Thread Apisilp Trunganont
Dear, I use MySQL 3.23.30-gamma for unknown-freebsdelf4.2 (i386) and found some problem when I try to use SELECT for Thai text. Ok... I try to use this query... SELECT Nickname FROM resume WHERE Nickname='ÀÕÁÐ'; ÀÕÁÐ = ASCII #192 #213 #193 #208 but I get the result 'ÀÕÃÐ' instead. ÀÕÃÐ = ASCI