Re: Troubleshooting utf8 text SQL generation
Re: Troubleshooting utf8 text SQL generation
- Subject: Re: Troubleshooting utf8 text SQL generation
- From: Kieran Kelleher <email@hidden>
- Date: Fri, 13 Apr 2007 14:58:32 -0400
Hi guys, thanks for replies. The field is a type TEXT, so it does
support encoding.... by chance I noticed the SQL was casting my
search terms to _binary and that seems wrong.
On Apr 13, 2007, at 7:44 AM, Dev WO wrote:
Hello Kieran,
Someone will probably come up with an alternative, but I've never
been to be able to make blob work the way I wanted with UTF-8. I
had to convert my blob to mediumtext.
As far as I know (but I'm not a db expert;)) blob can't have an
encoding like a mediumtext for example.
Xavier
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:
40anazys.com
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