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 '-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=truecharacterEncoding=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]
