Questions tagged [collation]
A collation is a set of rules that determine how data is sorted and compared for comparing characters in a character set.
336
questions
3
votes
1
answer
2k
views
Dutch characters in DB2 problem
Ok, first of all, I have really limited knowledge about databases.
Problem that I have is next: I inserted few rows with data that contains Dutch characters, such as names of different countries. ...
13
votes
2
answers
20k
views
Why are non-digits LIKE [0-9]?
My server's default collation is Latin1_General_CI_AS, as determined by this query:
SELECT SERVERPROPERTY('Collation') AS Collation;
I was surprised to discover that with this collation I can match ...
- 2,298
0
votes
1
answer
1k
views
Server default collation change or not change
The default collation of our new server is SQL_Latin1_General_CP1_CI_AS. However the collation of the other databases which are used as the source to migrate data into the target databases on this ...
- 3,674
0
votes
2
answers
7k
views
How can I change collation for all tables and columns in MySQL database?
I have a problem with MySQL collation. It turns out that MySQL uses latin1_swedish_ci by default. Collation setup step has been missed on MySQL database instantiation for some reason. Thus, ...
- 111
1
vote
2
answers
10k
views
Correct Code Page or Collation in SQL Server for Portuguese characters
I'm inserting data (Bulk insert and merge update) for a Portuguese data source (CSV files) into my database. Although the DB collation is Latin1-General, case-insensitive, accent-sensitive, kanatype-...
- 229
7
votes
1
answer
5k
views
sql_slovak_cp1250_ci_as vs Slovak_CI_AS
Can someone explain to me what is the difference between collation sql_slovak_cp1250_ci_as vs Slovak_CI_AS?
I have a db set to sql_slovak_cp1250_ci_as and shared hosting supports only Slovak_CI_AS. ...
- 234
1
vote
1
answer
804
views
MySQL collate error occurs when sent by PHP app but does not occur in phpMyAdmin
I have a query that uses:
t3.`value` LIKE "%someval%" COLLATE utf8_general_ci
I load the page in my browser and get this error printed to the screen:
COLLATION 'utf8_general_ci' is not valid for ...
- 1,220
34
votes
2
answers
43k
views
How to determine the collation of a table in PostgreSQL?
I want to script a check of the collations used on my tables in PostgreSQL, but googling for Postgresql detect collation is not working well for me, and the documentation is not making this an easy ...
- 1,162
5
votes
1
answer
7k
views
SQL Server: Collation of the resource database
I'm trying to use stopwords so that some words are skipped by the Full-Text Indexer. I can add those stopwords in the table sys.fulltext_stopwords.
When trying to get a list of stopwords and system-...
1
vote
1
answer
216
views
What would make a MySQL database create tables in a different collation other than its default?
I am adding tables to a Wordpress database on my localhost and it is changing my collation from utf8_general_ci to latin1_swedish_ci. I'm kinda stumped because I'm not familiar with working directly ...
2
votes
2
answers
13k
views
SQL Server 2012 : how to add missing collation
When we run:
ALTER DATABASE abc COLLATE Latin1_General_CP1_CI_AS ;
GO
we receive:
Msg 448, Level 16, State 3, Line 1
Invalid collation 'Latin1_General_CP1_CI_AS'.
How can we add the missing ...
- 21
9
votes
1
answer
29k
views
MySQL: Illegal mix of collations
I've tried using a stored procedure to create indices, and got the following error:
ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) and
(utf8_unicode_ci,...
- 11.1k
5
votes
2
answers
7k
views
Why not use SQL_Latin1_General_CI_AS for a global system?
What would be some really good reasons to not use the SQL_Latin1_General_CI_AS collation on a system which handles English, German, Japanese, and Chinese data?
I'm having a really hard time finding ...
- 203
5
votes
1
answer
1k
views
How do I resolve Postgresql error, 'no collation was derived for column "foo" with collatable type citext'?
Just recently I upgraded from Postgresql 8.4.11 to 9.1.3. I used pg_dump in the process. Now I'm getting an error:
ERROR: no collation was derived for column "vin" with collatable type citext
...
- 59.6k
1
vote
1
answer
1k
views
Changing collation type database-wide in MySQL
How do I retroactively update the collation type database wide without dropping and recreating it?
I accidentally created a database without specifying UTF8 as the default collation type. I then went ...
- 1,176
2
votes
1
answer
518
views
MySQL Character set and Collation Issue.?
I Have a table when i select from the table i got the invalid data as
mysql> select budgetID,StartDate,modifiedBy from Table_name order by budgetID desc limit 10;
+----------+---------------------+...
- 9,439
11
votes
3
answers
11k
views
Treating certain Arabic characters as identical
In Arabic we have characters like ا (alef) and أ (alef with hamza).
Users write them interchangeably and we want to search them interchangeably. SQL Server treats them as separate characters. How ...
- 213
1
vote
1
answer
448
views
Design SQL Server 2008 new install ... which collation?
A customer has a SQL Server 2005 instance, collation SQL_Latin1_General_CP1_CI_AS, with 8 databases ... for a new application, we have been asked to install a SQL Server 2008 with collation ...
Francesco Doni
8
votes
3
answers
36k
views
SQL Server Collation for Arabic, Hebrew, English and French
I have new SQL Server database which need to have support in 3 different languages.
What character sets and collations do I need to choose if I want my database to support the following:
Hebrew
...
baba-dev
3
votes
2
answers
3k
views
Installed SQL Server 2000 with wrong collation.. how to correct for entire server instance?
I installed SQL 2000 Developer (yes, old, don't ask) on my laptop ... with the wrong collation. Oops!
It's showing Latin1_General_CI_AS, but it turns out I need to use SQL_Latin1_General_CP1_CI_AS ...
- 33
0
votes
1
answer
1k
views
SQL Server collation mismatch
I have database server with collation: SQL_Latin1_General_CP1_CI_AS
I got database backup file which collation is: Latin1_General_CI_AS
When I'm restoring this database and executing some SQL, I'm ...
Sergejs
2
votes
1
answer
216
views
Why cp1256 collation is not 1 byte in MySQL?
I've read an article that cp1256 collation takes 1 byte for Arabic characters, but when I created an index on the column that was cp1256 with type of varchar(900), only 767 characters picked up for ...
- 3,586
5
votes
1
answer
9k
views
What's the differences between utf8_general_ci and utf8_unicode_ci and utf8_binary collation in MySQL?
I'm can't find the documentation of MySQL on this topic. Anyone can give some explanations please?
- 2,522
19
votes
4
answers
85k
views
SQL Server 2005/2008 UTF-8 Collation/Charset
I can't find option(s) directly to set UTF-8 rellated Collations/Charsets in SQL Server 2005/2008, same as is possible to set in another SQL engines, but in SQL Server 2005/2008 are there only Latin ...
- 595
6
votes
1
answer
6k
views
Unicode support of PostgreSQL and its performance
How is the Unicode support of PostgreSQL?
If I want to save Unicode data does it have to go through the conversion process while storing and retrieving? If yes then what is the performance of such ...
- 1,923
3
votes
2
answers
4k
views
Multiple charsets and Collations for a Multinational Database
After decades of business speaking with companies that adhere to the general Latin1 Collation, my company is facing the issue of storing information in a different charset and collation: Greek.
So, it'...
- 133
2
votes
1
answer
6k
views
SQL Server 2005 collation issue during installation
Every time I try to install SQL Server 2005 on to a Windows 7 machine it installs properly but the collation installed is sql_latin1_general_as instead of sql_latin1_general_cp1_ci_as. I have read ...
- 123
2
votes
2
answers
9k
views
SQL Server 2008 collation arabic
We are currently having a problem loading arabic into a SQL Server 2008 database.
We want to load
بِسْمِ اللَّهِ الرَّحْمَٰنِ الرَّحِيمِ
but in the database it changes to
بِسْمِ اللَّهِ الرَّحْمَ?...
- 23
5
votes
1
answer
16k
views
Setting default charset/collation for MySQL database
I have a MySQL DB that used to be latin1, and I changed all the columns in all the tables to be utf8. However, I evidently didn't do all I had to do, because I just found that I have a crazy mixture ...
Daniel Magliola
7
votes
1
answer
18k
views
Invalid default value for DateTime when changing to utf8_general_ci
I'm trying to run a script to modify a database, this query
ALTER TABLE cmContentVersion CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
gives this error
ERROR 1067 (42000) at line 68: ...
- 1,442
15
votes
4
answers
4k
views
Is there a collation to sort the following strings in the following order 1,2,3,6,10,10A,10B,11?
I have a database with a VARCHAR column that contains integers of varying length. I want to sort them so 10 comes after 9, not 1, and 70A comes after 70. I was able do this with PATINDEX(), a CTE, and ...
- 2,667
3
votes
1
answer
1k
views
Casesensitive vs. Caseinsensitive Collatesequences?
I just started working with the SQLite database places.sqlite.
Fact is that this database uses case sensitive collate sequences making writing queries as funny as in Oracle.
I want to know, are ...
- 12k
7
votes
1
answer
882
views
Dependant T-SQL comparison collation
Is there any way to set the collation for a string comparison based on an independent variable or column value? Something akin to
SELECT COL1, col2
FROM [TABLE]
WHERE COL3 LIKE '%string%'
...
- 173
4
votes
2
answers
850
views
How can I extract a lessequal char from SQL_Latin1_General_CP1_CI_AS?
When I create a table like this
create table char_test(
item varchar(10) collate SQL_Latin1_General_CP1_CI_AS
)
go
I can store varchars containing ≥
insert into char_test values ('≥');
When I ...
- 12k
28
votes
4
answers
69k
views
How to change SQL Server collation
How could I change the SQL Server 2008 R2 Express Default Collation for the whole server and a particular database?
Is there a way to do it using visual interface of SQL Server Management Studio? In ...
- 1,525
25
votes
3
answers
5k
views
Which collation should I choose for a muiti-language website?
Does a collation have any influence over a query speed? Does the size of a table change depending of the collation?
If I want to build a website that must support all possible languages (lets take ...
- 3,323