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
