I am facing an issue with SQL Server Data type.Our database is SQL Server 2008.
The NLS code page IBM 00142 is being used along with NCHAR/ NVARCHAR as per the guidelines from the DBA.
There re two columns,'Status ID' and 'IST_ID' declared as NCHAR and expected value would be 'Y' and 'I' respectively.This values are assigned in Transformer.when the above two columns are declared as 'Unicode' ,some junk values are loaded in these two fields instead of mapping value but when these two columns are not declared as 'Unicode',proper value is being loaded.
So,is there any standard for CHAR datatype in SQLSERVER?
Rumu - you waited a whole hour before bumping your thread, what paid-for organization has response times like that? DataStage is volunteer and most members are in the USA, where it is still 2AM on Monday morning.
What page is IBM 00142, all I found in Google was a reference to EBCDIC
ArndW wrote:Rumu - you waited a whole hour before bumping your thread, what paid-for organization has response times like that? DataStage is volunteer and most members are in the USA, where it is still 2AM on Monday morning.
What page is IBM 00142, all I found in Google was a reference to EBCDIC
Arndw,
I had posted my first post on Feb 10 and I waited for 5 days for any reply and then today I asked for a reply.
ArndW wrote:IBM 01142 is an EBCDIC code page. I was not aware of SQL Server running on an EBCDIC machine. This is perhaps the source of your problems. ...
Hi Arndw,
In SQL Server we are using Danish_Norwegian_CI_AS collation.
</a>