DSXchange

Dear all,

There is a column of NVARCHAR type in a table. The column stores some unicode characters such as "ﶳ" (a square). I want to export the table to a sequential file. But DS converts these characters to be question marks(?). I try UTF8 NLS setting but with no help.

Please help, thanks!

Gordon

I expect you need to set the MAP that is being used to read from the database and the MAP used to write to the Text File.

where have you used UTF8 NLS ?

Hi Eric,

I used UTF8 NLS in the ODBC Stage which represents the table in SQL Server: Stage->General->NLS->Choose UTF8 below "Map name to use with stages".

After that, I click Outputs->View Data, I will get the NLS input mapping error and the wrong characters.

Thanks.

Eric wrote:I expect you need to set the MAP that is being used to read from the database and the MAP used to write to the Text File.

where have you used UTF8 NLS ?