Top "Collation" questions

Collation refers to a set of rules that determine how data is sorted and compared.

Converting mysql tables from latin1 to utf8

I'm trying to convert some mysql tables from latin1 to utf8. I'm using the following command, which seems to mostly …

mysql utf-8 collation latin1 mysql-error-1062
MySQL treats ÅÄÖ as AAO?

These two querys gives me the exact same result: select * from topics where name='Harligt'; select * from topics where name=…

mysql unicode encoding collation
How to return str from MySQL using mysql.connector?

I'm trying to use MySQL Connector/Python from mysql.com with Python 3. I have tables in UTF-8 coding, and when …

python mysql python-3.x utf-8 collation
Problems with Turkish SQL Collation (Turkish "I")

I'm having problems with our MSSQL database set to any of the Turkish Collations. Becuase of the "Turkish I" problem, …

sql sql-server collation turkish
Is there any way to sort strings in all languages?

I have this code. It sorts correctly in French and Russian. I used Locale.US and it seems to be …

java collation string-comparison
MySQL collation for all languages

I'm currently developing a website that is going to show stuff for almost any language in the world. And I'm …

mysql collation
Unix sort treatment of underscore character

I have two linux machines, on which unix sort seems to behave differently. I believe I've narrowed it down to …

sorting unix environment-variables collation
What's the difference between "VARCHAR BINARY" and "VARBINARY" in MySQL?

I've created the following test table: CREATE TABLE t ( a VARCHAR(32) BINARY, b VARBINARY(32) ); INSERT INTO t (a, b) VALUES ( …

mysql collation binary-data
Humanized or natural number sorting of mixed word-and-number strings

Following up on this question by Sivaram Chintalapudi, I'm interested in whether it's practical in PostgreSQL to do natural - …

sql postgresql sorting collation natural-sort
How do i learn default system encoding of a solaris zone?

In a solaris zone, i want to learn default system charset and collation in the terminal. I searched on google …

character-encoding solaris collation solaris-10