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
1
vote
1 answer

COLLATE Vietnamese_CI_AI is not working correctly with LIKE '%value%'

I have data in Vietnamese with accents: Bảo Linh, Ngọc Mai If I search with query: select * from profile where fullname COLLATE Vietnamese_CI_AI like '%ao%' It returns Bảo Linh Problem is when I search with: select * from profile where fullname…
Kannagi Lee
  • 23
  • 6
1
vote
0 answers

Different number of bounding boxes per image, tried padding, but boxes with zeros are invalid for training object detection model

I am training a faster r cnn for object detection, or at least trying to. I have an annotated dataset with bounding boxes and labels, however each image has a different number of bounding boxes as each image has a different number of objects. I got…
Mees Elizabeth
  • 11
  • 1
1
vote
0 answers

How to configure Oracle Column's DefaultValue And Collate Value

In Oracle 19c, I want to specify the default value of a column and the collate property at the same time. create table id_table( name varchar2(64) collate binary_ai, id varchar2(8) collate binary_ci ); insert into id_table…
user13746660
1
vote
1 answer

What locale/rule gives this string sort order?

I have subscribed to a cloud drive service. All good until I needed to check that all folders in a long list had been actually uploaded. I realized that the name-based sort order in my local system is different than the one used by the remote cloud…
julio
  • 69
  • 7
1
vote
1 answer

mysql order by collation

I want to sort the results of MySQL based on the best match by using collate query => zeķ want to show Vīriešu zeķes Sieviešu zeķes Daivinga zeķes . . . Mācību līdzekļi I mean show all characters match (zek, ZEK, zeķ, etc) but sort by character…
Arash Rabiee
  • 1,019
  • 2
  • 16
  • 31
1
vote
1 answer

PDO fails to return MySQL search using COLLATE utf8mb4_unicode_ci

I have a simple PHP PDO query on a MySQL table which returns one result in phpMyAdmin console but fails to return any rows within PHP using the query below... Why would/could there be a different result from within phpMyAdmin and from a PDO…
RPB1001
  • 11
  • 2
1
vote
2 answers

Can we have performance issues when using mixed table charsets in MySQL or in Postgres?

I'm working on a database that has tables with different charsets. Since it's a big database, I was wondering if it could lead to a performance issue. Yes, the usual value comparison a DB is usually doing is the JOIN and is done comparing integers,…
sekmo
  • 1,517
  • 18
  • 27
1
vote
3 answers

perl sort substrings using array to determine collating sequence

I have a list of strings of the…
Milton Zlatic
  • 11
  • 3
1
vote
1 answer

Bypass SQL COLLATE

Is there a way to "bypass" the SQL collate logic? I want two different bytearrays to give me two different keys no matter what and without SQL trying to collate them. I prefer to use the nvarchar data type if possible. The most generic COLLATE…
user628904
  • 726
  • 1
  • 7
  • 20
1
vote
1 answer

How to index a multilanguage entity in PostgreSQL

Here I am creating table product_feature_text, having a 1:N relation with table product. As the application must support several user languages, a lang_code column is added to segment english texts from other language texts. As I want to present the…
coterobarros
  • 941
  • 1
  • 16
  • 25
1
vote
0 answers

R char sorting according Windows-1252 on linux

Question: I need to sort a vector of character strings on my linux (ubuntu) machine in the same way as it is sorted on another windows machine with Windows-1252 locale collate. On windows it works like this: > order(c("A", "a", "0", "_", "/")) [1] 5…
dpelisek
  • 884
  • 3
  • 13
  • 22
1
vote
1 answer

How to add collate in laravel query

In my project I am allowing user to search any thing. Recently facing an issue in Like query. Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like' I got a solution for this issue but now…
Alfiza malek
  • 994
  • 1
  • 14
  • 36
1
vote
2 answers

collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"

in some procedure that i work on, i write this code: update a set a.custName = b.custName from #x as a inner join pl_Customer as b on a.Company_Code = b.Company_Code and a.cust = b.Cust ans i got this error: Cannot resolve the collation conflict…
M.R
  • 59
  • 1
  • 9
1
vote
1 answer

Reading non latin character from XML variable and inserting into table

I am trying to insert some information in Arabic from a XML variable into a SQL Server table. I did something like the below. However it does not work. Could you please tell what is missing? Create Table EmployeeTbl ( firstname nvarchar(100), …
Bilal Bakri
  • 11
  • 1
1
vote
1 answer

Problems with COLLATE in PostgreSQL 12

My problem: I work in Windows 10 and my computer is set-up to Portuguese (pt_BR); I'm building a database in PostgreSQL where I need certain columns to remain in Portuguese, but others to be in en_US - namely, those storing numbers and currency. I…
cmgpimenta
  • 11
  • 2
1 2 3
…
10 11