collation

2 Topics

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?
Solved
sljesra27
Feb 09, 2025 Place SQL Server
354Views
0likes
2Comments
Languages supported by DQS for Cleansing and Matching
First published on MSDN on Mar 14, 2013 Data Quality Services (DQS) internally stores the domain values in a knowledge base in the Unicode format, and uses the trigram algorithm, which is language agnostic, to compare the domain values with your source data for the cleansing and matching operations.
SSIS-Team
Sep 11, 2020 Place SQL Server Integration Services (SSIS) Blog
1.1KViews
0likes
1Comment