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)
 Code Page problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-01-06 : 08:12:07
Dheeraj writes "Hi,
We have a application written in 'C'. That interacts with the SQL Server and fetches records from there.
We have installed the SQL SERVER with code page 850 case insensitive and Asscent insensitive. But application does not read the accented characters correctly.
To read it correctly we have changed the code and added this to read it correctly after calling dbopen():

status = dbsetopt(dbproc[i], DBANSItoOEM , "OFF");

After this it works perfectly but the same does not work over SQLSERVER with code page 1252.

Is there a generic work around for this or what changes we need to incorporate in our code.

Thanks in advance.

regards
dheeraj"
   

- Advertisement -