Re: Using a foreign character set in MYSQL

2003-08-11 Thread Matthew McNicol
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

Re: Using a foreign character set in MYSQL

2003-08-06 Thread Joel Rees
> 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

Re: Using a foreign character set in MYSQL

2003-08-06 Thread Vikram Vaswani
>> 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

Re: Using a foreign character set in MYSQL

2003-08-06 Thread Joel Rees
> 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