As I recall MySQL is not case sensitive
did you use --with-charset=koi8_ru ( or what ever) when you did ./configure
?
snip form INSTALL-SOURCE file of mysql-3.23.40
* By default, *MySQL* uses the ISO-8859-1 (Latin1) character set. To
change the default set, use the `--with-charset' option:
shell> ./configure --with-charset=CHARSET
`CHARSET' may be one of `big5', `cp1251', `cp1257', `czech',
`danish', `dec8', `dos', `euc_kr', `gb2312', `gbk', `german1',
`hebrew', `hp8', `hungarian', `koi8_ru', `koi8_ukr', `latin1',
`latin2', `sjis', `swe7', `tis620', `ujis', `usa7', or
`win1251ukr'. *Note Character sets::.
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------
----- Original Message -----
From: "BRACK" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 11:28 AM
Subject: [PHP] qwestion about %E6%E2%E0%F7%EA%E0
> Hi
>
> I'm doing the script for searching the mySQL db in Russian
> language. but output of textform
> http://localhost/indexr.php3?search_idea=%E6%E2%E0%F7%EA
> %E0 is not the same as
> http://localhost/indexr.php3?search_idea=%C6%C2%C0%D7%CA
> %C0 (this is the same word but first is lower case and second is
> upper case) so search becomes case sencitive, I don't want to
> have case sencitive search so, how can I tell to program that both
> of above are the same word?
>
> Thank you for help,
>
> Youri
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
