The Character Set Used for Data and Sorting
Hello, MySQLman! I've got a question. I've installed standart MySQL binaries which are compiled with --with-extra-charsets=complex. The fact that I speak Russian means necessity for using --default-character-set koi8_ru (I need it for order by construction). I've red chapter in MySQL manual called 4.6.1 The Character Set Used for Data and Sorting and I've made an attempt to reconfigure special mysql files for setting koi8_ru as a --default-character-set without recompiling or compiling it but I failed... Checking all the paths, I edited /etc/my.cnf in such a way [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib character-sets-dir=/usr/share/mysql/charsets default-character-set=koi8_ru [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid But it had no result... The sorting order was not changed. There is a koi8_ru.conf in /usr/share/mysql/charsets What to do? Compile with ./configure --with-charset=koi8_ru line? Anything else? - 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
changing character set used for data and sorting
Hello, can anyone help me to solve the following problem: I've installed MySQL server Ver 8.0 Distrib 3.22.32 from FreeBSD 4.1 ports while installing OS. Now I need to make the server sort data strings encoded in koi8-ru in SELECT .. ORDER BY .. statements correctly. At this stage I don't need any other extra functionality other than sorting strings in russian language correctly. I looked through the manuals and mail lists and figured out eventually that MySQL server must be started with --default-character-set=koi8_ru. The first problem is that there is no share/mysql/charsets/ directory installed. And the second - server doesn't understand this option if I put it in /etc/my.cfn like [mysqld] default-character-set=koi8_ru There is error message in log file saying: /usr/local/libexec/mysqld: unrecognized option `--default-character-set=koi8_ru' What the server does understand is [mysqld] language=russian but it has nothing to do with the data sorting. Why does the server fail to start with the default-character-set=koi8_ru option in /etc/my.cfn? Do I have to compile it from the sources with --with-charset=koi8_ru option in order to solve the problem or I just can copy share/mysql/charsets/ from appropriate tarball distribution and restart the server? In case I have to compile it, I have to recompile php, apache and DBI as well, don't I? Please send your responses directly to my email address because I'm not subscribed to this list. Best regards, Kirill Magdalinin [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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
Re: changing character set used for data and sorting
Hi! On Feb 21, Kirill Magdalinin wrote: Hello, can anyone help me to solve the following problem: I've installed MySQL server Ver 8.0 Distrib 3.22.32 from ^^^ FreeBSD 4.1 ports while installing OS. Here's your problem. I don't know why FreeBSD Port Collection still has MySQL-3.22, while 3.23 is officially released as stable. Nevertheless, for 3.22 you should build MySQL with koi8 charset from sources. But if you're planning to build MySQL yourself anyway, I *strongly* recommend to use latest 3.23 tarball. It works ok on FreeBSD (I am, personally, using FreeBSD) - you will need gmake (from ports, e.g.) though. MySQL-3.23 is faster and has *a lot of* new features. And - to mention - all the bugfixes goes only to MySQL-3.23, MySQL-3.22 are no longer supported. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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