Questions tagged [collation]
A collation is a set of rules that determine how data is sorted and compared for comparing characters in a character set.
373 questions
5
votes
2
answers
204
views
STRING_SPLIT - issue with NCHAR(769) and SQL_Latin1_General_CP1_CI_AS
In database
on SQL Server 2022 Standard Edition (CU19)
with default collation SQL_Latin1_General_CP1_CI_AS
I am splitting CHAR(31) separated values using STRING_SPLIT. I have an issue when the ...
- 4,390
0
votes
0
answers
33
views
Collation compatibility between base SAS and PostgreSQL
I'm new to databases and having an issue with sorting/merges. I currently work in base SAS. I connect to my data tables in PostgreSQL 13 using the following code:
libname name odbc dsn="...
5
votes
1
answer
266
views
Do I need to run sp_refreshview and sp_refreshsqlmodule after changing column collations?
I look after a database for a vendor’s application that our system team uses to store passwords. This database is part of a three-node AlwaysOn Availability Group. The instance and database currently ...
- 51
0
votes
1
answer
188
views
Keeping collation versions stable in Postgres docker images
I'm using the official PostgreSQL docker images, so my Dockerfile starts with
FROM postgres:17
I noticed that I was getting collation mismatch warnings (I'm using en_US.utf8):
DETAIL: The database ...
- 117
3
votes
2
answers
246
views
Restore PostgreSQL database from linux to MacOS with utf8 collated columns
I want to copy from a postgres db running on linux with column definition like:
col1 varchar COLLATE "en_US.utf8" NULL;
This collate does not exist on macos, or at least, it's called en_US....
- 53
3
votes
2
answers
194
views
Can I change the collation of a table and its columns without using convert to?
All of the tables and columns in my database are using the utf8mb4 character set and utf8mb4_unicode_ci collation. I'd like to migrate to utf8mb4_0900_ai_ci collation but using convert to is ...
- 143
1
vote
1
answer
88
views
CONVERT TO CHARACTER SET isnt working with modify column
I am trying to convert the table charset and collation along side preserving some of the columns explicit charset and collation. I need to do it in single alter statement. If i use following, it is ...
- 111
0
votes
1
answer
952
views
Incorrect string value for MariaDB + utf8mb4 + utf8mb4_uca1400_ai_ci
Incorrect string value:
\'\\xCD\\xCF\\xD7\\xA7\\xC9\\xFA...\\
Everything on my server should be utf8mb4 and utf8mb4_uca1400_ai_ci so let's go through everything.
My my.ini file on Windows 10 for ...
- 769
0
votes
2
answers
300
views
upgrade postgres cluster with changing collation & encoding
we face a problem when trying to pg_upgrade pg12 > pg14.
our source instance has en_US.UTF-8 which it should not have had to begin with, and the new pg14 cluster is being initiated with de_DE.UTF-8....
- 293
1
vote
1
answer
334
views
Any downsides of using UTF8 collation in SQL Server 2019?
We have some columns in the table that could possibly get some non-ANSI characters and we must store them. Before the SQL Server 2019 there was the only 1 option - NVARCHAR data type, however starting ...
- 191
0
votes
1
answer
141
views
A collation that ignores cedillas for comparison?
Cedillas are mutations applied to letters in some languages, like portuguese, french, turkish and romanian. Some words: "coração", "açúcar", "linhaça" (letters 'Ç', 'Ş', ....
- 103
1
vote
1
answer
433
views
Illegal mix of collations
I am managing a MariaDB 10.6 Server for a bunch of people. I also dump the databases for backup purposes. Recently, one of the databases started to make problems while dumping:
mysqldump: Couldn't ...
- 111
1
vote
1
answer
116
views
MySQL: using NAME_CONST internally
I'm using MySQL 8.0.32
I have some questions about an internal conversion, that I don't understand. In addition to this, sometimes this conversion is shown in SHOW FULL PROCESSLIST, as its execution ...
- 155
1
vote
1
answer
100
views
Collation difference in PostgreSQL on AWS RDS and local machine
I have an issue with collation in PostgreSQL when sorting a result set. We use AWS RDS PostgreSQL, and we want to sort query results in a specific way. Locally, everything works perfectly on my laptop ...
- 119
11
votes
1
answer
1k
views
I can't select a certain record with like %value%
I have a table with this entry
ID
Navn
2700
Aaen Agro I/S v/Niels-Christian Aaen
Where Navn has the collation Danish_Norwegian_CI_AS. But when I
SELECT * FROM [dbo].[Bruger] WHERE [Navn] LIKE N'%aen%';...
- 211