4.0.18 does not support Unicode. The JDBC driver tries to set the UNICODE charset but can't because this mysql version cannot store Unicode data as a charset. If you used 4.1.1, which is alpha it supports the charset and correlations.
My suggestion is this. Store the blobs on NAS as UNICODE text. mySQL is now used a lookups to the blob data in a particular even hashed directory structure on the NAS device that holds the UTF-8 or UCS data. If this is not available to you, then use 4.1.1 and don't use subselects, that is the most unstable portion of this branch. > -----Original Message----- > From: news [mailto:[EMAIL PROTECTED] On Behalf Of Stormblade > Sent: Thursday, April 22, 2004 5:33 PM > To: [EMAIL PROTECTED] > Subject: My Unicode Woes - Plz Help!!! > > I'm posting this as a last ditch effort to get this working or at least > find out what's going on and perhaps get a workaround if one exists. > > Platform: Windows XP SP1 > Database: MySQL 4.0.18 > JDBC Drv: 3.0.11 > > History: > There is an existing website which uses ColdFusion/SQLServer. The owner of > this website used Microsoft Word to create some text and he pasted this > into a form field. This was inserted into the SQLServer database. > > Now, Here is what I have so far: > > 1. ColdFusion/SQLServer - Original site. Data entered into a form and > inserted into the SQLServer Database. Retrieved with query and displayed > on > page. Unicode characters are displayed as their proper symbols. > > 2. JSP/SQLServer - New Site. Retrieved the data from the SQLServer > database > and displayed it. Same database as in #1. Same data and same query. This > also worked fine. Unicode was displayed as their proper symbols. > > 3. JSP/MySQL - Exported the data to an Access Database. Opened database in > Access to verify that the data and unicode were there. Unicode was > displayed as proper symbols in Access. Imported into MySQL. Used Navicat, > EMS MySQL Manager and SQLyog to view the data in MySQL. > > Navicat displayed the unicode in the data as blocks. > EMS MySQL Manager displayed the unicode as their proper symbols. > SQLyog displayed the unicode in the data as blocks. Same as in Navicat. > > So the data does contain non-Ascii characters and I'm assuming they are > unicode. > > Now some further information of my setup. > > Default charset on database: latin1 > Table DDL: > CREATE TABLE `article` ( > `ID` bigint(20) NOT NULL auto_increment, > `Author` varchar(150) NOT NULL default '', > `Title` varchar(150) NOT NULL default '', > `Body` longtext NOT NULL, > `Date` datetime NOT NULL default '0000-00-00 00:00:00', > `Category` char(2) NOT NULL default '', > PRIMARY KEY (`ID`), > UNIQUE KEY `ID` (`ID`), > KEY `Category` (`Category`) > ) TYPE=InnoDB > > The Body column is the column that contains the unicode data. > I am accessing the database from Java through the JDBC driver. My URL > looks > like this: > > jdbc:mysql://localhost/thedatabase?useUnicode=true&characterEncoding=UTF-8 > > I played around with this. If I leave off the useUnicode and > characterEncoding parameters what happens is all of the codes are just not > displayed at all. With the above URL they are displayed as ?s. > > The JSP page encoding setting is set to UTF-8 which worked for when I was > accessing SQLServer through their JDBC driver. I have downloaded an ODBC > driver for MySQL so that I can try and see if perhaps it's the driver but > right now I don't have an application to test it yet and I'll need to > research to see how to do it in Java which would really allow me to test > it. > > So I'm hoping someone can help me either figure out why it's not working > as > I would expect. Also I'm open to suggestions on how to handle this on the > database/server side. Any alternate solutions have to be transparent to my > client who enters this data from a web form usually copy and paste from > Word. > > Thanks in advance for any help. > -- > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > Stormblade (Shaolin Code Warrior) > Software Developer (15+ Years Programming exp.) > > My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]