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 PROTECTED])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/webobjects%
40anazys.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([EMAIL PROTECTED])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
