I use now Java driver with UTF8 charset and works OK. I think that it will work even if you use cp1250 in MySQL. Are you was trying Java driver? As I say, many days I was spend trying to migrate my MSAccess data to MySQL and correctly read and write it from OO. It was impossible with ODBC, then when I use Java it works OK, because data in Access was in UTF8 (this is much complicated, with cp1250 that will be easier). But if it not work, sorry, I am only begining to use MySQL, and I have dont know how to help you better.
Pozdrav! -----Original Message----- From: Juraj Trenkler [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 15, 2005 5:23 PM To: [email protected] Subject: Re: [dba-users] MySQL and char-sets Dna Ut 14. Jún 2005 22:57 Paun napisal: > If you use MyODBC driver this is because MyODBC driver have no full Unicode > compatibility. > > You must avoid it, and yse MySQL connector/Java driver. It's working OK, at > least in serbian :) > Many people who use MyODBC have the same problem, and as I read in > e-forums, there will be ok in new version of MyODBC driver. > I can try Java driver but it has to be set up for cp1250 char set and I am not sure how to do it. But I am not sure if this is the problem. OOo displays my fields correctly so there is maybe something with interpretation of char set when I change char set in MySQL. My problem is that when MySQL fields are declared as latin1 char set I can write into them characters from other char sets (in my databases windows-cp1250) and OOo displays them correctly. But in select commands I get wrong collation. And when I change in MySQL char set property to cp1250 then OOo displays characters wrong. juraj --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.2/14 - Release Date: 14/06/05 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.2/14 - Release Date: 14/06/05 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
