Hi You can store Unicode text in a binary column (BLOB) and convert it to/from native Unicode format in your application. The most efficient form is likely to be UTF-8 format, which has a variable character length (the lower 128 characters are the same as ASCII). I have such a database that is storing Japanese, Arabic, Chinese, Russian etc. as UTF8, and converts to a Java String by specifying the "UTF8" encoding:
byte[] bytesStory = rs.getBytes ("utf8Column"); String strStory = new String (bytesStory, "UTF8"); The disadvantage of storing Unicode in a BLOB is that you can't really index or search these columns, unless your UTF8 happens to be all ASCII (in which case why use a BLOB?). Phil White ----- Original Message ----- From: "Tuy Le" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 26, 2001 4:03 AM Subject: Unicode > Hello, > > Currently, MySQL doesn't support Unicode, does it? Which version will > support? > > Are there any ways to use Unicode with MySQL? Can I insert data under binary > mode? > > Please reply me as soon as possible. > > Thanks for your support. > > Tuy Le > > PS: Sorry to send mail to you directly because I don't know where to find > the answers. > > > > > --------------------------------------------------------------------- > 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