| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 17:05:12 GMT
content-type: text/html; charset=utf-8
cf-ray: 963cc2e28b048a2a-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=ce5eb8ec-0a90-40e5-a15b-e585a32a3c5d; expires=Thu, 23 Jul 2026 17:05:12 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: ea5b67f5-c882-40f7-b77d-1584917fe95a
x-worker-origin-response-time: 497000000
x-dns-prefetch-control: off
set-cookie: prov=ce5eb8ec-0a90-40e5-a15b-e585a32a3c5d; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=oJ62raCXafCDuZuv7OpAqnGTuIhghOkjdAMAgdueFo8-1753290312-1.0.1.1-fzDonsSNTR8tRbkdIEq7SkIegOkixYDZ5EROQLpvcYrfKffsIJ1bSvzxuMRyMa7Doue7OETKiM7dKQ3W6KCaXnQQ53ynGQfybn9XBKPxQqU; path=/; expires=Wed, 23-Jul-25 17:35:12 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=B8EB4o4vyTeWd1ogJRT4lS3bCayquLoORvBHrP9OfJg-1753290312593-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'collation' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [collation]
A collation is a set of rules that determine how data is sorted and compared for comparing characters in a character set.
370 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
3
votes
2
answers
211
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....
2
votes
2
answers
91
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 ...
1
vote
1
answer
58
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 ...
0
votes
1
answer
612
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 ...
0
votes
2
answers
215
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....
1
vote
1
answer
272
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 ...
0
votes
1
answer
121
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 'Ç', 'Ş', ....
1
vote
1
answer
285
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 ...
1
vote
1
answer
94
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 ...
1
vote
1
answer
77
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 ...
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%';...
0
votes
0
answers
64
views
Can I change collation_connection permanently? Having issues running queries in Navicat on a remote MariaDB server
I try to have everything utf8 with utf8mb4_unicode_ci collation. As far as I can see, everything is.
But occasionally in Navicat, I get an error message about an illegal mix of collations - that and ...
0
votes
1
answer
1k
views
Why is the character set for the uca1400_ai_ci collation NULL?
I've been working with database collations of late. I generally don't like ambiguous queries such as SHOW COLLATION so I eventually found the source via the following query:
SELECT *
FROM ...
0
votes
1
answer
270
views
Does SQL Server application database and tempdb collation mismatch affect performance
I installed the SQL Server 2019 instance for our ERP with the default French_CI_AS collation.
The ERP uses Latin1_general_BIN and doesn't seem to have any problems. I only realised the potential issue ...
4
votes
1
answer
636
views
MSG 14262: The specified @server_name ('<server_name>') does not exist
We have an SQL Server 2019 instance (let's call it 'sample_instance') with server collation of Turkish_CI_AS. When I try to create a job, SSMS creates the part of the script that adds the target ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 167
mysql × 75
postgresql × 73
character-set × 39
unicode × 35
encoding × 28
t-sql × 26
mariadb × 25
utf-8 × 23
sql-server-2012 × 21
sql-server-2008-r2 × 16
performance × 14
case-sensitive × 13
sql-server-2008 × 13
index × 12
sql-server-2016 × 11
sql-server-2014 × 10
sql-server-2019 × 9
database-design × 8
mysql-8.0 × 8
localization × 7
configuration × 6
migration × 6
oracle × 6
more related tags
Hot Network Questions
- Is a Rakshasa Immune to True Strike?
- What fiction genres do literary agents recognize?
- Business technical issues lead to unsuccessful payment being considered successful. Do I have any duty to notify?
- How can I grow kelp or seaweed at home in a small container?
- Define command valid only for a specific environment in expl3
- Write two very different programs with the same characters
- Deployment fails with an error "Error (1): Unexpected end of JSON input"
- Why “brew search” for “peertube” machtes with “freetube”? How does the search work?
- Where did the baby AT motherboard format come from?
- How to Select and Isolate Only the Fillet Parts of a Curve in Geometry Nodes?
- Issue with OR operator in QGIS Rule-Based Labelling expression
- Is it rude to make someone an academic reference without getting their permission first?
- Ubuntu gives the message "You are in emergency mode."
- Not sure which test statistic to look at with regression with interaction term
- How to 'scale' a square list?
- Is a chemistry-first technological paradigm as plausible as one focused on physics or biology?
- Does Philosophy Need Quotes?
- TeX development in C instead of Pascal
- Is classical logic the consensus among contemporary logicians?
- Distribution of a dot product of multinomial variables
- How much time should I take for "self transfer" without checked-in baggage?
- Entity Framework - Is there a safety mechanism to prevent accidentally running Update-Database?
- How to model This Twisted Torus?
- Ubuntu Server installation -- options for boot disks are grayed out