Warning message

rodre · Post by **rodre** » Thu Nov 29, 2012 12:07 pm

Hello:

I am getting this type of warnings:

Data_Rules,1: Invalid character(s) ([xBD]) found converting string (code point(s): 906 N. 23RD [xBD] STREET) from codepage UTF-8 to Unicode, substituting.

When I look in the database the address shows as:

'906 N. 23RD Ã¯Â¿Å“ STREET'

I tried using the Convert('Ã¯Â¿Å“','', fieldname) but that's not it.

Does anyone understand the warning?

Much Thanks in Advance!

vinothkumar · Post by **vinothkumar** » Thu Nov 29, 2012 12:20 pm

In which stage you are getting this warning. If you have any option to change character set, please try with LATIN 01A

rodre · Post by **rodre** » Thu Nov 29, 2012 1:02 pm

The stage this is happening is Data Rules.

Data Rules does not have a way to change the the character set. I will try to change at the job lebel and see...

rodre · Post by **rodre** » Thu Nov 29, 2012 2:11 pm

There is no LATIN 01A inthe drop down list.

I try changing the NLS at the job lebel but did not help.

The error says: from codepage UTF-8 to Unicode. We are using Netezza and it does not accept Unicodes when loading to the database.

The address is a VarChar, does anyone have any suggestions how to handle this?

srinivas.g · Post by **srinivas.g** » Thu Nov 29, 2012 2:34 pm

why dont you use below function in database level

replace('906 N. 23RD Ã¯Â¿Å“ STREET','Ã¯Â¿Å“')

ray.wurlod · Post by **ray.wurlod** » Thu Nov 29, 2012 7:58 pm

What is the code page for SQL Server set to?