Setting default collate for a database [CORE1737]

[firebird-automations]

Submitted by: @WarmBooter

Is related to QA308

Votes: 3

I remember this being discussed in the past, but seems that a few problems exists and nothing was concluded.

It would be nice to have a way to create a database with a default collation when a default charset was specified. Something like " CREATE DATABASE blblabla CHARSET xxxx USING COLLATE yyyy" or any better syntax (maybe ANSI SQL has something defined for this).

Also, in a talk with Adriano, he proposed another DDL command like:
ALTER CHARACTER SET <X> SET DEFAULT COLLATE <y>

Commits: 77e97a4

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @asfernandes

Wiki Page: http://wiki.firebirdsql.org/wiki/index.php?page=ALTER+CHARACTER+SET

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA308 [ QA308 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test