Your webform application must call the appropriate mysql escape string function for the language in which it is written.
Dawn Friedland wrote: >>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 > > > > --------------------------------------------------------------------- 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