Problem:
On SQL Server side a table had a column (desc_details) with NVARCHAR(4000), DG4MSQL has been configured for communication with SQL Server. Querying to that table was not showing the column (desc_details) but all other columns were being shown correctly.
Solution:
workaround:
After a closer look at the definition of table (SQL Server side), found that only this column had NVARCHAR(4000) so just requested SQL Server team to have NVARCHAR(2000) for this column instead as a quick test. It worked.
Remedy:
Add the below parameters to the gateway initdg4msql.ora file , restart the gateway listener and check again.
HS_LANGUAGE=AMERICAN_AMERICA.AL32UTF8
HS_NLS_NCHAR=UCS2
On SQL Server side a table had a column (desc_details) with NVARCHAR(4000), DG4MSQL has been configured for communication with SQL Server. Querying to that table was not showing the column (desc_details) but all other columns were being shown correctly.
Solution:
workaround:
After a closer look at the definition of table (SQL Server side), found that only this column had NVARCHAR(4000) so just requested SQL Server team to have NVARCHAR(2000) for this column instead as a quick test. It worked.
Remedy:
Add the below parameters to the gateway initdg4msql.ora file , restart the gateway listener and check again.
HS_LANGUAGE=AMERICAN_AMERICA.AL32UTF8
HS_NLS_NCHAR=UCS2
No comments:
Post a Comment