Question : I have a table that stores string from a user and is displayed in a web form. But […]
Tag: utf-8
Querying non-ASCII rows from Postgres
Question : Does [:ascii:] class work in Postgres at all? It is not listed in their help, however I see […]
mysqldump collation issues
Question : I have tried my hand at building a shell script to backup our wordpress database using tar balls […]
Having charset “utf8mb4” – does it mean every character takes 4 bytes, or only those that need 4 bytes?
Question : I have a VARCHAR(80) utf8mb4 column, and I’m testing adding some ASCII & Emoji characters, and use LENGTH() […]
Arabic language search in codeigniter error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
Question : Arabic language search in codeigniter error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) In English language search […]
What is the difference between different utf8mb4 binary collations?
Question : What is the difference between utf8mb4_0900_bin vs utf8mb4_bin binary collations? Answer : There are three differences as far […]
Arabic language search in codeigniter error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
Question : Arabic language search in codeigniter error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) In English language search […]
Can’t insert arabic text into mysql database using mysql prompt
Question : I had a local table with arabic values.when exported i got the following query. DROP TABLE IF EXISTS […]
How to convert mysql database charset to utf-8
Question : I have a vb forum with a huge amount of data I need a way to convert this […]
Is there some function in PostgreSQL to simply check if the input string is valid UTF-8 according to PG?
Question : For several years now, I’ve been hunting this extremely quick-footed little bug which knows every hiding place in […]