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)
 SQL server 2005 Code Page

Author  Topic 

bobykhan30
Starting Member

5 Posts

Posted - 2006-11-06 : 11:33:22

How to change the code page in SQl server 2005?

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-11-06 : 11:45:34
Start by reviewing the topic "Collation and Code Page Architecture" in Books Online, then change the collation (that's how code pages are implemented in SQL Server), so also look for "collation" in Books Online. You can specify collation at various levels, database, table or column, so you'll use ALTER DATABASE, or ALTER TABLE depending on what you want to change.

Research and test your change thoroughly before implementing in production.
Go to Top of Page

bobykhan30
Starting Member

5 Posts

Posted - 2006-11-06 : 14:24:05

Thanks for ur help
Go to Top of Page
   

- Advertisement -