Find character_set in MSSQL

Find character_set in MSSQL, 2008 

select collation_name from sys.databases

where name = 'dbname';

SELECT DATABASEPROPERTYEX('dbname', 'Collation') DatabaseCollation;

SELECT SERVERPROPERTY('Collation') as ServerCollation