Questions tagged [sql-server-collation]

I am using data in my query from another database from same server I am getting the given error Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP850_BIN2" in the equal to operation.. Native…

I need to insert some Hawaiian 'Okina string name as 'Kapiʻolani'; However in the SQL Server 2017 database it shows like Kapi?olani with a question mark. I did some research and tried like this article's solution: CREATE TABLE Organization3 (Name…

I have a table containing some regexes. By default the table was created using utf8mb4_general_ci collation. Everything is fine until i try to add a regex containing homoglyphes like this one. The regex // once stored in my database will simply…