Inserting to SQL from FiveWin

[byron.hopp]

I am attempting to store strings that are a part of a customer_Data database. Some of the customers are from other parts of the world. I am having problems inserting special characters like the National Language Character Set. I am modified my insert strings to place an "N" before the character string i.e. Values (N'4063 HÖRSCHING) where the 'O' in word would have two dots above it. I have also tried creating a new table with using nvarchar instead of varchar, nchar instead of char etc... This did not help as well. If I run the insert query from inside Microsoft Sql Management Studio it seems to work find, and the character is correct when selected back. Is there something I need to set on ADO Recordset object to correct this problem, or is this related to FiveWin.

Insert into Customer_Data (CUSTOMER_NUMBER,CUSTOMER_NAME,ATTENTION,ADDR_LINE1,ADDR_LINE2,CITY,STATE,ZIP_CODE,COUNTRY_NAME,AREA_CODE,PHONE_NUMBER) Values (N'AC01',N'ACS PROJECTS GMBH',N'FLUGHAFENSTRASSE 3',N'CARGO TERMINAL #5',N'4063 HÖRSCHING , AUSTRIA',N'',N'',N'',N'AUT',N'',N'');

Thanks,

[nageswaragunupudi]

MSSQL ?

[nageswaragunupudi]

MSSQL ?

[byron.hopp]

Yes Microsoft SQL Server 2012.