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. _____________________________________________________________________________
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.