Question : I’m trying to select attribute value from XML column using XPath with a parameter that can be a […]
How To Strip Hebrew Accent Marks
Question : I need a Char Encoding Trick to Strip Hebrew Accent Marks. Sample Before בְּרֵאשִׁ֖ית בָּרָ֣א אֱלֹהִ֑ים אֵ֥ת הַשָּׁמַ֖יִם […]
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 […]
How to import SQL file which has no N prefix
Question : I have a large .sql file in Persian Language. The file is exported from sqlite db browser and […]
What is difference between Arabic_100_CS_AS_KS_WS_SC_UTF8 and Latin1_General_100_CS_AS_KS_WS_SC_UTF8?
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’, […]
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), […]