>I read from a google search that in order to make Firebird case
>insensitive one must use the unicode coallation.
>I am however confused. I come from a SQL Server background and
>know that the default installation of SQL Server is case insensitive.
>A friend of mine says he always uses character set "none" with Firebird.
>Can you combine character set none with coallation unicode?
>What's the difference between a coallation and a character set in
>database terms? I see one can also specify the charset in the odbc dsn.

Take a look at http://www.destructor.de/firebird/charsets.htm, Stefan knows a lot about character sets and has written a few interesting articles (including the link to case insensitive searches that you'll find in the above article).

Avoid character set NONE unless you have good reasons for using it, that character set may give less errors, but that's just because Firebird just stores and doesn't try to interpret the content of any field.

HTH,
Set