Occasionally you may need to find out your database collation to fix bugs and etc. Here's how:

There are two ways to get your database collation.

Solution 1:

Run the below script in Microsoft SQL Server Management Studio - query editor:

ResultSet:
SQLCollation
————————————
Latin1_General_CI_AS

Solution 2:

Use the Microsoft SQL Server Management Studio GUI to find out the dabatabase collation.

1. Right click on the database -> Properties.

2. Under Maintenance Section look for the property Collation then you will see the database collation.

So you can use either one to find out the database collation.

• Add New
• Search

Comments (0)

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.

"