This isn't a complete answer but it may point you in the right direction...
I had some experience of using localized text (most of the popular
languages) in a database a couple of years ago. That was using Oracle but
the lessons are the same.
Initially Oracle was not UTF-8 enabled. Alot of text c
> When I try copying and
> pasting it into the mysql client command-line, the data gets trashed.
Not necessarily. May just be that the command-line window doesn't know
to display Chinese unless you tell it to. What OS are you working on?
> For example, how do I insert the Chinese text from my so
>> When I try copying and
>> pasting it into the mysql client command-line, the data gets trashed.
>
>Not necessarily. May just be that the command-line window doesn't know
>to display Chinese unless you tell it to. What OS are you working on?
Working on Windoze with a telnet window open to a Linu
> but the different lanaguage setting in MySQL seem to
> mainly apply to its error messages
Collation and sorting, too.
> To my knowledge, MySQL does not yet
> offer full UTF-8 support
True, but UTF-8 is Unicode, and it sounds like the OP wants to work with
BIG-5, a two-byte Chinese national en