RE: MySQL 4.1.8 and storing east characters

2005-01-18 Thread Martin Gallagher
understanding. I hope this aparté can shed a little more light on this matter even though it doesn't help you much with your original predicament ;-) Cheers, Daniel - Original Message - From: "Martin Gallagher" <[EMAIL PROTECTED]> To: Sent: Monday, January 17

RE: MySQL 4.1.8 and storing east characters

2005-01-17 Thread Martin Gallagher
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 January 2005 22:09 To: Martin Gallagher Cc: mysql@lists.mysql.com Subject: RE: MySQL 4.1.8 and storing east characters So its just the Japanese titles which aren't working? The Greek and Cyrillic looked ok to me. If that&#x

RE: MySQL 4.1.8 and storing east characters

2005-01-15 Thread jeremy_march
- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 15 January 2005 20:47 > To: mysql@lists.mysql.com > Subject: Re: MySQL 4.1.8 and storing east characters > > How are you inserting the data into mysql? LOAD DATA INFILE? Be sure the > client you are using to im

RE: MySQL 4.1.8 and storing east characters

2005-01-15 Thread jeremy_march
converts ANY encoding to UTF-8 when traversing and > XML file thru DOM. > > Cheers, > - Martin > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 15 January 2005 20:47 > To: mysql@lists.mysql.com > Subject: Re: MySQL 4

Re: MySQL 4.1.8 and storing east characters

2005-01-15 Thread jeremy_march
How are you inserting the data into mysql? LOAD DATA INFILE? Be sure the client you are using to import the data is using the utf8 character set: SET CHARACTER SET utf8 or --default-character-set=utf8 The best way to check whether the data was inserted into mysql correctly is to use the mysql

MySQL 4.1.8 and storing east characters

2005-01-15 Thread Martin Gallagher
Hi, Iâve recently upgraded to MySQL 4.1.8 for the UTF-8 support. Iâve updated my previous data which was Western European languages, now Iâd like to get to grips on more exotic dialects such as Korean, Japanese and deep East languages such as Greek and Romanian. The problem is I keep