Re: ConnectorJ and MySQL4.1
Re: ConnectorJ and MySQL4.1
- Subject: Re: ConnectorJ and MySQL4.1
- From: Dev WO <email@hidden>
- Date: Tue, 9 Aug 2005 02:25:37 +0200
Hi list,
I really can't believe I'm the only one with this issue in fact, but
debugging it may help someone soon as it must happen...
You are not alone.
It's not helping us, but I feel less "dummy";)
I've been curiously readind your thread while preparing to move my
CYRILLIC app to MySQL.
Now I have the same problem. MySQL 4.1.13 , WO 5.2.4 , xCode 2.0
I used you settings for connector and they really do not work.
Even for reading the data?
The useOldBehavior did help for that. But it wasn't enough.
I tried to resolve the problem using YourSQL and here is what I' found
When server connecrion Character set is UTF-8 it refuses to take
cyrillic
characters.
Cyrillic only works good only when Character set is "UTF-8 + latin1
(server)"
How do you specify 2 character sets??
maybe it is server issue but not connector?
I think it's a mix of both:
before 4.1 we sere using the "useUnicode=true&characterEncoding=utf8"
in the dictionary connection (did you have the same setting?), so the
data wasn't really saved as UTF-8 I think, but it would allow the
connector to talk to the WO application in UTF-8. But now, I think we
need to "update" all raw to get reinterpreted to UTF-8 (and not
converted), but I feel like there will be issue then when we'll add
row to the database...
now i'm reading server manual to find put how to set default
encoding to UTF8
you can do it using Terminal, when the MySQL server is off with:
mysqld --default-character-set=utf8 --user=root -p to launch the
MySQL server, it will default it to UTF-8
Hope we'll find the way
Gennady
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40anazys.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden