Page 1 of 1
Warning message
Posted: Thu Nov 29, 2012 12:07 pm
by rodre
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!
Posted: Thu Nov 29, 2012 12:20 pm
by vinothkumar
In which stage you are getting this warning. If you have any option to change character set, please try with LATIN 01A
Posted: Thu Nov 29, 2012 1:02 pm
by rodre
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...
Posted: Thu Nov 29, 2012 2:11 pm
by rodre
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?
Posted: Thu Nov 29, 2012 2:34 pm
by srinivas.g
why dont you use below function in database level
replace('906 N. 23RD ￜ STREET','ￜ')
Posted: Thu Nov 29, 2012 7:58 pm
by ray.wurlod
What is the code page for SQL Server set to?