To perform correct ORDER BY I need to use win1251 charset. I know that this can be set from my.cfg or in the my.ini:
[mysqld] default-character-set=win1251 The problem is that I cant use this because I have limited account on my hosting provider's server (I can't restart the server and I even don't have write permissions for these files). So I want to change it for session with "SET server_variable" command. (http://www.mysql.com/doc/en/SET_OPTION.html) - But How ??? show variables like "character_set"; +---------------+--------+ | Variable_name | Value | +---------------+--------+ | character_set | latin1 | +---------------+--------+ SET character_set=win1251; #Returns error ! Thank You in advance, Mirko P.S. Server: MySQL v3.23.55; Client: mysql client, PHP, Perl-DBI. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php