On 2001 Jun 06, Anatole <[EMAIL PROTECTED]> wrote:
>
> I installed MySQL from an RPM file on Linux. When I use the mysql>show
> variables like 'character_sets'; as you mentioned above, I do, indeed, show
> sjis.
This means that the sjis character set is compiled into the server
already, so you do not need to recompile MySQL in order to use the
sjis character set.
> So, I shutdown mysql and restarted it like this:
> safe_mysqld --default-character-set=sjis
>
> This resulted in an error message (sorry I forgot the one however something
> it to do with missing charsets I believe).
I would need to know the error message in order to guess what is
going wrong.
> I had a look around and I noticed the following charsets in
> /usr/share/mysql/charsets:
<cut>
> Alas, no sjis, but I imagine that is because it a double-byte character set.
Yes. If you had the source distribution, you would see the file
called strings/ctype-sjis.c, which contains the code needed to
handle the sjis character set.
> So, I'm left with the following question:
> 1. What do you mean by
> >More complex character sets must
> > be compiled into the server.
In order to use the more complex character sets, such as sjis,
extra code must be linked into the mysqld binary. When we build
our binary distributions, we do link in the extra code for all of
the more complex character sets.
> And how would I go about doing this?
You do not need to do this, since you are using a standard binary
that already includes all of the more complex character sets.
Tim
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Tim Smith <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team
/_/ /_/\_, /___/\___\_\___/ Boone, NC USA
<___/ www.mysql.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
