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

Tag: collation

SQL Server: Collation of the resource database

By adminPosted on September 27, 2023

Question : I’m trying to use stopwords so that some words are skipped by the Full-Text Indexer. I can add […]

How to choose a collation for international database?

By adminPosted on September 20, 2023

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?

By adminPosted on September 19, 2023

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?

By adminPosted on September 17, 2023

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

By adminPosted on September 10, 2023

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?

By adminPosted on August 31, 2023

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?

By adminPosted on August 21, 2023

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

By adminPosted on August 21, 2023

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?

By adminPosted on August 20, 2023

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

By adminPosted on August 12, 2023

Question : We are currently having a problem loading arabic into a SQL Server 2008 database. We want to load […]

  • 1
  • 2
  • 3
  • …
  • 24

Recent Posts

  • Installing SQL Server 2014 Enterprise in Windows 7 Ultimate 64 Bit Incompatibility Error
  • CPU Time Slower in SQL Server 2014 than in SQL Server 2008 R2 [closed]
  • Postgres doesn’t use expression index for group by
  • Suggestions for type of DB to use (Elasticsearch vs MongoDB vs Hadoop)
  • Creating Indexes to optimize query
  • Does joining to the same table twice have a predictable performance impact
  • Can we prevent table from update directly but allow update using trigger from another table?
  • Querying ‘random’ Oracle data via openquery in SQL Server returning the same data for multiple runs
  • The implications of lack on indexes on supporting a large production database
  • How to limit work_mem on PostgreSQL
  • Select max(pk) instead of sequence.nextval
  • Query detailing differences between rows for a large amount of data
  • How to combine `delete` and `insert` operations in one statement?
  • Slow SQL Server database on a specific server [duplicate]
  • How to model the relationship between these three tables
  • Error when migrating MySQL 8 to SQL Server 2019
  • multiple MYSQL full text indexing for innodb and memory + disk efficiency
  • Many-To-Many relationship between Students and heights (Is it necessary?)
  • What is the ideal composite index for this query?
  • hosting images on own database or 3rd party

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