Forum Discussion

sljesra27's avatar
sljesra27
Copper Contributor
Dec 11, 2024

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

Resources