<div>
To view the list of character set or collations, issue<br />
<br />
select * from fn_helpcollations()<br />
<br />
To change the collation / character set of your database, then issue<br />
<br />
ALTER DATABASE db_name COLLATE collation_name<br />
<br />
Hope this helps
</div>


To view the list of character set or collations, issue

select * from fn_helpcollations()

To change the collation / character set of your database, then issue

ALTER DATABASE db_name COLLATE collation_name

Hope this helps

<div>
After opening the server management studio and pasting select * from fn_helpcollations(), it just runs in a debugging mode.
</div>


After opening the server management studio and pasting select * from fn_helpcollations(), it just runs in a debugging mode.

<div>
Hold on, it finally gave the result. &nbsp;I will now try and alter the character set accordingly.
</div>


Hold on, it finally gave the result.  I will now try and alter the character set accordingly.

<div>
<div class="content wysiwyg-content">
How do I configure the character set in sql server 2008?<br />
<br />
Thanks.
</div>
</div>


How do I configure the character set in sql server 2008?

Thanks.

How To Configure Character Set

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.

Microsoft Server Apps

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.