Page History
SQL'de kullanıcı bazında kullanılan dil setinin görüntülenmesine ve dil setlerinin kodlarına aşağıda şekilde ulaşılabilir:
SQL Server Collation Kontrolü
sp_helpsort
SELECT SERVERPROPERTY('collation') as server_collation
Anchor
SELECT name, collation_name FROM sys.databases;
Anchor
SELECT
type_desc,
default_database_name,
default_language_name
FROM master.sys.server_principals
WHERE name = 'sa';
Info |
---|
sa yerine sql user bilgisi yazılabilir. |
Anchor
SQL dil setlerinin ALIAS bilgileri aşağıdadır.
LANGID |
ALIAS |
0 |
English |
1 |
German |
2 |
French |
3 |
Japanese |
4 |
Danish |
5 |
Spanish |
6 |
Italian |
7 |
Dutch |
8 |
Norwegian |
9 |
Portuguese |
10 |
Finnish |
...
Chinese
11 | Swedish |
12 | Czech |
13 | Hungarian |
14 | Polish |
15 | Romanian |
16 | Croatian |
17 | Slovak |
18 | Slovenian |
19 | Greek |
20 | Bulgarian |
21 | Russian |
22 | Turkish |
23 | British English |
24 | Estonian |
25 | Latvian |
26 | Lithuanian |
27 | Brazilian |
28 |
Traditional
Chinese
Traditional Chinese | |
29 | Korean |
30 |
Simplified
Simplified Chinese | |
31 | Arabic |
32 | Thai |
33 | Bokmål |