Problems with codepage in Interxel | System og Metode Q&A

Submitted by Kent on Mon, 02/18/2013 - 09:04

Forums

Hi,

I am having problems with INTERXEL and the codepage settings.
In the conversion defenition i leave the spooled file codepage blank, expecting the Conversion defenition to run under the JOB CCSID (278 Swedish). But when i look at the final result, all the special charaters are interpreted wrong (#@ etc.).

Jobb . . . . . . . . :   RPINUTLEV       Fil . . . . . . . . :   RP0085
Användare . . . . :     SUENK           Nummer . . . . . . :     000001
Nummer . . . . . . :     121858        Skapad - datum . . . :   13-02-18
Jobbets systemnamn . :   SEFSS01         Skapad - tid . . . . :   08.47.52

Tecken-ID:
Grafisk teckenuppsättning . . . . . :   697
Teckentabell . . . . . . . . . . . . :   278

I've also tried to enter 278 in the conversion defenition, but it still gets wrong.

So i tried to enter 277 as codepage and this actually works, now the charaters are correct!!
However this does not solve my problem since I have to leave the codepage blank because we have multiple languages in the system.

PRTF is compiled with *JOBCCSID

Hi Kent What version of

Hi Kent

What version of InterXel are you using?

Best Regards

Grith Skovbølle

Version: 001151

i/Os is on 7.1

The odd thing is that with a

The odd thing is that with a Database, a Spoolfile and a job with CCSID 278 the conversion definitions codepage works when it's set to 277.

I have asked the developer of

I have asked the developer of InterXel, and he recommend that you upgrade to the newest version, with is 001164. You will find the download here: http://www.system-method.com/Download/InterForm/Modules

Do you want the codepage on the spoolfile to define the conversion?

Best Regards

Grith Skovbølle

Ok, i'll see if we can get

Ok, i'll see if we can get this installed ASAP and come back to you if this helps.
It has to be either the spoolfile or the job creating the spoolfiles CCSID it doesn't matter.

Hi again, We have now updated

Hi again,

We have now updated to version 001164 and there is still some trouble with the codepage and the conversions between special charaters.

Now we are not getting #! as charaters istead we get the Danish special charaters ØÆ.

Hi Kent Please tell me what

Hi Kent

Please tell me what the CCSID/codepage are on all the different steps:

The machine

The jobs

The spoolfile

The user

I suppose there are no problem if it's the CCSID is the same through all the steps. Am I right?

Best regards Grith

The machine is running

The machine is running 278.

The DB is 278.

The Job is 278.

The spoolfile is 278.

The user is 278.

No you are mistaken, the special chars ÄÖ is interpreted as æ ø in the excel sheet even when runnig everything as 278.

The codepage in the conversion definition is blank (tried both 278 and 277 as well, but without luck!).