Fwd: Encoding problem (JDBC, mysql)

Venkata Srinivasa Rao, Yerra Mon, 02 Jun 2003 17:04:19 -0700

Dear All,

        I have fixed the problem by my self. I just specify the character encoding as follows

        jdbc:mysql://myserver:3306/mydatabase?useUnicode=true&characterEncoding=UTF8

        Thanks for your time.

Best Regards,
Srinivas.

Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
List-ID: <mysql.mysql.com>
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
X-Sender: [EMAIL PROTECTED]
X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9
Date: Mon, 02 Jun 2003 14:21:54 +0800
To: [EMAIL PROTECTED]
From: "Venkata Srinivasa Rao, Yerra" <[EMAIL PROTECTED]>
Subject: Encoding problem (JDBC, mysql)
X-Spam-Check-By: lists.mysql.com
X-Spam: False ; 3.3 / 5.0

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]

---
Incoming 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

---
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]

Fwd: Encoding problem (JDBC, mysql)

Reply via email to