Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: unicode

What is difference between Arabic_100_CS_AS_KS_WS_SC_UTF8 and Latin1_General_100_CS_AS_KS_WS_SC_UTF8?

By adminPosted on January 26, 2023

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

By adminPosted on December 22, 2022

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

By adminPosted on October 20, 2022

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?

By adminPosted on October 5, 2022

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

By adminPosted on September 13, 2022

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?

By adminPosted on April 25, 2022

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?

By adminPosted on February 6, 2022

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?

By adminPosted on January 16, 2022

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?

By adminPosted on December 2, 2021

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

By adminPosted on November 28, 2021

Question : Starting with a varchar(100) column named Password in a table Users with one record in it, after performing […]

  • 1
  • 2
  • 3

Recent Posts

  • You do not have permission [closed]
  • What are your use-cases for HandlerSocket?
  • Sqlite query slow whilst it should be fast
  • Should I normalize a relational database design if I know the data will never be updated?
  • Index not picked up on nullable boolean column
  • Can we protect data form Database Administrator by encrypting the data?
  • Oracle 12c SYSTEM user locked out
  • Max from 2 columns with priority date col then the seq col Oracle
  • MySQL incremental backups per database (not global)
  • Does PostgreSQL/PostGIS use R-Tree or R*-Tree?
  • Implementing a simple ERD in MySQL: is the implementation below 100% compliant with the ERD?
  • Postgres Vacuum in Function
  • How can we improve this PIVOT operation? ( SQL Server 2008 R2 )
  • mongodb restore multiple collections with single command
  • GRANT privileges to table elements
  • Is there any way to perform atomic updates of stored procedures in MySQL?
  • How to Transfer SSMS “Font & Color” settings from one machine to another?
  • SQL Server 2012 Intellisense Support for Extended Events
  • Multi-tenant database
  • Get column names and data types of a query, table or view

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding