473,883 Members | 2,233 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

JDBC: Encoding Not Supported when connecting to Big5 database

Hi,

I have created a database on DB2 8.1 and 8.2 for Windows using the
codeset "Big5" with the command:

db2 CREATE DATABASE TWBIG5 USING CODESET BIG5 TERRITORY TW

When I try to connect to the database using the DB2 Universal Type 4
JDBC drivers v2.6 I get an error:
"com.ibm.db2.jc c.b.DisconnectE xception: encoding not supported!!
DB2ConnectionCo rrelator: GA050318.GD66.0 60104020919". I can create and
connect to a UTF-8 database, but there is a database which is in
production with the Big5 codeset, so I can't recreate that one. I've
tried connecting using all the Java 1.4.2_x and 1.5.0_x builds and
still can't connect.

Would anyone have any ideas on how to fix this or get around the
problem? or if the driver actually doesn't support connecting to Big5?

-Niels

Jan 4 '06 #1
5 7599
ni*******@gmail .com wrote:
connect to a UTF-8 database, but there is a database which is in
production with the Big5 codeset, so I can't recreate that one. I've
tried connecting using all the Java 1.4.2_x and 1.5.0_x builds and
still can't connect.


Try an IBM Java JDK, it should work.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpf e
des 18. März in Berlin
Jan 4 '06 #2
Hi Bernd,

IBM only offers a 1.4 JDK and it only runs on IBM sold PCs as far as I
can see. This is the only download I could find for Windows ...
http://www-307.ibm.com/pc/support/si...cid=MIGR-56888

It states "Computer must be an IBM system. This program will not
install on non-IBM systems." ... I downloaded it and the installer
wouldn't install. Buying IBM hardware isn't an option.

Are you suggesting some other IBM Java JDK that I am not aware of?

-Niels

Jan 4 '06 #3
ni*******@gmail .com wrote:
Are you suggesting some other IBM Java JDK that I am not aware of?


Unfortunately not.

Serge, Knut? Any ideas?

BIG5 was a problem for me too, I have no ideas how to fix this under
Windows.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpf e
des 18. März in Berlin
Jan 5 '06 #4
>> Try this - I don't believe it has any hardware restiction:
http://www-128.ibm.com/developerworks/java/jdk/eclipse/
Jan M. Nelken
DB2 Universal Database Service Consultant
Advanced TCX (Tools/Connectivity/eXtenders) Support


Hi,

Jan sent me the link above. I downloaded the Eclipse package and
grabbed the IBM JRE that was included with it. I used the JRE and it
worked, I was able to connect. This fixes my problem.

Although, it would be nice if in the future the DB2 JDBC driver
supported Big5 with the Sun JRE. Future versions of our software will
require 1.5.

thanks very much for the help.
-Niels

Jan 5 '06 #5
ni*******@gmail .com wrote:
Although, it would be nice if in the future the DB2 JDBC driver
supported Big5 with the Sun JRE. Future versions of our software will
require 1.5.


The culprit isn't the JDBC driver but rather the codepage conversion
routines in the Sun Java Runtime Environment which are unable to handle
this.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpf e
des 18. März in Berlin
Jan 5 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
6553
by: WEIWEIWEI | last post by:
Hi Al I'd like to encode a string submitted from a utf-8 form in a aspx page to big5 Any ideas on how to do that I try sth like public static string unicode_big5(string src) { Encoding big5 = Encoding.GetEncoding("big5") Encoding unicode = Encoding.UTF8 byte unicodeBytes = unicode.GetBytes(src)
1
4512
by: Aleksey | last post by:
Hello, I have the following problem working with DatabaseMetaData. There is a database with table and attribute names in Russian. Database cluster was initialized with appropriate ru_RU.KOI8-R locale. All the databases were created with KOI8-R encoding. No problems were encountered in accessing database table data with JDBC.
2
4489
by: WEIWEIWEI | last post by:
Hi Al I'd like to encode a string submitted from a utf-8 form in a aspx page to big5 Any ideas on how to do that I try sth like public static string unicode_big5(string src) { Encoding big5 = Encoding.GetEncoding("big5") Encoding unicode = Encoding.UTF8 byte unicodeBytes = unicode.GetBytes(src)
1
1666
by: Soda | last post by:
I try to write a ASP.Net web application which will post data to other websites I'm use NameValueCollection class add(...) method and WebClient class uploadvalue(...) method to post data to other website. It works fine if the data is in English, however, when it contain characters in other languages (such as Chinese big5), it will display some un-readable characters. In web.config file I set encoding to "big5"
1
1835
by: Pavel Stehule | last post by:
Hello I have only one questions. I am testing PostgreSQL for windows. All look well, but I can't set database encoding win1250. Its can be problem, because win1250 is often used encoding on win32 platform in our area. (PG7.5 don't support win1250 encoding on linux too). Administrator@NEMESIS /usr/local/pgsql/lib $ ../bin/createdb.exe -E win1250 aaa createdb.exe: database creation failed: ERROR: win1250 is not a valid
5
2699
by: Dino Nardini | last post by:
Hey folks, I'm currently evaluating an upgrade path from our current ColdFusion 5 / PostgreSQL setup to ColdFusion MX / PostgreSQL. In the current setup, we're using the Merant ODBC driver for postgres. I've installed Fedora Core 2 with Apache 2 and ColdFusion MX, and I grabbed the latest JDBC driver from the postgres website. I copied one of our production websites over to the test box, but ran into
7
4504
by: EmeraldShield | last post by:
We have an application that uses UTF8 everywhere to load / save / process documents. One of our clients is having a problem with BIG Encoded files being trashed after running through our app. Indeed I have verified that if I go to a website in Taiwan and save the file in BIG5 and then just load / save the file with a UTF8 text reader / write some bytes are modified. How can I correct this? It was my understanding the UTF8 was...
3
10291
by: %NAME% | last post by:
When using embedded SQL for db2 under solaris, you do not need to give username and password since the system will use your unix-login as default credential. However, with JDBC seems I always need to provide username and password, the Java API DriverManger.getConnection(String url) does not work. I am not sure if this is because the JDBC driver, or because it does not work for DB2 under solaris. Any comments? Thanks a lot!
0
1004
by: asterisk | last post by:
Hi, I am already mad for charset issue, please help me clear it. My question here is, I want to retrieve fields from Sql server database, whose collation is Latin, but the content of field is garbage data because we encoded data by charset big5 in browser to store them into database. when I copy them into notepad.exe and browse them in browser with big5, they are correct, but when I retrieve them by using System.text.encoding to convert big5...
0
9945
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9798
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11160
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10766
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10863
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7136
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5807
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4230
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3241
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.