I found a solution!!! ***Replace all backlashes with two backslashes.*** (The hex value of the backslash is 0x5c, see Joel Rees' previous emails for an explanation on how multibyte Japanese characters contain the hex value 0x5c and that MySQL uses that value as an escape character.)
VBscript used prior to submitting data to database: ~~~~~~~~~~~~~~~~~~~~~~~~ szJapaneseText = replace(szJapaneseText, "\","\\") ~~~~~~~~~~~~~~~~~~~~~~~~ Pulling from the database and displaying to a web page requires no additional processing. Simply display. Thank you so much for all your time and effort reading and responding to my emails. Joel Rees - You insisted it was 0x5c from the beginning. I was so slow to understand because of everyone's talk of UTF-8, was it Word, was it my content tool, is MySQL capable of storing multiple charsets per database, etc. Thank you immensely for your patience and all your help. Gerald Clark - It was your simple, brief message that made me think, "Is it that simple?" It is. Michael Babcock, Shashank Tripathi, Jon Frisby, Brian Duke, kayamboo, Kirk Samuelson - Thank you for just being there and responding with hope that there is a solution - without which I would not have persisted on. I know this is all so sappy, but this was the most lengthy, most frusterating, and hopeless problem solving event of my life. I am glad it is over (and now maybe I'll get paid). The most unsurprising thing is that it was so simple: one line of code. Sincerely, Dawn Friedland [EMAIL PROTECTED] > -----Original Message----- > From: gerald_clark [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 30, 2002 1:16 PM > To: Dawn Friedland > Cc: Michael T. Babcock; [EMAIL PROTECTED] > Subject: Re: Japanese Charset > > > 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
