Questions tagged [collation]
Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.
collation
1,858
questions
0
votes
1
answer
22
views
Average of two strings in alphabetical/lexicographical order with `PAD SPACE` Rules
This is a followup of questions/2510755
What's the best way to find the average of 2 strings with an added constraint that trailing space does not matter to the comparison (the way databases do a PAD ...
-3
votes
1
answer
75
views
What Microsoft SQL Server collation sorts by ASCII case insensitive?
I'm looking for a collation that sorts by ASCII but case insensitive but I am not having any luck finding one. To be explicit, the order I'm looking for is...
!
"
#
$
%
&
'
(
)
*
+
,
-
.
/
0
...
- 1
1
vote
1
answer
53
views
"Binary" Collation in SQL Server
I am working with a legacy database that uses wonky string values as primary keys.
For example, I might find the following primary keys in the same table:
aa
aA
Aa
AA
aa{Space}
AA{Space}
A{Space}A
...
- 21
4
votes
1
answer
73
views
Collation error importing a database using DDEV
I am running a site locally using DDEV, the remote site is on shared hosting (siteground). I created an SQL dump using SSH on the remote site, then imported the database using ddev import-db. The ...
- 41
-1
votes
1
answer
45
views
Collation in Hibernate v6 for ORDER BY clause of JPQL
Hibernate has support for collation in v6: https://docs.jboss.org/hibernate/orm/6.0/userguide/html_single/Hibernate_User_Guide.html#hql-string-functions. A lot of the SO questions about collation in ...
- 1,427
0
votes
0
answers
39
views
mysql 5.7, match against query causing irregular case related problems
Environment
MySQL version 5.7.43-log
DB variables
collation_connection utf8mb4_general_ci
collation_database utf8_general_ci
collation_server utf8_general_ci
table column ...
- 434
1
vote
0
answers
51
views
How to make my postgresql db case insensitive and accent sensitive?
I just found for my surprise, that some of my queries are not working because the postgresql db I created, is taking case sensitive as default for values. I'm sql server user and of course I pretend ...
- 2,952
0
votes
0
answers
158
views
Poor performance with MariaDB (11) and utf8mb4_unicode_ci (vs utf8mb4_general_ci)
We have a large database using MariaDB 11, and up until now, we have been working with various collations, primarily utf8mb4_general_ci. As part of a standardization process, we attempted to encode ...
- 331
0
votes
1
answer
34
views
Collation in SQLite for case-sensitive/binary
What is the opposite of COLLATE NOCASE in SQLite? Is there something like COLLATE YESCASE or COLLATE WITHCASE?
- 108k
0
votes
0
answers
45
views
django migrate from CIEmailField to collation
I did upgrade django version to 4.2.8 and then the CIEmailField() is deprecated.
I used this CIEmailField on the email field of an user. So I had to change to:
email = models.EmailField(unique=True, ...
- 221
2
votes
1
answer
101
views
Binary comparison of strings with SQL Server
Is there a way to perform an accent-sensitive, case-sensitive, "padding-sensitive" (pay attention to trailing spaces) query in SQL Server without having to tweak both operands?
The following ...
- 8,659
0
votes
1
answer
46
views
What should collator do exactly?
Suppose we have an audio classification task (AudioMNIST).
My pipeline and other pipelines I’ve seen consist of the next steps:
Read the dataset (the data samples).
Do the base transforms (merge the ...
- 361
0
votes
1
answer
93
views
Is there a MySql collation that sorts Hungarian characters as per the Hungarian language rules?
The utf8mb4_hungarian_ci not working as expected, as it puts Á before A, for example (and the opposite would be the desired order).
I have tried to figure out if there is a well working collation for ...
- 161
0
votes
1
answer
111
views
Collate Latin1_General_CI_AI equivalent in DB2
Regardless of the collation of the column or the entire db, in SQLServer I wrote Update MyTable Set MyColumn = Replace(MyColumn Collate Latin1_General_CI_AI, 'foo', 'bar') to replace FOO, Foo or foo ...
- 143
-1
votes
1
answer
96
views
How to call MySQL 8 stored procedure with several named parameters? [duplicate]
Looking at this very old question:
Named parameters for stored procedures in MySQL
I try to call mysql 8 stored procedure with several parameters:
create definer = lardev@localhost procedure ...
- 2,941