1,894 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Advice
0
votes
0
replies
61
views
How to add a new collation for NOCASE in SQLitestudio
I' have just installed a new computer and added SQLiteStudio3. Tried to open a database created by a mORMot application and got the error: "no such collation sequence: SYSTEMNOCASE".
I have ...
0
votes
1
answer
90
views
Is the lack of orthographic variant support for Scandinavian languages in the JavaScript Intl API a known limitation?
Official spelling reforms in Scandinavian languages in the 19th and 20th centuries replaced digraphs (two-letter combinations) with single, distinct letters:
Danish: å = aa, æ = ae, ø = oe;
Swedish: ...
8
votes
2
answers
585
views
Why does the Java collator for the Hungarian locale mix E and É?
I want to order a huge list of countries, and I have noticed that, for example, E and É are treated as equals. But in the Hungarian grammar, E comes before É, so a rule should be added, 'E < É'.
...
0
votes
0
answers
53
views
Collation_connection always set to utf8mb4_0900_ai_ci on a database created with utf8mb4_0900_as_ci
I've an issue with the collation utf8mb4_0900_as_ci (Accent Sensitive) I used for creating everything in a database. Once I connect to the database (I use EFCore 9.0 with POMELO but the problem also ...
1
vote
0
answers
55
views
Postgres Temp table collation for text columns
We are converting a large database system from SQL Server 2022 to Postgres 18.
The SQL Server collation is Latin1_General_CI_AS.
The Postgres database default collation is English_United Kingdom.1252.
...
0
votes
1
answer
48
views
How to force the collation on a JSON_VALUE return type in MySQL
I needed to do a case-insensitive comparison with a JSON_VALUE() result type.
By default, the return type of JSON_VALUE is case-sensitive.
As per the documentation at https://dev.mysql.com/doc/refman/...
2
votes
1
answer
168
views
SqlQuery result : Microsoft.Data.SqlClient.SqlException: 'Invalid column name : 'Value'.'
I have this EF Core query on a SQL Server database to get the database collation (code from Copilot):
var collation = dbContext.Database.SqlQuery<string>($"SELECT collation_name FROM sys....
4
votes
2
answers
130
views
Sort respecting diacritics (PostgreSQL)
Can I get PostgreSQL to sort rows by a string column respecting the accents?
I found out that it's possible to define a custom collation having "ks" (colStrength) set to "level2", ...
0
votes
2
answers
101
views
postgresql unaccent and case insensitive
I have this query :
select * from entrees
where account_id = 1
and categorie_id = 2
and recurrent = false
and montant < 0
and ABS(montant) >= 50000
and date_de_valeur >= '2025-05-01'
...
-1
votes
0
answers
27
views
Repeated collation errors in stored procedure in MySQL [duplicate]
I have written this stored procedure which reports monthly performance if employees by their activity and batchwise runrates.
'''
DELIMITER $$
DROP PROCEDURE IF EXISTS roadware_pts....
2
votes
0
answers
149
views
Illegal mix of collations on basic SELECT query
I got the following error on a simple select query:
[21-May-2025 20:20:52 America/New_York] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (...
2
votes
1
answer
115
views
After Collation change not being able to update values (MariaDB and MySQL)
I tried to update my tables collation from utf8mb4_general_ci to utf8mb4_unicode_ci, which is pretty simple specially using pmpMyAdmin.
But after several attempts to update values it seems that ...
2
votes
1
answer
142
views
Is it problematic to change the collation setting of only text columns without changing the database collation in PostgreSQL?
I am working with a PostgreSQL database and I need to change the collation setting of specific text columns. However, I do not want to alter the collation of the entire database.
The database ...
1
vote
1
answer
175
views
How does postgres know which collation to use during database creation if there are two with the same locale?
I have a Postgres DB created on Azure (probably not very important, added for context).
That DB has predefined set of collations. All deterministic.
Among them there is a collation with name en-GB-x-...
0
votes
1
answer
213
views
The Collation of a database in SQL Server can affect the comparison results of date strings
I noticed a strange phenomenon when comparing date strings in SQL Server
SELECT CASE WHEN '2025/3/25' < '2025-03-18' THEN 'Y' ELSE 'N' END
1 result is Y
select CASE WHEN '-' < '/' THEN 'Y' ...