Encoding problem (JDBC, mysql)

[Venkata Srinivasa Rao, Yerra]

Dear All,

        I am facing encoding problem with JDBC, mysql.  I can't insert/select Big5 text with JDBC connection. After I insert Big5 text, it becomes question marks (????) in the database. Before I insert Big5 text to mysql db, I am converting web browser post data from "8859_1" to Big5 encoding. While fetching data from the database, I am converting to Big5 (I am expect data from the database is Unicode).


        Any kind of help will be appreciated. Here is my environment & its settings.

MYSQL:
mysql  Ver 12.20 Distrib 4.0.13, for pc-linux (i686)

Server version:         4.0.13-standard-log
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /tmp/mysql.sock

JAVA:

java version "1.4.1_02"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_02-b06)
Java HotSpot(TM) Client VM (build 1.4.1_02-b06, mixed mode)

JDBC:

Driver Jar : mysql-connector-java-3.0.8-stable-bin.jar
DB_URL                  = jdbc:mysql://myserver:3306/mydb
DRIVER_CLASS_NAME       = org.gjt.mm.mysql.Driver

Tomcat: jakarta-tomcat-4.1.24-LE-jdk14


Thanks in advance.

Best Regards,
Srinivas.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 6/1/2003


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]