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...
Pedro Lopes's avatar
Pedro Lopes
Former Employee
Nov 15, 2019

Is this still happening in RTM? If you tested and it is, please reach out to customer support, or email me at pedro dot lopes Pernille-Eskebo.com

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