At 23:23 -0500 11/12/02, <[EMAIL PROTECTED]> wrote:
The MySQL documentation (4.6.1) says:
You can change the character set with the --default-character-set option
when you start the server. The character sets available depend on the
--with-charset=charset and --with-extra-charsets= list-of-charset | complex
| all options to configure, and the character set configuration files listed
in `SHAREDIR/charsets/Index'. See section 2.3.3 Typical configure Options.
If you change the character set when running MySQL (which may also
change the
sort order), you must run myisamchk -r -q on all tables. Otherwise, your
indexes may not be ordered correctly.
I have a MySQL server with databases that need to begin supporting
japanese characters. Per the advice cited above, I've shut it down, restarted
it with '--with charset=sjis', and run 'myisamchk -r -q' on all tables. All
seems well enough. But when I run 'myisamchk -dvv <tablename>', the
'Character Set' line in the output indicates that the character set for tables
created before I added '--with charset=sjis' to the safe_mysqld startup script
is still 'latin1', whereas for newly created tables, myisamchk reports the
character set is 'sjis'. The fact that the output is different for tables
created before and after the change was made suggests to me that I'm over-
looking something.
When you run myisamchk -r -q, you should also add the --set-character-set=sjis
option so that myisamchk knows what character set to use.
---------------------------------------------------------------------
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
