#23267 [Opn->Bgs]: mysql select bug with accentuated letters

ID: 23267 Updated by: georg@php.net Reported By: lysander at faker dot hu -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Win XP prof PHP Version: 4.3.1 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. In the bundled mysql library only charset latin1 is supported. In this charset á and a have the same collating order. Solution: use external mysql library with csas charsets (case sensitive, accent sensitive) Previous Comments: ------------------------------------------------------------------------ [2003-04-18 04:45:10] lysander at faker dot hu My problem is the next: if I use mysql_query("SELECT pass FROM regusers WHERE user='gáb'") it converts down somehow my accentuated a letter. á -> a and gives back the result of the row where the username is "gab" istead of "gáb" (a row with user gáb does not exists) phpmyadmin does the same "mistake", of course. in a mysql client it works fine. mysql> select pass from regusers where user='gáb'; Empty set (0.07 sec) I've tried this at debian linux too, with other versions, it does exactly the same. what is the problem then? I hope not a bug, that would be better if I made a mistake. Please check me back as soon as possible. Lysander ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23267&edit=1