International characters and queries to MySql
International characters and queries to MySql
- Subject: International characters and queries to MySql
- From: Gino Pacitti <email@hidden>
- Date: Wed, 24 Dec 2003 17:52:25 +0000
I have two problems with using international characters and creating a
query.
1. I have the web page able to display an encoded URL :
?WOURLEncoding=UTF8&item=Düsseldorf"> so the display is fine
but when the url is clicked the receipt of that url and the handling of
the item value turns into D\237sseldorf.
I have
public void appendToResponse(WOResponse r, WOContext c){
r.setDefaultURLEncoding("UTF-8");
super.appendToResponse(r, c);
}
in the Application class and the same in the Session class.
As the url is pointing to a direct action I also set this too in the
action method :
this.request().setDefaultFormValueEncoding("UTF-8");
The database has this attached to the connection URL :
?useUnicode=true&characterEncoding=UTF-8&capitalizeTypeNames=true
2. Even when I hack the code and provide the actual name "D|sseldorf"
in the query I still cannot contact the record :
<com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT
t0.categoryID, t0.title FROM tLocation t0 WHERE t0.title = ?"
withBindings: 1:"D|sseldorf"(title)>
com.webobjects.eoaccess.EOObjectNotAvailableException:
objectMatchingValueForKeyEntityNamed: No Location found with key title
matching D|sseldorf
But I know I have the title in the Location table set with the name
D|sseldorf
I am using Mysql 3.23.53 and Wo 5.2.1 and jdbc adaptor
jdbc2_0-stdext.jar and mm.mysql-2.0.13-bin.jar and on OSX 10.2.8
Any help would be appreciated...
best
Gino
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.