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