SQL Server Collation vs Sybase ASE

Tahir Khalil 41 Reputation points


We are planning a test migration from Sybase ASE 16.0 to MS-SQL Server Microsoft SQL Server 2019 (Linux).

Our current Sybase is on Ubuntu Linux with following character set & sort order:

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).

What is the best match collation in SQL Server? I am confused between the existing collation & sort orders in SQL Server.

Can someone please suggest?



SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
506 questions
0 comments No comments
{count} votes

Accepted answer
  1. YufeiShao-msft 7,076 Reputation points

    Hi @Tahir Khalil

    The Latin-1 code page with binary sort is collation Latin1_General_100_BIN, Set or change the database collation

    You can use SSMA to quickly migrate SAP ASE database to SQL Server: Migration guide: SAP ASE to SQL Server, use SSMA you can set project conversion, migration, and the type mapping options


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful