Re: Troubleshooting utf8 text SQL generation
Re: Troubleshooting utf8 text SQL generation
- Subject: Re: Troubleshooting utf8 text SQL generation
- From: "Daniele Corti" <email@hidden>
- Date: Fri, 13 Apr 2007 13:06:22 +0200
2007/4/13, Kieran Kelleher <email@hidden>:
I have a text blob attribute defined as
External Type : TEXT
Data Type : UTF Character Stream - String E
Maybe I'm wrong, because I'm not a DB expert, but an UTF Character Stream is not text, but binary, while reading you'll get the text the stream point to, but the type of the field is binary (and so WO sees it as a binary, and treats it thereby)
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.
AIM: S0CR4TE5
Messenger: 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