Re: ConnectorJ and MySQL4.1 (my solution)
Re: ConnectorJ and MySQL4.1 (my solution)
- Subject: Re: ConnectorJ and MySQL4.1 (my solution)
- From: Dev WO <email@hidden>
- Date: Fri, 12 Aug 2005 02:45:29 +0200
Hi Gennady,
Changing only the database character set to utf8 didn't solve the
problem when updating row that would contain BLOB value.
For these ones I had to use:
---
alter table TABLE change COLUMN COLUMN BLOB; (not sure this one was
necessary though)
alter table TABLE change COLUMN COLUMN TEXT CHARACTER SET utf8; (this
one saved the front office)
---
and I had to search/replace all the accentuated characters because
they were all "borken" (I also try to drop and import a previous
dump, but the character were also broken)
I hope this would help for the next person who will got that problem;)
In addition to that I kept the
useUnicode=true&characterEncoding=UTF-8 in the dictionary, it
shouldn't harm as this is what should be happening, but just in case
I kept it.
Xavier
I solved the problem just setting database character set to utf 8.
it works fine with cyrillic even with connector 3.1.10 and without
"unicode=true&characterEncoding=UTF-8".
I'm happy :)
http://dev.mysql.com/doc/mysql/en/charset-database.html
Gennady
_______________________________________________
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