Question : I am designing a Postgresql database that contains Chinese characters in certain tables (.e.g login, comments). Most tables […]
Tag: collation
Which collation should I choose for a muiti-language website?
Question : Does a collation have any influence over a query speed? Does the size of a table change depending […]
Sort name by Thai character is not working
Question : I am trying to sort a table by name. The name are in Thai character; >Select name from […]
SQL Server 2008R2 database migration to cloud: case-insensitive collation changed to case-sensitive
Question : Recently felt the fall out (crappy legacy code base) of a database migration by a third party vendor […]
Why is mixing column collations in a single database considered bad?
Question : There are two reasons that prompts me to ask this question: tSQLt The T-SQL testing framework tSQLt considers […]
Why would you index text_pattern_ops on a text column?
Question : Today Seven Databases in Seven Weeks introduced me to per-operator indexes. You can index strings for pattern matching […]
Search for Arabic text ignoring diacritics, alef hamza differences, and kashida in SQL Server and Oracle
Question : Well, I have a table with an Arabic column which may contain variant forms of the same word […]
Best General Purpose Character Set and Collation for MySQL
Question : Currently, whenever I create a new MySQL database, I use utf8mb4 as a character set and utf8mb4_unicode_520_ci for […]
Why doesn’t MySQL coerce the collation to the column-specified, when comparing to a literal?
Question : I have a table with a collation defined on a column: CREATE TEMPORARY TABLE test_table ( utf8_col VARCHAR(255) […]
Why does using Format vs Right to apply padding cause estimated number of rows to dramatically change?
Question : I was working on a query at work, that had a left join like cast(cola as varchar) + […]