Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to find out how to create CI firebird embedded database. I've found (here) that there are some character sets each of them has one or many collations. So, UTF8 has UCS_BASIC, UNICODE and UNICODE_CI collations. From documentation I can set any collation for any column during table creation. My question is: Is it possible to set collation on whole database? Or I have to impose collation on all columns?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

The syntax you're looking for is here

CREATE {DATABASE | SCHEMA} ... [PAGE_SIZE [=] size] ...
[DEFAULT CHARACTER SET charset [COLLATION collation]] ...
[DIFFERENCE FILE 'filepath']

size ::= 4096 | 8192 | 16384

Also check out this page and this link from it specifically about case insensitive searches and collations on columns.

The good news is that you can set it both by database and column.

Also, check this out - you can also use "shadow" columns if you can't get exactly what you want "out of the box" - i.e. UPPER() function.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.