Getting Warning

shobhitj · Post by **shobhitj** » Sun Jun 22, 2008 10:42 am

Hi,

I have getting the following warning i am getting:-

SOURCE_TABLES,0: Invalid character(s) ([xFFFD]) found converting Unicode string (code point(s): ST PIERRE DE B[xFFFD]UF) to codepage ISO-8859-1, substituting.

SOURCE_TABLES,0: Invalid character(s) ([x2019]) found converting Unicode string (code point(s): CENTRE D[x2019]ETUDE DE LA KABBALE) to codepage ISO-8859-1, substituting.

Please provide some solution for the above warning to be removed.

Minhajuddin · Post by **Minhajuddin** » Sun Jun 22, 2008 11:09 pm

This warning says that Datastage encountered a hex code which has no definition in the code page being used (ISO - 8859-1 in your case). If I were you, I would find out the hex codes not defined in this code page (Search wikipedia for ISO-8859-1) and search for them in my source and then find the source of these literals and stop them at the source.

ArndW · Post by **ArndW** » Sun Jun 22, 2008 11:22 pm

That is an odd error - I'Ve just checked and x2019 is the back apostrophe see here and it does not seem to have a ISO8859-1 counterpart! The error is valid and you will need to handle it by either removing the character, or defining a replacement.

The xFFFD is a "replacement mark" for a character which is unknown in UniCode, so translating that to any other character set is going to be impossible in any case.

shobhitj · Post by **shobhitj** » Tue Jun 24, 2008 1:28 am

Hi,

Plase provide the complete solution

ArndW wrote:That is an odd error - I'Ve just checked and x2019 is the back apostrophe see here and it does not seem to have a ISO8859-1 count ...

ArndW · Post by **ArndW** » Tue Jun 24, 2008 2:34 am

shobhitj - please get Premium membership.