Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Unicode

Author  Topic  hans Starting Member 1 Post Posted - 2004-07-13 : 17:02:28 Hi I access a SQL-Server Database by MS Access ADP with DSN ODBC connection. Later, the Database is accessed by a Website written in ASP. I should have the data in the tables in Unicode. For this reason the fields in the tables are in NVARCHAR format. When I type via my MS Access ADP Interface Western Europe characters like "¨¹, ¨¦" etc. or russian "§Ý§Ó§Ñ§Õ§Ó§Ñ§à" all seems to be ok and it seems to be stored correctly. However when I access the database with my ASP scripts and UTF-8 (Unicode) I loose Western Europe and Russian charcters. With charset=iso-8859-1 (Western Europe) I receive the Western Europe correctly - but not russian. When I update data by an UTF-8 ASP script - Data are stored and displayed correctly. In this case all work is done on the same server. Has anybody an idea how I can convert the data. Is it maybe a problem of the connection (odbc, adp), that local machine and server are not configured the same way. Thank you very much. Hans, Montreal