I have a question, because one of my columns does

Question

I have a question, because one of my columns does

not take Chinese characters and from C# I send it to nvarchar and in sql I put an N'value', I want to improve that, what do you think? I already tried to change the collation to Latin1_General_100_CI_AS_AS and didn't work

0

02.08.2023

4 ответов

24 просмотра

Cesar Guerrero Автор вопроса

Martin Rys
Which database, which charset

Sql server 2019

0

9 месяцев назад

Thomas

Cesar Guerrero
Sql server 2019

UTF-8 support SQL Server 2019 (15.x) introduces full support for the widely used UTF-8 character encoding as an import or export encoding, and as database-level or column-level collation for string data. UTF-8 is allowed in the char and varchar data types, and it's enabled when you create or change an object's collation to a collation that has a UTF8 suffix. One example is changing LATIN1_GENERAL_100_CI_AS_SC to LATIN1_GENERAL_100_CI_AS_SC_UTF8.

0

9 месяцев назад

Cesar Guerrero Автор вопроса

Thomas
UTF-8 support SQL Server 2019 (15.x) introduces f...

Thanks

0

9 месяцев назад

Martin Rys · Accepted Answer

Martin Rys

Which database, which charset

0

9 месяцев назад

Похожие чаты

I have a question, because one of my columns does

4 ответов

Похожие вопросы