Hi !
I know this post is very old but I had the same problem some days ago. I finally found the solution. So, in case you would like to come bask to MySQL, here is what worked for me :
instead of just altering the Mysql database, I changed my server charset to utf8 : modify the file "/usr/local/mysql/support-files/mysql.server" (at least on my configuration) and add "--character-set-server=utf8" to the "start" target where the mysqld is started
Hope that helps !
Fabrice
On Aug 19, 2005, at 7:19 PM, Jim Kuo wrote: I found someone else was having the exact problem in the archive, it turned out he had to use postgresql instead.
So i changed my database to postgresql 7.3 (what my isp uses), and the UTF-8 characters from both .wo file and database display properly now, yeah!!
Thanks for your help and suggestions. On 6 Apr 2005, at 05:13, Kushnir Gennady wrote: On 18.08.2005, at 22:17, Jim Kuo wrote: I tried everything you suggested, added those methods in Application.java, Sesson.java and DirectionAction.java. I have also added "unicode=true&characterEncoding=UTF-8" to JDBC connection string,
I have done "alter data [database] default character set utf8 collate utf8_bin"
I am using,
- WebObjects 5.3 - Mac OSX 10.4.2 - MySQL 4.1.13 - JDBC connector 3.1.10
Unfortunately , the symptom remains, that if i have the line woresponse.setContentEncoding(_NSUtilities.UTF8StringEncoding); in my code, then the UTF-8 strings in .wo files display ok, but the data coming out of database is not. Take that line away, the reverse happens.....
well... that's strange.
is your WO Builder set to use UTF-8 as default encoding? Ah, you are on 5.3 so you can not change this setting just choosing from popup. If you try WO Builder will refuse to work.
I tried 5.3 and then returned to 5.2.4 but I've found the way to overcome that bug.
You should find com.apple.WebObjectsBuilder.plist in your ~/Library/Preferences folder and write NSUTF8StringEncoding for DefaultEncoding key.
However I don't know how to change already created components. Look at their html source: unicode characters are replaced with their codes like or &1234; Maybe you'll have to retype your non ASCII text in wo components after changing WO Builder preferences.
_______________________________________________ Do not post admin requests to the list. They will be ignored. Help/Unsubscribe/Update your Subscription:
www.icconsulting.mc
International Corporate Consulting Palais de la Scala 1 avenue Henri Dunant Suite 1155 MC - 98000 Monaco
Skype: fabrice.pipart Tel. +377 97 98 21 04 (direct) Fax. +377 97 70 88 07
|
