Forum Discussion

Latav_Tech's avatar
Latav_Tech
Copper Contributor
Jul 16, 2019

SQL Server 2019 Server Level collation change to UTF8 invalidating Latin character values

We have installed SQL2019 CTP3 in our Test Server where we are trying to convert Server level collation from SQL_Latin1_General_CP1_CI_AS to Latin1_General_100_CI_AS_SC_UTF8.   We have few DB's ava...
Latav_Tech's avatar
Latav_Tech
Copper Contributor
Nov 15, 2019

Hi Pedro Lopes 

 

Thanks for the reply, we will test with RTM version and will update.

 

Thanks

Lata

Latav_Tech's avatar
Latav_Tech
Copper Contributor
Nov 20, 2019

Latav_Tech 

 

Hi @Pedro Lopes 

 

We have performed testing with SQL server 2019 RTM version 

"Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64)   Oct 28 2019 19:56:59   Copyright (C) 2019 Microsoft Corporation  Developer Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)" and still seeing this issue.

 

Actual data before conversion is : 

"€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ¡¢£¤¥¦§¨©ª«¬-®¯°±²³´µ¶•¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüý"

 

Data after conversion is :

���������������������������������������-��������������������������������������������������������������������������������

 

We are using following command to perform the conversion.

 

sqlservr -c -m -T4022 -T3659 -s"RTMUTF8" -q"Latin1_General_100_CI_AS_SC_UTF8"

 

Thanks

Lata

Resources