How to handle NVARCHAR column in SQL Server?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
gordonxiao
Participant
Posts: 18
Joined: Sun Sep 12, 2004 9:19 am

How to handle NVARCHAR column in SQL Server?

Post by gordonxiao »

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
Eric
Participant
Posts: 254
Joined: Mon Sep 29, 2003 4:35 am

Post by Eric »

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 ?
gordonxiao
Participant
Posts: 18
Joined: Sun Sep 12, 2004 9:19 am

Post by gordonxiao »

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 ?
Post Reply