Re: Correct character sets settings with mysql 4.1.10?
Re: Correct character sets settings with mysql 4.1.10?
- Subject: Re: Correct character sets settings with mysql 4.1.10?
- From: "Alberto de Arriba" <email@hidden>
- Date: Fri, 8 Jul 2005 12:18:17 +0200
I haven't tried umlaut but I wasn't able to make spanish accents work with
latin1. UTF-8 works fine. What you have to do is create the database in
UTF-8 (I use "utf8_general_ci" as collation, perhaps other utf8_* work as
well).
The JDBC connection URL should be something like:
jdbc:mysql://[host]/[database]?capitalizeTypeNames=true&useUnicode=true&characterEncoding=UTF-8
Take a look at
http://wodev.spearway.com/cgi-bin/WebObjects/WODev.woa/2/wa/Main?wosid=false&wikiPage=InternationalCharacters
----- Original Message -----
From: "Wolfram Stebel" <email@hidden>
To: "WebObjects-List Apple" <email@hidden>
Sent: Friday, July 08, 2005 8:50 AM
Subject: Correct character sets settings with mysql 4.1.10?
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
_______________________________________________
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