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.
| Author |
Topic |
|
Pickles
Starting Member
7 Posts |
 Posted - 2010-07-21 : 06:20:09
|
| Hi,How can I check what character set is my database using?Thanks. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2010-07-21 : 07:10:11
|
| For one database:SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation');For all databases:sp_helpdb - look in the status column for Collation=Does this help? |
 |
|
|
Pickles
Starting Member
7 Posts |
Posted - 2010-07-21 : 08:54:35
|
| Hi YellowBug,So you mean character set = collation? If so then yes it helped cause i thought they are both different.Thanks. |
|
|
|
|
|
|
How to check what character set