[#CORE-1803] Default COLLATE for CREATE DATABASE statement

Firebird Core

Default COLLATE for CREATE DATABASE statement

Created: 25/Mar/08 07:40 AM Updated: 23/Feb/11 12:18 PM

Component/s:

Charsets/Collation

Affects Version/s:

None

Fix Version/s:

2.5 Alpha 1

Time Tracking:

Not Specified

Issue Links:

Relate

This issue is related to:

QA-312 Test for CORE-1803

Planning Status:	Unspecified
Wiki Page:	http://wiki.firebirdsql.org/wiki/index.php?page=CREATE+DATABASE

Description

« Hide

Allow specify default COLLATION for newly created databases, like default CHARACTER SET

CREATE DATABASE ...
  [DEFAULT CHARACTER SET charset]
  [DEFAULT COLLATION collation]

-or-

CREATE DATABASE ...
  [DEFAULT CHARACTER SET charset [COLLATE collation]]

(MS SQL and MySQL supports similar functionality)

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Adriano dos Santos Fernandes added a comment - 25/Mar/08 12:00 PM

I prefer ~~CORE-1737~~, since it better integrate with RDB$COLLATIONS and connection character sets usage.

[ Permalink | « Hide ]

lacak added a comment - 28/Mar/08 04:26 AM

I see advantages of

CREATE DATABASE ...
[DEFAULT CHARACTER SET charset [COLLATE collation]]

in:

1. Similar to others RDBMS
2. Specify at one place (or time) charset and collation per Database, using syntax like to per Column (SQL stand. ) syntax
3. More intuitive ;-) and simple

[ Permalink | « Hide ]

Dmitry Yemanov added a comment - 28/Mar/08 04:48 AM

I'd vote for both CREATE DATABASE extension and ALTER CHARACTER SET :-)