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

Tag: collation

Collation conflict when running dynamic sql FOR XML PATH

By adminPosted on February 6, 2023

Question : I am getting the following error message when running the query below: Cannot resolve the collation conflict between […]

How to determine the collation of a table in PostgreSQL?

By adminPosted on January 27, 2023

Question : I want to script a check of the collations used on my tables in PostgreSQL, but googling for […]

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’, […]

Does PostgreSQL support ICU collation’s options and settings?

By adminPosted on January 24, 2023

Question : ICU Specifies different LDML Collation Settings. Some of them seem pretty interesting, especially the ones on case and […]

Using CONVERT TO CHARACTER SET for changing only collation?

By adminPosted on January 11, 2023

Question : I think the answer to this is an obvious yes, but I’m having trouble finding confirmation on it. […]

Case-insensitive collation still comparing case-sensitive

By adminPosted on January 8, 2023

Question : I am currently trying to create a table with a text column which will compare case insensitive by […]

Different collations for different databases [closed]

By adminPosted on January 2, 2023

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

SQL Server 2016 Collation and Internal table Glitch?

By adminPosted on December 30, 2022

Question : My Steps: installed SQL 2016 with collation SQL_Latin1_General_CP850_CI_AS Restored Database to Stage instances with same collation as Database.(original […]

Is worth change databases collation from Latin1_General to Modern spanish, migrating to a new server

By adminPosted on December 27, 2022

Question : We are migrating 3 databases tables from Sql Server 2000 to a new sqlserver 2014. I know that […]

ORDER BY and comparison of mixed strings of letters and numbers

By adminPosted on December 22, 2022

Question : We need to do some reporting on values that are usually mixed strings of numbers and letters that […]

  • 1
  • 2
  • 3
  • …
  • 18

Recent Posts

  • Order of returned rows with IN statement
  • Do not want to allow Queries to take more than x minutes?
  • How would i create a report involving multiple many to many relationships
  • web interface port for oracle 11g
  • Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL
  • How can I check if a user have a quota on tablespace
  • Can alias in SQL Server contain slash?
  • Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
  • Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
  • Sum on distinct and group by
  • Is a join optimized to a where clause at runtime?
  • Simple select is taking too long
  • GROUP BY with subqueries for a Group?
  • SERVERPROPERTY(‘Edition’) AS [Edition]
  • Do MySQL sub-queries essentially use as much overhead as separate queries?
  • select fieldvalues and column-description of a table
  • Secure database access from particular applications
  • How to optimize and estimate DB recovery times?
  • How to make a FULLTEXT search with ORDER BY fast?
  • De-duplicate rows in place vs de-duplicate on transfer

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