How to set Encoding in T-Sql?

Question

Transact SQL

when creating a database, it is not possible to set the
DBMS encoding = management studio( t-sql )
what do I do = create database kurs set utf8 COLLATE utf8_general_ci;
result = incorrect syntax near COLLATE
what I did to solve the issue = googled and searched for information (did not help)
what to do?

Answer 1

In MS SQL Server, the syntax is slightly different

CREATE DATABASE kurs 
COLLATE utf8_general_ci

I don't remember if there is utf8_general_ci in sql server.
Unicode is built into SqlServer by default as nchar nvarchar types, so it makes sense to specify encodings if you intend to use char varchar.
For Russian, cyrillic_general_ci_as is usually used.

Answer 2

General Issues Collation and Unicode Support .