Re: Codepage issue?

[Mark Phippard <markp@xxxxxxxxxxxxxxx>]

java400-l-bounces@xxxxxxxxxxxx wrote on 12/08/2005 10:22:51 AM:

> Mark Phippard wrote:
> >>I've got a JDBC statement that is getting the following error ...
> >>java.sql.SQLException: [SQL0113] Le nom TRJOB# n'est pas admis.
> >>Which translates into: Name TRJOB# not allowed.
> > To solve the problem I created a table that was keyed by an integer 
and 
> > had a 1-char field with CCSID 65535.  I then added rows for a bunch of 

> > special characters.  I then made a small Java class that will query 
this 
> > file and return the character. 
> 
> Unfortunately, changing the table is not really an option for me.
> 
> Since the column is clearly valid in the database, I need to figure out
> a way to make JDBC use a ccsid that will handle the table correctly.

I didn't say anything about changing the table.  I was in the same boat as 
you, and I told you the way to do what you are asking. 

Read it again.

Mark


_____________________________________________________________________________
Scanned for SoftLanding Systems, Inc. and SoftLanding Europe Plc by IBM Email 
Security Management Services powered by MessageLabs. 
_____________________________________________________________________________