Issue Details (XML | Word | Printable)

Key: CORE-1803
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Adriano dos Santos Fernandes
Reporter: lacak
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
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
 

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: Ascending order - Click to sort in descending order
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.

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

Dmitry Yemanov added a comment - 28/Mar/08 04:48 AM
I'd vote for both CREATE DATABASE extension and ALTER CHARACTER SET :-)