Question : Starting from SQL Server 2019, it supports UTF-8 as collation. However, according to the following queries: SELECT COLLATIONPROPERTY(‘Arabic_100_CS_AS_KS_WS_SC_UTF8’, […]
Tag: unicode
Remove characters from PostgreSQL database causing encoding errors
Question : I have a PostgreSQL 10 database that uses WIN1252 encoding. One of my columns has values that cause […]
Detect if any values in NVARCHAR columns are actually unicode
Question : I have inherited some SQL Server databases. There is one table (I’ll call “G”), with about 86.7 million […]
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 […]
Mariadb (MySQL) On Windows- problem entering non-ASCII characters in a query
Question : MariaDB: mysql Ver 15.1 Distrib 10.3.8-MariaDB OS: Windows 7 Pro 64 bit I have my server database and […]
Where can I find exact rules of a collation?
Question : Is there any documentation anywhere for the exact sorting/equality rules defined by a collation in Windows (SQL Server), […]
Why isn’t Unicode character REPLACEd in some cases?
Question : Running this results in “test”, as expected: SELECT REPLACE(NCHAR(1234), NCHAR(1234), N’test’); However, running this results in “aӒa”, which […]
Why does searching for LIKE N’%�%’ match any Unicode character and = N’�’ match many?
Question : DECLARE @T TABLE( Col NCHAR(1)); INSERT INTO @T VALUES (N’A’), (N’B’), (N’C’), (N’Ƕ’), (N’Ƿ’), (N’Ǹ’); SELECT * FROM […]
Why does Oracle use a different byte length than java for the supplementary unicode character chipmunk?
Question : I have java code trimming a UTF-8 string to the size of my Oracle (11.2.0.4.0) column which ends […]
Detecting whether a varchar value is already encrypted by EncryptByPassPhrase() in SQL Server
Question : Starting with a varchar(100) column named Password in a table Users with one record in it, after performing […]