RE: PHP and MySQL

here's something from manual which may give you a direction: <<quote The Character Set Used for Data and Sorting By default, MySQL uses the ISO-8859-1 (Latin1) character set with sorting according to Swedish/Finnish. This is the character set suitable in the USA and western Europe. All standard MySQL binaries are compiled with --with-extra-charsets=complex. This will add code to all standard programs to be able to handle latin1 and all multi-byte character sets within the binary. Other character sets will be loaded from a character-set definition file when needed. The character set determines what characters are allowed in names and how things are sorted by the ORDER BY and GROUP BY clauses of the SELECT statement. You can change the character set with the --default-character-set option when you start the server. The character sets available depend on the --with-charset=charset and --with-extra-charset= list-of-charset | complex | all options to configure, and the character set configuration files listed in SHAREDIR/charsets/Index. See configure options. If you change the character set when running MySQL (which may also change the sort order), you must run myisamchk -r -q on all tables. Otherwise your indexes may not be ordered correctly. quote>> you can also refer to mysql mailing list win32@lists.mysql.com. regds, -----Original Message----- From: Veselina Jecheva [mailto:vessi@bfu.bg] Sent: Wednesday, February 19, 2003 17:39 To: php-windows@lists.php.net Subject: PHP and MySQL Hello everybody, I'm using PHP & MySQL running on Win2000 & IIS5 and I have the following problem with MySQL: I've got text records with cyrrilic letters and MySQL does not order the result records from a query in alphabetical order. (for example when using "order by" in a query) Any suggestions will be appreciated. Regards, Veselina