Stack Overflow
Stack Overflow

Questions tagged [collate]

Is a clause that can be applied to a database definition or a column definition to define the collation, or to a character string expression to apply a collation cast.

Is a clause that can be applied to a database definition or a column definition to define the collation, or to a character string expression to apply a collation cast.

COLLATE (Transact-SQL)

164 questions
0
votes
1 answer

mySQL: update Record / duplicate entry / collate / binary

i'm having a field called url (varchar 255) which is set to unique and utf8mb4_general_ci as collation. when trying to update a record to set this url: https://en.wikipedia.org/wiki/Léa_(film) i am getting a duplicate error because another record…
Fuxi
  • 7,611
  • 25
  • 93
  • 139
0
votes
0 answers

COLLATE Norwegian_100_CI_AI (Norwegian culture) with DISTINCT error "ORDER BY items must appear in the select list if SELECT DISTINCT is specified."

I am getting error while using Norwegian_100_CI_AI with DISTINCT while using Norwegian culture with DISTINCT. ORDER BY items must appear in the select list if SELECT DISTINCT is specified. If I changed the culture to DEFAULT or remove it will run…
user3083835
  • 33
  • 1
0
votes
1 answer

Postgres sorting is not working on special characters using collate

If I execute the postgresql script using collate, I am getting the result sorted only with '.' and it dint consider '__'. I want the special characters '.' and '_' to be sorted first followed by alphabets. PostgreSQL: SELECT * FROM test_spl_char…
Ismail
  • 65
  • 7
0
votes
0 answers

SQL collate, can i not have multiple collates on a column?

Using Microsoft SQL Server Management Studio. I am having an issue with inserting some characters into a database. I read that you have to add a collate to the column to allow for some characters. I need some characters from the Czech language. so I…
user1255276
  • 541
  • 2
  • 5
  • 20
0
votes
0 answers

MSSQL Unique Index/Key with accent sensitive collate (ss != ß, ...) EF Core Code First

I have a table with a combined key (string + date) where the string is set as nvarchar with collate Latin1_General_CI_AS. My problem is now, that inserting words with 'ß' or 'ss' are threated equally and thus violating the uniqueness constraint.…
Phil
  • 135
  • 9
0
votes
0 answers

MariaDB Sort Order COLLATE problem with characters

I can not find information on how to sort by name if it contains special characters. Database stores Željko Arambašić name as Željko ArambaÅ¡ić (latin1_swedish_ci) and when sorted by name it comes of first because of starting Å in DB, but is of…
ikiK
  • 6,328
  • 4
  • 20
  • 40
0
votes
1 answer

collate "sql_latin" and "latin1" mismatch conflict in union only - how to resolve?

using ms sql server, migrating query that pulls data from various tables. There is no joins , only union all. It still gives me the error, even though i explicitly try to use same collate std - neither works. "Cannot resolve collation conflict…
ERJAN
  • 23,696
  • 23
  • 72
  • 146
0
votes
0 answers

Unicode sort number before space in Linux environment

In my Linux environment, I use u8_casecoll to sort strings. With local set to "en_US.UTF-8", below is the sort order. "Member1_LN" "Member Group" But in Windows environment, I use CompareStringW to sort, and below is the sort order. "Member…
Natarajan R J
  • 11
  • 1
0
votes
1 answer

Database collation error in SQL Server Management Studio

I'm trying to change the collation of my database in SQL Server Management Studio but I'm always getting an error Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun…
Lawrencxe
  • 81
  • 4
  • 18
0
votes
2 answers

H2 DB Incorrect special characters sorting

I'm trying to sort column data in my h2 database, but it isn't correct. I think that change of collation may help. I tried to set collation in datasource url in many ways e.g.: spring.datasource.url = jdbc:h2:mem:testdb;COLLATION='ENGLISH'…
user11621177
0
votes
1 answer

What is the function Modern_Spanish_CI used for in SQL?

What purpose would the following function be used for in SQL when specifying fields for a left outer join; y.[ACCOUNT_ID] COLLATE Modern_Spanish_CI_AS= z.[ACCOUNT_ID] COLLATE Modern_Spanish_CI_AS
Kate English
  • 55
  • 1
  • 6
0
votes
2 answers

Access pass-through query passing comma separated list as a parameter to SQL stored procedure

The SQL server is 2008. I have an Access 2016 front-end for reporting purposes. One report requires that one or more Product Classes from a list be chosen to report on. I have the VBA that creates the pass-through query with the appropriate single…
Tim
  • 71
  • 9
0
votes
1 answer

How to use "COLLATE AS" with Sequel and Ruby

When using Sequel, is it possible to produce a "SQL WHERE" clause that contains "COLLATE AS?": ColumnName COLLATE Latin1_General_CS_AS If not, then what can I use to do this? I searched through the Sequel documentation and Stack Overflow and this…
tonysepia
  • 3,340
  • 3
  • 27
  • 45
0
votes
1 answer

Is there a way to ignore and accept collate?

I have a problem with a SQL request : SELECT CLCLEUNIK, NOM, VILLE, CODEP FROM CLIENT WHERE NOM LIKE :nom COLLATE French_CI_AI In my case, I use the collate because a user can search "rhone" and it will find "rhône". But my problem is that now…
NeoKerd
  • 189
  • 3
  • 13
0
votes
1 answer

SELECT WHERE LIKE returns incomplete results and the reason is not diacritics

I am searching for results WHERE name LIKE '%Soucek%' (or I tried '%Souček%' or '%Soućek%'. I get one result. (I set the whole column to be COLLATE SQL_Latin1_General_CP1251_CI_AS). If I search for '%Sou_ek%' i get all results there are. I dont…
Jakub Bares
  • 159
  • 1
  • 11
1 2 3
…
10 11