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

SQL COLLATION can not resolve

On our development server, we have a database server with collation: COLLATE SQL_Latin1_General_CP1_CI_AS. After deploying our solution on a server and that database server has collation: COLLATE SQL_Latin1_General_CI_AS That means if we have a…
olidev
  • 20,058
  • 51
  • 133
  • 197
0
votes
0 answers

Empty error when using collate fn and num workers at same time in dataloader

I am trying to load input and label sequences and their corresponding masks using a collate fn which adds padding to the batch of sequences with different lengths. When using a higher num worker, I get an 'Empty' error: Empty …
Oumar Kane
  • 1
  • 1
0
votes
1 answer

"collate_fn" for Huggingface Hyperparameter Tuning

I am following this tutorial on how to do hyperparameter tuning with Huggingface and Wandb. Most of it works but I don't quite understand what the "collate_fn" Function is doing and how I have to adjust it for my use case. My dataset is looks like…
Maxl Gemeinderat
  • 197
  • 3
  • 14
0
votes
1 answer

Mysql - convert Tables in Database to diffrent encoding and collate - foreign key constraints are failing

I have a MySQL Database with the Charset utfmb4 and the collate utf8mb4_unicode_ci. No, I noticed that this influences my search queries where I use like '%grün%'. This would also match 'Grund'. I found that this behavior is because of the charset…
thopaw
  • 3,796
  • 2
  • 17
  • 24
0
votes
0 answers

Inconsistent Results from Cross-Server Query

I have a query that yields inconsistent results. I receive a different number of rows almost every time I run the query. I receive no errors. I have tried running the query from all of the servers in the query. I also tried running the query…
Brendan Lesinski
  • 115
  • 7
0
votes
0 answers

clickhouse: Invalid use of collate in window functions

Question - clickhouse: Invalid use of collate in window functions Version - 22.8.5.1 Recurrence create table test_window_collate(c1 String, c2 String) engine=MergeTree order by c1; insert into test_window_collate values('1', '上海'); …
bql
  • 1
  • 1
0
votes
0 answers

Sorting of special characters in Sequelize Postgres like in Javascript

I am using Sequelize to interact with my Postgres database. Recently, the QA team pointed out that special characters like @, #, etc. are ignored in the sorting while we wanted Javascript-like sorting. I was somehow able to fix the issue in one…
Sandeep Parashar
  • 197
  • 1
  • 14
0
votes
1 answer

Can I retrieve Arabic text that stored in varchar column in Arabic Collate that stored from another database in Latin Collate

I have two database one of them in Latin collate and have Arabic data. In some case I take data that stored in the first database and store it in the second database table which has Arabic collate but each column in both database have varchar…
haneen
  • 3
  • 4
0
votes
0 answers

How to stop Thorn (þ) character also replace TH when using replace()

When completing a replace on a set of data using a list of non-standard ascii characters, the string 'TH' is being replaced as it has been identified as the Thorn (þ) character Any suggestions on how to stop this from happening? An example with the…
R235L
  • 9
  • 1
0
votes
1 answer

SQL collate using select query on multiple fields

I have an a spring boot project with a nativeQuery sql query that is executed by front end code each time a user types in a letter in a certain field. In the query, user input serves as a parameter to two database fields. I currently have it like…
chocalaca
  • 330
  • 2
  • 17
0
votes
0 answers

CREATE DATABASE: Difference between CATALOG_COLLATION and COLLATE

There seems to be a big difference between CREATE DATABASE COLLATE and CREATE DATABASE WITH CATALOG_COLLATION. DECLARE @CollationName NVARCHAR(4000) = 'Latin1_General_CI_AS' SELECT [Name], COLLATIONPROPERTY([Name], 'CodePage') as Code_Page,…
Nitrox Tank
  • 1
  • 2
0
votes
2 answers

equivalent for "COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL" in snowflake

SQL Server: CREATE TABLE outpatients ( lastupdatedby nvarchar(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, quote_id decimal(11,0) NULL, customersite_ID decimal(11,0) NULL) What's the equivalent for COLLATE…
Madhu Pasham
  • 21
  • 5
0
votes
1 answer

Creating a computed(possibly hidden) column using COLLATE SQL

I'm using SSMS 18. I have a column with 500,000,000 records that are codes. Those codes begin with a number of characters, that represent an object, followed by random characters. For example: AZ4658 & TU874U = A-Z sd8udf & kl8udf = a-z 0huoer &…
Aidan Devlin
  • 1
0
votes
0 answers

Is there another locale with the same sort (collate) order as "C"?

This may be a dup of an older question, but I can't seem to narrow down my searching to get the answer I need from the flood of unrelated results. I used to have export LC_ALL=C in my .bashrc, but I just recently figured out that Gnome terminal (or…
user3068400
  • 51
  • 2
0
votes
1 answer

Hi, I am trying to find all instances of utf8mb4_bin in my table, using REGEXP, but cannot get the right results

I can find single chars using: SELECT * FROM table WHERE column LIKE '%Â%' COLLATE utf8mb4_bin; -- 1 result: 246.8 ± 11.7 I have tried a dozen or more REGEXP with COLLATE utf8mb4_bin, but none return what I need. Like: SELECT * FROM table…
Lou Radwan
  • 1
  • 1
1 2 3
…
10 11