List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 17 1999 2:26pm
Subject:MySQL 3.23.3, russian characters and LIKE
View as plain text  
>>>>> "Khimenko" == Khimenko Victor <khim@stripped> writes:

Khimenko> LIKE does not work with russian characters in MySQL 3.23.3 :-/ Here is the
> fix.
Khimenko> Problem is in comparision `likeconv(*str) != cmp' on line 583...

Khimenko> I'm not sure if it's correct fix but at least I can use LIKE now :-)

Khimenko> --- sql/sql_string.cc
Khimenko> +++ sql/sql_string.cc
Khimenko> @@ -518,7 +518,7 @@
Khimenko>        if (str == str_end)
Khimenko>  	return result;
 
Khimenko> -      char cmp;
Khimenko> +      uchar cmp;
Khimenko>        if ((cmp= *wildstr) == escape && wildstr+1 != wildend)
Khimenko>  	cmp= *++wildstr;
Khimenko>  #ifdef USE_BIG5CODE

Hi!

Could you try this instead:

Change the likeconv macros to:

#ifdef LIKE_CMP_TOUPPER
#define likeconv(A) (char) toupper(A)
#else
#define likeconv(A) (char) my_sort_order[(uchar) (A)]
#endif

Regards,
Monty
Thread
MySQL 3.23.3, russian characters and LIKEKhimenko Victor16 Sep
  • MySQL 3.23.3, russian characters and LIKEMichael Widenius17 Sep
    • Re: MySQL 3.23.3, russian characters and LIKEKhimenko Victor17 Sep