Question : I’m trying to use stopwords so that some words are skipped by the Full-Text Indexer. I can add […]
Tag: collation
How to choose a collation for international database?
Question : I’m designing a database which will store data in different languages (using UTF-8), so I think the best […]
Operator “~<~" uses varchar_pattern_ops index while normal ORDER BY clause doesn't?
Question : Let’s say I have a table with 1 000 000 records. Structure of table is: create table individual […]
Why do I get incorrect characters when decoding a Base64 string to NVARCHAR in SQL Server?
Question : I’ve been looking at how to decode Base64 with SQL Server and after searching around many solutions online […]
Change SQL Server 2019 instance Collation After installation, and new problem
Question : How to made this problem on SQL Server 2019 Install SQL Server with wrong collation 2month ago Revived […]
Equivalent of utf8_general_ci in Postgres/ICU?
Question : In MySQL there is a collation utf8_general_ci which provides case-insensitive comparisons in a variety of languages. For example, […]
postgresql 12.3 convert existing DB to use case-insensitive collation?
Question : postgresql 12.3 in a container with Alpine Linux 3.10 I would like to convert an existing DB to […]
Cloning a database to another collation
Question : I’m not sure if this is the best way to migrate data to another collation but I’ve done […]
How to choose a collation for international database?
Question : I’m designing a database which will store data in different languages (using UTF-8), so I think the best […]
SQL Server 2008 collation arabic
Question : We are currently having a problem loading arabic into a SQL Server 2008 database. We want to load […]