Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Shafiq Far: "Just wanted to let you know that I think the SQL Maestro for Postgres is excellent. We've tried a variety over the past few years and none are even close to yours. Well done".
Iwan Kelaiah: "SQL Maestro products (Postgresql) have saved me a lot of time in designing, managing and generating reports and front-ends of Postgresql databases. Keep up the great work and thank you for such great products.".


Add your opinion

PostgreSQL Maestro online Help

Prev Return to chapter overview Next


The collation feature allows specifying the sort order and character classification behavior of data per-column, or even per-operation. PostgreSQL allows to define a new collation using the specified operating system locale settings, or by copying an existing collation. To be able to create a collation, you must have CREATE privilege on the destination schema.

To create a new collation, set the specified operating system locale for the LC_COLLATE locale category, to be used to control the sort order. But it is rarely necessary in practice to have an LC_CTYPE locale category setting that is different from LC_COLLATE, so it is more convenient to collect these under one concept than to create another infrastructure for setting LC_CTYPE per expression. A collation is tied to a character set encoding. The same collation name may exist for different encodings.


To use a collation, specify it at the Field Editor or on a domain creation.



Prev Return to chapter overview Next