Correct character sets settings with mysql 4.1.10?
Correct character sets settings with mysql 4.1.10?
- Subject: Correct character sets settings with mysql 4.1.10?
- From: Wolfram Stebel <email@hidden>
- Date: Fri, 08 Jul 2005 08:50:01 +0200
Hi all,
on mac-osx 10.4.1 the new mysql version in connection with jdbc connector
3.1.x requires settings for character sets.
(I've been using mysql 4.0.1 with connector 3.0.16 before without the need
to configure this...)
I have a problem with german "umlaut" (äöü etc.) in memo fields (BLOB). All
"Umlauts" display as a "?" when retrieved from database, saving changes
results in an exception:
com.webobjects.eoaccess.EOGeneralAdaptorException:
updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in
database
What are the correct settings for server, connector and client layer?
In the moment there are all character_set_* variables are set to "latin1"
except the character_set_system which is utf8.
What is the corresponding collation?
In the moment there are all set to latin1_swedish_ci.
Could someone please provide a copy of a well working variable setting for a
german "umlaut"?
I hope it does not depend on the EOModel, where all those fields are defined
as "BLOB", value class "String".
Thanks
Wolfram
_______________________________________________
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