Japanese Data in SQL Server 2000

anandkumarm · Post by **anandkumarm** » Sun Nov 04, 2007 9:17 am

chulett wrote:Can you try it again after overriding the NLS_LANG setting in the job to match your database as I outlined earlier?

Yes I tired that too, still not working. In the mean while I created a text file with japanese data and loaded it into another text file and that data is getting garbled too. Any other thoughts?

Thanks for the responses and help,

Anand.

chulett · Post by **chulett** » Sun Nov 04, 2007 9:29 am

I'm going to have to defer to Ray on this one, never having had the pleasure of dealing with character sets that actually required NLS be installed. From one of his earlier replies, and the issues you've been seeing, that seems to be a necessary step here.

anandkumarm · Post by **anandkumarm** » Mon Nov 05, 2007 11:13 am

I installed datastage on my local machine with NLS enabled and set the project default mapping to none and its working!!!.

Thanks for the help,
Anand.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 05, 2007 10:13 pm

Quod erat demonstrandum.