Character translation AS/400

[Guest.Visitor]

Hi, Do anybody know how the transalation from one CCSID to unicode works when you call stored procedures on the AS/400 from a web server? I only get "rubbish" for the special Swedish characters. If I use "prepared statement" with SQL to access the physical files the translation works fine, but my problem comes up when I use "callable statement" to access the stored procedures to return a resultset from a physical file. I try to ask before I dig deeper into it. TIA / Leif

[Guest.Visitor]

Sorry, I forgot to give a solution to my problem. It's really simple. Here it is. Using stored procedures on a PF with CCSID <> 65535: In this case you have to change your user profile to the CCSID that you will make the translation to, or change the job description that the job QZDASOINIT will get, when you make the connection. Note: You have to change the JOBD before the connection. Using stored procedures on a PF with CCSID == 65535: This file you have to read with AS400Text and give the CCSID as parameter like: int intCCSID = 248; splfText= new com.ibm.as400.access.AS400Text(160,intCCSID); textToView = splfText.toObject(rsSpoolfile.getBytes(1)).toStrin g(); If you have a web application that are connected to more than one AS/400, make a dataarea on each AS/400 with the current CCSID for right translation. /Leif