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)
 Identifying Unicode Character Set

Author  Topic 

pug2694328
Posting Yak Master

166 Posts

Posted - 2006-05-09 : 13:58:56
I'm aware that the Unicode Character Set is specified when a database is defined.

Is there a way to quickly identify what Set is being used?

Thanks!

druer
Constraint Violating Yak Guru

314 Posts

Posted - 2006-05-09 : 14:41:15
Just use the DatabasePropertyEX function as follows:

select databasepropertyex('Your db name','collation')

Hope it helps,
Dalton

Blessings aren't so much a matter of "if they come" but "are you noticing them."
Go to Top of Page

pug2694328
Posting Yak Master

166 Posts

Posted - 2006-05-09 : 14:46:21
Fanstastic. Thanks!
Go to Top of Page
   

- Advertisement -