Forum Discussion
sljesra27
Dec 11, 2024Copper Contributor
SQL Server Collation
Hi Experts,
I am doing cross database migration. source database characterset is ISO_1 (ISO 8859-1) and binary sorting.
While checking equivalent collation in MS SQL, I found Latin1_General_BIN.
Later, I checked that all 4 collations are equivalent to the source database characterset and sorting.
Latin1_General_BIN
Latin1_General_BIN2
Latin1_General_100_BIN2
Latin1_General_100_BIN2_UTF8
Could you share your expert advice on the difference between the above collations and which one is best?
No RepliesBe the first to reply