New answers tagged collation
If you do not specify a collation when creating a table (regular or temporary or variable), then the database's default collation is used. When creating a temporary table (not table variable), it exists in tempdb, so tempdb's default collation is used. TempDB's default collation is derived from the server default since the server default was used to create ...
A bug in the REPLACE function? Or in SQL Server in general? I'm not so sure about that. The only "issue" here is merely not fully understanding how string comparisons are handled. Collations define how certain characters will compare against other characters. Sometimes there are rules about certain combinations of characters equating to one or more other ...
For the purpose mentioned in this post, you may only use: SQL_Latin1_General_CP1251_CI_AS [ it works for Arabic and Persian as well as English/Latin character sets ].
Top 50 recent answers are included