> 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.
Okay, but after 'myisamchk -r -q --set-character-set=sjis <table>' is
run, 'myisamchk -dvv <table>' still reports the character set of the table as
being the old 'latin1', not 'sjis', so I'm still thinking I may need to drop
and recreate all my tables.
Thanks for your reply.
-Mark
---------------------------------------------------------------------
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
