> CREATE TABLE Customers ( Name VARCHAR(100) ); > > Now ... if your customers have names in Japanese, Russian and German, > how do you compile MySQL so it can store them all in > Customers? You use > Unicode with a binary field and do post-processing work (like > ORDER BY) > yourself.
I have tried your suggestion. If I am using a binary field, wouldn't it look like this: CREATE TABLE Customers ( Name varchar(100) binary ); I have saved my notepad file as Unicode. I copy/paste to a web form and submit to a field of type varchar binary. (I also try with varchar, char, blob, mediumtext). The characters still break. I copy/paste directly to command prompt. Characters still break. Thanks for your input. I am welcome to hearing more ideas. Perhaps I am missing something (likely). Dawn > -----Original Message----- > From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 30, 2002 5:35 AM > To: Joel Rees > Cc: Dawn Friedland; [EMAIL PROTECTED] > Subject: Re: Japanese Charset > > > Joel Rees wrote: > > >>If I compile MySQL using --with-charset=sjis , how will it > handle the > >>Latin, Chinese, and Korean characters? > >> > >> > > > >Multiple databases on multiple servers? > > > > Try this one on for size: > > CREATE TABLE Customers ( Name VARCHAR(100) ); > > Now ... if your customers have names in Japanese, Russian and German, > how do you compile MySQL so it can store them all in > Customers? You use > Unicode with a binary field and do post-processing work (like > ORDER BY) > yourself. > > -- > Michael T. Babcock > C.T.O., FibreSpeed Ltd. > http://www.fibrespeed.net/~mbabcock > > > --------------------------------------------------------------------- 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
