Top "Collate" questions

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.

How to use the COLLATE in a JOIN in SQL Server?

I´m trying to join two tables but I get this error: Msg 468, Level 16, State 9, Line 8 Cannot resolve the collation …

sql-server join collate
Change collations of all columns of all tables in SQL Server

I imported a database with some data to compare with another database. The target database has collation Latin1_General_CI_…

sql-server collate
SQLite Query in non case sensitive alphabetical order

All I want to do is grab the stuff in alphabetical order and ignore the capital letters. db.rawQuery("SELECT " + …

android sql sqlite sql-order-by collate
How do I perform a case-sensitive search using LIKE?

I'm trying to find records that contain a string of 6 or more alpha-numeric characters in uppercase. Some examples: PENDING 3RDPARTY …

sql-server-2008 pattern-matching sql-like collate
Correct way to set collation in temporary table column TSQL

I have a temporary table which gets data inserted using bulk insert. However, when I want to update data from …

sql sql-server collate
normalizing accented characters in MySQL queries

I'd like to be able to do queries that normalize accented characters, so that for example: é, è, and ê are all treated …

sql mysql utf-8 diacritics collate
Use Collate in CONCAT

I was trying to concatonate 2 columns with a whitespace in between and got a collation error: SELECT DISTINCT p.PERSON_…

sql-server sql-server-2012 concat collate
Using COLLATE in Android SQLite - Locales is ignored in LIKE statement

When creating my SQLite database in Android I set the database locale - db.setLocale(new Locale("cz_CZ")). This …

android database sqlite locale collate
Collate declared SQL variable

I've been looking at this code, reproduced below, that looks for non-ASCII characters... select line, patindex('%[^ !-~]%' COLLATE …

sql sql-server tsql collate
SQL Server turkish character situation

I am having a Turkish Character problem in ASP.NET and SQL Server. I have searchbox in asp.net and …

sql sql-server collate sql-server-collation