Special Characters replaced by <SUB>

ray.wurlod · Post by **ray.wurlod** » Mon Oct 13, 2014 3:24 pm

How is the file encoded, and what NLS map are you using in the DataStage job? The two need to be compatible, if not identical.

joycerecacho · Post by **joycerecacho** » Mon Oct 13, 2014 4:03 pm

The NLS map is the project default: ISO-8859-1
And about your first question "How is the file encoded?", what do you mean?
I didnt get it.

Best regards,

joycerecacho · Post by **joycerecacho** » Mon Oct 13, 2014 4:06 pm

I derivated the text field like:

NOM_DEV (Char 70 | Unicode | NotNull)

If Isnull(Lnk_Ler_Contratos.NOM_DEV) Then
Str(' ',70)
Else
Left(Lnk_Ler_Contratos.NOM_DEV:Str(' ',70),70)

ray.wurlod · Post by **ray.wurlod** » Mon Oct 13, 2014 4:15 pm

Because the file contains accented characters, it cannot be plain ASCII, it must be encoded somehow. Perhaps it is encoded using ISO-8859-1, perhaps using a different encoding. You also need to ascertain what the mapping used in the DB2 table is, for the same reason.