Hi,
We planned to migrate Sybase ASE database to Azure SQL managed instance. Our source Sybase database collation is Binary as like below
"Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 50, bin_iso_1
Binary ordering, for the ISO 8859/1 or Latin-1 character set ( iso_1).
"
But there are 9 types of collation in SQL as below
Latin1_General_BIN
Latin1_General_BIN2
Latin1_General_100_BIN
Latin1_General_100_BIN2
Latin1_General_100_BIN2_UTF8
SQL_Latin1_General_CP437_BIN
SQL_Latin1_General_CP437_BIN2
SQL_Latin1_General_CP850_BIN
SQL_Latin1_General_CP850_BIN2
Any one please assist , which SQL collation suitable for above source Sybase collation.