On Tue, May 22, 2001 at 02:41:44PM -0400, Dimiter Atanasov wrote:
> Hello,
> my name is Dimiter Atanasov.
> I'm newbie in mysql servers. I have a strange problem, when i try to select
> anythik written on Bulgarian (windows-1251) I recieve a unexpected results,
> some letters are unacceptable lice a (BG) or 'n' and 'm' and the server miss
> them.
> Do you have any ideas how to overcome the problem
> (mysql - unknown-freebsdelf4) - ver of my mysql
Are you using the appropriate charset?
The easiest way to configure MySQL to use Win-1251 is to compile it from
the databases/mysql323-server port, using the following command:
make WITH_CHARSET=cp1251 WITH_XCHARSET=all fetch clean all install
If you have installed MySQL as a binary package, there might be a way
to change the currently used character set, though I'm not really sure
how to do that. The MySQL manual mentions SET OPTION CHARACTER SET,
but I've never done it that way - I've always compiled MySQL from source,
and specified the correct character set to use at build time for both
the server and the client.
G'luck,
Peter
--
This sentence claims to be an Epimenides paradox, but it is lying.
---------------------------------------------------------------------
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