Question : I am getting the following error message when running the query below: Cannot resolve the collation conflict between […]
Tag: collation
How to determine the collation of a table in PostgreSQL?
Question : I want to script a check of the collations used on my tables in PostgreSQL, but googling for […]
What is difference between Arabic_100_CS_AS_KS_WS_SC_UTF8 and Latin1_General_100_CS_AS_KS_WS_SC_UTF8?
Question : Starting from SQL Server 2019, it supports UTF-8 as collation. However, according to the following queries: SELECT COLLATIONPROPERTY(‘Arabic_100_CS_AS_KS_WS_SC_UTF8’, […]
Does PostgreSQL support ICU collation’s options and settings?
Question : ICU Specifies different LDML Collation Settings. Some of them seem pretty interesting, especially the ones on case and […]
Using CONVERT TO CHARACTER SET for changing only collation?
Question : I think the answer to this is an obvious yes, but I’m having trouble finding confirmation on it. […]
Case-insensitive collation still comparing case-sensitive
Question : I am currently trying to create a table with a text column which will compare case insensitive by […]
Different collations for different databases [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
SQL Server 2016 Collation and Internal table Glitch?
Question : My Steps: installed SQL 2016 with collation SQL_Latin1_General_CP850_CI_AS Restored Database to Stage instances with same collation as Database.(original […]
Is worth change databases collation from Latin1_General to Modern spanish, migrating to a new server
Question : We are migrating 3 databases tables from Sql Server 2000 to a new sqlserver 2014. I know that […]
ORDER BY and comparison of mixed strings of letters and numbers
Question : We need to do some reporting on values that are usually mixed strings of numbers and letters that […]