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

Tag: locales

postgres: do I really need to use Collate and Ctype when restoring database?

By adminPosted on October 23, 2021

Question : Need to import in Linux a Windows postgres exported database. In windows it’s listed as follows: Name | […]

PostgreSQL: difference between collations ‘C’ and ‘C.UTF-8’

By adminPosted on October 11, 2021June 30, 2022

Question : In PostgreSQL, what is the difference between collations C and C.UTF-8? Both show up in rows of pg_collation. […]

Recent Posts

  • Batch Delete with checkpoint still causes log growth
  • Database design – People and Organisations
  • I noticed that my MySQL slave’s DB size is smaller than the Master’s DB
  • Double Concurrent Restore from one backup for 3 node AG?
  • Open source tools for Oracle schema compares [closed]
  • How to pass a table of values to a stored procedure from SSIS?
  • MySQL Community Edition Capacity
  • Indexed view not being used – SQL Server [duplicate]
  • Aurora PostgreSQL CPU usage stuck at 100% for 8 hours
  • User Does not have permission to alter database, the database does not exist, or the database is not in a state that allows access checks SQL server [closed]
  • Chat/conversation history, entity relationship diagram
  • Optimize MySQL Query with multiple subqueries
  • Create SQL Script Repository [closed]
  • Get the id_user_app if not exists in id_user_rq
  • Equivalent Linux commands for Windows ones to create user and database
  • How do I find the least optimised query?
  • Why is MariaDB 10 refusing to use my index on a date field?
  • Changing the initial size of log files
  • Mongo replication lag slowly increasing
  • count for missing values in group by

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