Issue Details (XML | Word | Printable)

Key: CORE-1737
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Adriano dos Santos Fernandes
Reporter: Carlos H. Cantu
Votes: 3
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Setting default collate for a database

Created: 11/Feb/08 10:59 AM   Updated: 23/Feb/11 12:10 PM
Component/s: None
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=ALTER+CHARACTER+SET


 Description  « Hide
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>


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.