Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Daryl Joubert: "I am evaluating your PostgreSQL Maestro product for purchase by my company and thus far I am very impressed! I really like the easy, intuitive and productive user interface and feature set. I am also evaluating a number of other products for PostgreSQL database design and maintenence but thus far SQLMaestro stands head and shoulders above the rest".
Andrew Maclean: "I am really quite impressed with the software. You and your people are doing a wonderful job. I actually have spent a while researching PostgreSQL admin/code generators and yours seems to fit our needs nicely. Your interface is beautiful".

More

Add your opinion

Customers
Download Buy

PostgreSQL Maestro online Help

Prev Return to chapter overview Next

Collations

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