change db codepg to ados-864 - SQL Server Forums

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 2005 Forums

Transact-SQL (2005)

change db codepg to ados-864

Author

Topic

BrOkEn_iCe
Starting Member

25 Posts

Posted - 2010-06-27 : 05:11:00

hi all

how i can change the db code page to 864 and what it's name in collation thx

Sachin.Nand

2937 Posts

Posted - 2010-06-27 : 05:17:47

I think it is something like this

collate Arabic_CI_AS

Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH

BrOkEn_iCe
Starting Member

25 Posts

Posted - 2010-06-27 : 05:24:34

i don't know i have many arabic name and the printer only support ados-864

BrOkEn_iCe
Starting Member

25 Posts

Posted - 2010-06-27 : 05:28:13

Arabic_CI_AS Code page = 1256 not that thnx for helping u r good helper

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-06-28 : 13:34:42

Will this help?

select *, COLLATIONPROPERTY(name, 'codepage') from fn_helpcollations()
where COLLATIONPROPERTY(name, 'codepage') = 864 

select *, COLLATIONPROPERTY(name, 'codepage') from fn_helpcollations()
where COLLATIONPROPERTY(name, 'codepage') = 1256

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources