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
2
votes
1 answer

divide list to sublists in groovy

I am trying to divide a list of string into 4 sublist (which should have all elements of original list balanced among them). I have tried following approach but i am getting reminder elements into a 5th list. I need only four sublists and reminder…
deewreck
  • 113
  • 7
2
votes
0 answers

How to handle columns with different encodings in Sequelize?

I am facing problems with storage and retrieval of emojis in MySQL 5.7 with Sequelize (v4/v5/v6)? I had to change the encoding of the particular column from utf8 to utf8mb4 to make MySQL store the data as expected but now I am not able to operate…
Swastik Padhi
  • 1,849
  • 15
  • 27
2
votes
3 answers

ORACLE 18c XE (18.0.0.0.0) - MAX_STRING_SIZE = EXTENDED (COLLATE BINARY_CI) problem

I set MAX_STRING_SIZE from STANDARD to EXTENDED with this command: ALTER SYSTEM SET MAX_STRING_SIZE=EXTENDED SCOPE=spfile; This query is finished with "Done". I checked it with this command: SELECT * FROM v$parameter WHERE name =…
Zééé
  • 31
  • 1
  • 7
2
votes
3 answers

How to order by a varchar choosing the collate order with a case-when switch, in PostgreSQL

This simple function returns an ordered list of title strings. create or replace function testfunction1 () returns table ( id bigint, lang_code tlang_code, title varchar ) stable language sql as $$ select id, lang_code,…
coterobarros
  • 941
  • 1
  • 16
  • 25
2
votes
2 answers

How to hierarchical query in PostgreSQL with language-dependent data

I am trying to retrieve a hierarchical ordered result from a query on an auto referenced table like this: create table category ( id serial, -- parent category, parent_id integer default null, -- null for root category --…
coterobarros
  • 941
  • 1
  • 16
  • 25
2
votes
2 answers

MySQL LIKE with json_extract

I have a MySQL query, where I filter by a json field: SELECT id, username FROM (SELECT id, Json_extract(payload, '$.username') AS username FROM table1) AS tmp WHERE username = 'userName1'; It returns 1 row, which…
Battle_Slug
  • 2,055
  • 1
  • 34
  • 60
2
votes
0 answers

How to localize string ordering in SQLite with EF Core

I’m using SQLite v3 database with EF Core. My database contains entries with diacritics, like this: Bratislava Leopoldov Lučenec Ľuboriečka Veľký Krtíš I need to sort these entries alphabetically I.e. get them ordered as above. The problem…
Draex_
  • 3,011
  • 4
  • 32
  • 50
2
votes
0 answers

JPA Criteria subquery collate: Invalid query key in expression

I am using ecliselink, and try to convert a native SQL to Criteria API which contains subquery, but got exception that is related to collation of subquery. Calculate sales order total from item prices using subquery: public class SalesOrder { …
Dave
  • 759
  • 2
  • 9
  • 31
2
votes
1 answer

Collation conflict within the same database

I perform a union on two queries. Simplified version looks like this: select * from Audit.dbo.PolicyList_t pl union select * from Audit.dbo.PolicyList_CurrencyFlip_t pl Both tables are in the same database. However, I get the following…
PiotrWolkowski
  • 8,408
  • 6
  • 48
  • 68
2
votes
1 answer

How to collect items in a list of maps in Scala

If I have a sequence of maps with repeating values and sub maps that look like this: val from = Seq( Map("aaa" -> Map("bbb" -> Map("ccc" -> List(1)))), Map("aaa" -> Map("bbb" -> Map("ddd" -> List("a","b")))), Map("aaa" -> Map("bbb" ->…
OutNSpace
  • 373
  • 2
  • 8
2
votes
1 answer

How can I define my custom collate in Sqlite (in Objective-C) (for iPhone)

I need to define an arbitrary comparison method for sqlite in code. I need to be able to search for "e" and find both "e" and "é" (this is an example and the actual characters are in Persian). any help appreciated.
Ali Shafai
  • 5,141
  • 8
  • 34
  • 50
2
votes
1 answer

How to use collate option with rails3 migration?

I am using Sqlite3 which comes default with rails 3. How to change a particular column to collate NOCASE with a rails migration? I tried out t.change :name, :string, :collate => "NOCASE", but the case insensitive search for find_by_name("test",…
Karthick
  • 41
  • 4
2
votes
1 answer

How do I properly frame this collate?

The following code: SELECT * FROM portal.workflow AS w INNER JOIN portal.workflow_type AS wt ON w.workflow_type_id = wt.workflow_type_id WHERE wt.doc_type IN ('CentreEV', 'Expenditure Voucher') AND w.varchar_1 NOT…
Michael A
  • 9,480
  • 22
  • 70
  • 114
2
votes
2 answers

How can I convert "SQL_Latin1_ General" Collate Using an SSIS Package?

We've just noticed 2 of our servers have been set up using SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS. I've created a script which compares two sources of data again each other (as it's a simple SELECT statement I haven't included it, it…
TJH
  • 189
  • 1
  • 5
  • 18
1
vote
0 answers

Crystal Reports Server 2011 character set compatibility

I'm currently working on SQL Server 2008 R2 and plan to get Crystal Reports Server 2011 up and running with SQL Server. Wanted to see if Crystal Reports Server 2011 supports the Latin-1 general character set collation. Just wanting to make sure…
Trish
  • 93
  • 1
  • 4
  • 12
1 2
3
…
10 11