List:General Discussion« Previous MessageNext Message »
From:Juri Shimon Date:April 15 2004 9:03am
Subject:international LIKE in 4.1.1-alpha
View as plain text  
Hi!
Win2000, MySql 4.1.1-alpha, cp1251

select 'ГОНЧАРА' like '%ГОНЧАРА%'    -> 1
select 'ОЛЕСЯ ГОНЧАРА' like '%ГОНЧАРА%'    -> 0


It's a pity  8(

Hint :
select 'ОЛЕСЯ ГОНЧАРА' like '%%ГОНЧАРА%'    -> 1    (change leading
% to %%)

Variables:
character_set_system=utf8
character_set_server=cp1251
character_set_database=cp1251
character_set_client=cp1251
character_set_connection=cp1251
character_set_results=cp1251

Thanks!

Thread
international LIKE in 4.1.1-alphaJuri Shimon15 Apr
  • Re: international LIKE in 4.1.1-alphaVictoria Reznichenko15 Apr
  • Re: international LIKE in 4.1.1-alphaJuri Shimon15 Apr
    • Re: international LIKE in 4.1.1-alphaVictoria Reznichenko15 Apr