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 Collate Query Running Forever

I have a particular query in MySQL where it compares values from two different table (indexed) using collate but this does not execute for hours. The query is provided below: create temporary table elig_temp select id from table_elig; create index…
Syrus
  • 25
  • 6
0
votes
1 answer

How to handle case sensitive column with utf_unicode_ci

I have a mysql database that use utf_unicode_ci (case insensitive) But in one particular case there is a single column of one table where i need to save a case sensitive unique string (for example: iX3hR0) In this case the correct solution is to…
ipel
  • 1,326
  • 1
  • 18
  • 43
0
votes
1 answer

How to use Collate in Hibernate for french char set

Hi I'm trying to use collate on a view which has column name per_va_first_name when I use the following query : SELECT * FROM person_view WHERE NLSSORT(per_va_first_name, 'NLS_SORT = FRENCH_AI') = NLSSORT('mickaël', 'NLS_SORT =FRENCH_AI') I get…
RaMs_YearnsToLearn
  • 459
  • 6
  • 11
0
votes
1 answer

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS"

i have one dynamic sql statement when i am executing that statement then i am getting the error Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" i use COLLATE SQL_Latin1_General_CP1_CI_AS or COLLATE DATABASE_DEFAULT but…
Thomas
  • 33,544
  • 126
  • 357
  • 626
0
votes
1 answer

COLLATE Issues with sql server

I have 2 tables I am trying to join on PRId. SELECT LOT_NUMBER FROM Domain.dbo.LOT_TABLE JOIN Domain.dbo.SELINAS ON Domain.dbo.SELINAS.PRId = Domain.dbo.LOT_TABLE.PRId; When I run this it gives me following error: Cannot resolve the…
Angelina
  • 2,175
  • 10
  • 42
  • 82
0
votes
2 answers

Sorting a varchar column as a numeric one using collate

I have a MySQL table that has a VARCHAR column. The column contains only numbers and I want to be able to sort it numerically, i.e. as 100, 101, 1001. Currently it sorts them as 100, 1001, 101 etc. I heard i could simply alter the table to add a…
user2296551
  • 1
0
votes
1 answer

sql server matching field containing "$$" and "%"

One of my column in sql table contain values like $$ADC.ES%32,A How can I match this in my select where clause? Select .... From .... Where ColumnName = '$$ADC.ES%32,A' Thanks
mushtaqck
  • 77
  • 2
  • 6
0
votes
3 answers

oracle sql collation

I have a question about sql. I use jDeveloper and oracle sql developer. I wanna make search case insesitive and I wrote like this: String word = jTextField5.getText(); ResultSet rs = statement.executeQuery("SELECT NAMES, AUTHOR, ID…
newbie
  • 161
  • 2
  • 6
  • 15
0
votes
1 answer

MYSQL Collate in QUERY

Hi I am trying to make search on my web which is looking in DB with CHARACTER SET utf8 COLLATE utf8_slovak_ci Table is also utf8_slovak_ci . In table called knihy (books) I have fields Autor1 Autor2 Autor 3 Autor4 /Author 1 etc./ Here is query…
Geril
  • 159
  • 1
  • 15
0
votes
0 answers

SQL Server: can't collate variables in SELECT-Statement

I have 2 databases (X and Y) on my SQL Server 2008 R2. For some reason the databases and the server have different encodings (SQL_Latin1_general_CP1_CI_AS and Latin1_General_CI_AS) so I'm always facing collate problems when I use temp tables or…
Staeff
  • 4,994
  • 6
  • 34
  • 58
0
votes
2 answers

VB.net SQL Command trying to Collate query

I am trying to add the COLLATE function to a .net SqlCommand. But I am not getting any results. I have tested the logic in Mgmt Studio, where it works, there should be data returned with this SELECT stmt. The query works with the exception of…
htm11h
  • 1,739
  • 8
  • 47
  • 104
0
votes
2 answers

perl libSqliteIcu.so collate icu

The libSqliteIcu works fine in sqlite3 terminal with: sqlite3 ... .load './libSqliteIcu.so' SELECT icu_load_collation('pl_PL', 'POLISH'); SELECT DISTINCT miasto FROM tab ORDER BY miasto COLLATE POLISH; How to code the sequence above into perl?
zeta0
  • 101
  • 3
-1
votes
1 answer

Increment Row Index And Union With Other Tables On Dynamic Dates

Question: I looked at various other examples to increment over rows, but all resulted in the same wrong output. The problem which I encountered was that my code did not successfully increment over rows to build a correct index per new row in the…
d_-
  • 1,391
  • 2
  • 19
  • 37
-1
votes
2 answers

Case sensitive search query with IN clause - SQL Server

I want to do a case sensitive search in SQL Server environment. Whenever I am using separate queries like below, it is working fine: select * from table1 where flag = 'Yes' COLLATE sql_latin1_general_cp1_cs_as; select * from table1 where flag = 'No'…
Leo
  • 5,017
  • 6
  • 32
  • 55
1 2 3
…
10
11