Issue while loading 'ÿ' character

[Former Member]

Hi,

I am trying to load a delimited on a UNIX server with 'ÿ' as delimiter using BODS.

But when the file is getting loaded, it is showing '/377'  in place of 'ÿ'.

I am using ISO 8859-1 code page in both file format and datastore configuration but still it is not working.Please help me out here.

Thanks in Advance,

Ishan

[Former Member]

Hi,

What's the source of your Umlaut letter, is it a database or a delimited file same as the target?

At best you should try using UTF8 on the source/target, and for the locale of your OS where the job server is residing (check  the value of the env. variable for $LANG and $LC_ALL).

[Former Member]

The data is coming from Oracle database but the Umlaut (ÿ) character is specified as delimeter in file format. The locale of the UNIX server is UTF8. I have tried setting the format locale to UTH8 but it is not working.

Currently I am using ISO-8859-1 in file format. And I have used the following command in shell

export LANG = en_US.ISO-8859-1

This is correct, right?

[Former Member]

As a test can you  set all to utf8 including in the file format.

On linux (job server):

export LANG=en_US.utf8
export LC_ALL=en_US.utf8

(use use locale -a command to find the correct encoding format)

then for Oracle

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

I don't think you need to restart DS job server, but do restart it just in case, after setting these env variables.

thanks

[Former Member]

I tried that but it is not working.

Setting all to UTF8 is causing the characters to come like '/203/307' now.

But when I am using iso-8859-1 and transferring the same file to my local desktop, the character 'ÿ' is coming correclty.