Skip to content

Instantly share code, notes, and snippets.

@max-mulawa

max-mulawa/DatabaseWithPolishCollation.sql

Created April 29, 2011 09:03
Show Gist options
  • Save max-mulawa/948076 to your computer and use it in GitHub Desktop.
Save max-mulawa/948076 to your computer and use it in GitHub Desktop.
Download ZIP
Create DatabaseWithPolishCollation
Raw
DatabaseWithPolishCollation.sql
GO
IF NOT EXISTS(SELECT * FROM sys.databases
WHERE name = 'DatabaseWithPolishCollation')
BEGIN
CREATE DATABASE DatabaseWithPolishCollation COLLATE Polish_CI_AS
END
GO
SELECT SERVERPROPERTY('Collation')
--Resturns on my server: Latin1_General_CI_AS_KS_WS
GO
SELECT DATABASEPROPERTYEX('tempdb','Collation')
--Resturns on my server: Latin1_General_CI_AS_KS_WS
--same as server collation
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment