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?
The syntax you're looking for is here
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.