Troubleshooting utf8 text SQL generation
Troubleshooting utf8 text SQL generation
- Subject: Troubleshooting utf8 text SQL generation
- From: Kieran Kelleher <email@hidden>
- Date: Fri, 13 Apr 2007 06:41:41 -0400
I have a text blob attribute defined as
External Type : TEXT
Data Type : UTF Character Stream - String E
EOF is treating it as binary in the SQL generation, so I get this:
... UPPER(T3.textobject) LIKE UPPER(_binary'%argentina%') ...
instead of this which is what I should expect??
... UPPER(T3.textobject) LIKE UPPER(_utf8'%argentina%') ...
I am using MySQL. My connection string is:
jdbc:mysql://localhost/omega?useUnicode=true&characterEncoding=UTF-8
and the table is defined as:
CREATE TABLE `textblob` (
`oid` int(11) NOT NULL,
`textobject` text,
PRIMARY KEY (`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Am I correct in thinking I should not be getting _binary before the
search term?
-Kieran
_______________________________________________
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