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 Administration (2000)
 ANSI Code Page

Author  Topic 

nimesh69
Starting Member

30 Posts

Posted - 2001-07-27 : 03:10:06
When we configure DSN thru ODBC manager on the last page of the DSN creation wizard there is a parameter called "Perform translation for character data" which is checked by default.

Upon taking a help, it says that "When selected, the SQL Server ODBC driver converts ANSI strings sent between the client computer and SQL Server by using Unicode".
Is it really necessary to check this param?
Will unchecking this improve performance in anyway?
I also don't really know whether SQL Server Code page is same as Code page on my client - is there a way to find this?

Appreciate any help.

Thanks!
- Nimesh
   

- Advertisement -