On Mon, Jun 16, 2003 at 11:56:59PM +0200, Roman Neuhauser wrote:
> # [EMAIL PROTECTED] / 2003-06-16 15:27:21 +0200:
> > mysql> select * from unitest WHERE t LIKE 'A%';
> > ERROR 1210: Wrong arguments to like
>
>
> SELECT * FROM unitest WHERE <colname> LIKE CONVERT(_latin1'A%' USING utf8)
>
thanks, that works. it even works when I'm searching for *real*
unicode characters: I create a utf-8 file with sql statements from
a perl script:
open( SQL, ">:utf8", "test-select-where-like.sql" );
foreach $char ( split //, "A\N{greek:beta}cd\N{cyrillic:e}f" ) {
$i++;
print SQL "-- search vor character nor $i: $char\n";
print SQL "SELECT * FROM unitest WHERE vc LIKE CONVERT(_utf8'%$char%' USING
utf8);\n";
}
close SQL;
then i feed the file into mysql like this:
mysql --default-character-set=utf8 test < test-select-where-like.sql
and I get the correct answers.
and yes, I need the absurd "CONVERT .. utf8 ... USING utf8",
with out the CONVERT ist doesn't work.
--
Brigitte 'I never met a chocolate I didnt like' Jellinek
[EMAIL PROTECTED] http://www.horus.com/~bjelli/
http://perlwelt.horus.at http://www.perlmonks.org/index.pl?node=bjelli
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
