Hi! On Dec 16, Igor Zinkovsky wrote: > I can't find in MySQL 4.1.1 documentation anything about > 'character_set_system' variable. It is setted up to 'utf8'. How can I > change it to be able to use russian KOI8-R in mysql client?
You cannot change it. But you don't need to either. It is character set for "system" usage - usernames, table, column names etc. To use KOI8-R in MySQL client you need to 1. Be sure you can actually type and see koi8-r characters - you need to setup you terminal program/console properly for this 2. Issue "SET NAMES koi8r;" from mysql command line client or start it with --default-character-set=koi8r (or put default-character-set=koi8r in ~/.my.cnf) - to inform the server that you send queries and want to receive results in koi8r charset. That's all! Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]