problem with retrieving non-latin1 data from mysql

case sensitive where it shouldn't be

[oljal]

Hello,

here's the problem:

i have mysql database with some windows-1250 characters inserted in one table as TEXT type (therefore, case INsensitive, right?). PHP script searches this table looking for a keywords given through a web form. Search fails if one enters keywords with win1250 characters in lowercase, but it returns proper values if the characters are given in uppercase. I've tried to transform keywords with strtoupper() function before executing sql query, but it fails on the opposite case, when stored data is in lowercase...

Mysql server version is 3.23.58 and PHP is 4.3.4.

I know this post is maybe more for some mysql-type-forum, but i hope someone can help.

Thanks in advance.

[jatar_k]

Welcome to WebmasterWorld oljal,

try using strtoupper in your php and UPPER in your query
[dev.mysql.com...]