Re: Difficulty with thai columns
On Tuesday 26 August 2003 04:54, you wrote: > By client character set I assume you mean what do I type into mysql? > utf-8. I think. How can I tell? If you - don't specify default-character-set in the my.cnf for the client - don't run mysql --default-character-set=utf8 - don't execute SET CHARACTER SET utf8 then client character set is default (latin1). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Difficulty with thai columns
John Francis Lee <[EMAIL PROTECTED]> wrote: > > I've downloaded 4.1 and am experimenting with a thai-english word list > to discover just how this will work with mysql. > > So far I'm not having success. > > First I tried > create table words ( > thai varchar(30) character set tis620, > thai_sense int, > english varchar(30) character set latin1, > english_sense int > ) ; > > But when I tried > insert into words_utf8 ( > thai_word, > thai_sense, > english_word, > english_sense > ) values ( '???', 1, 'water', 1) ; > > I got a broken connection. You created a table 'words', but tried to insert data into table words_utf8. > > I figured this was because I was entering utf8 and expecting tis620. > > So I > CREATE TABLE words_utf8 ( > thai_word varchar(30), > thai_sense int, > english_word varchar(30), > english_sense int > ) TYPE=MyISAM CHARSET=utf8 > > (coincidentally I had to edit the 'invariant' output of 'show create > table' to make this work. There were extraneous forward quotes around > the table and column names that made mysql choke.) > > And then the simple insertion worked ok, but the output from a select > > mysql> select * from words_utf8 ; > +---++--+---+ > | thai_word | thai_sense | english_word | english_sense | > +---++--+---+ > | ??? | 1 | water| 1 | > | ??? | 1 | water| 1 | > | ??? | 1 | water| 1 | > +---++--+---+ > 3 rows in set (0.00 sec) > > shows unrenderable characters for the Thai. > > So what do I do about this? > What is your client character set? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Difficulty with thai columns
Hello, I've downloaded 4.1 and am experimenting with a thai-english word list to discover just how this will work with mysql. So far I'm not having success. First I tried create table words ( thai varchar(30) character set tis620, thai_sense int, english varchar(30) character set latin1, english_sense int ) ; But when I tried insert into words_utf8 ( thai_word, thai_sense, english_word, english_sense ) values ( 'นำ้', 1, 'water', 1) ; I got a broken connection. I figured this was because I was entering utf8 and expecting tis620. So I CREATE TABLE words_utf8 ( thai_word varchar(30), thai_sense int, english_word varchar(30), english_sense int ) TYPE=MyISAM CHARSET=utf8 (coincidentally I had to edit the 'invariant' output of 'show create table' to make this work. There were extraneous forward quotes around the table and column names that made mysql choke.) And then the simple insertion worked ok, but the output from a select mysql> select * from words_utf8 ; +---++--+---+ | thai_word | thai_sense | english_word | english_sense | +---++--+---+ | ???ำ??? | 1 | water| 1 | | ???ำ??? | 1 | water| 1 | | ???ำ??? | 1 | water| 1 | +---++--+---+ 3 rows in set (0.00 sec) shows unrenderable characters for the Thai. So what do I do about this? Any help greatly appreciated. -- John Francis Lee 1/9-10 Thanon Trairat Muang Chiang Rai 57000 Thailand -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]