MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Equivalent collation for SQL_Latin1_General_CP1_CI_AS
Posted by: Bernt Marius Johnsen
Date: July 14, 2019 01:36AM

Hi,

The equivalent collation should be the latin1_general_ci collation. MySQL latin1 charset is a 1-byte character set pretty identical to CP1 (aka cp1252) in MS SQL. Note that this collation is not accent sensitive (like SQL_Latin1_General_CP1_CI_AS).

However: You should seriously consider using the Unicode utf8mb4 character set when you migrate. If you do, the equivalent collation would be utf8mb4_0900_as_ci (which is accent sensitive).

In any case, you can not expect collations from two database vendors to be identical, so you might run into issues when you migrate, e.g. if there is a unique key constraint on the column in question.

Options: ReplyQuote


Subject
Written By
Posted
Re: Equivalent collation for SQL_Latin1_General_CP1_CI_AS
July 14, 2019 01:36AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.