Subject Re: [firebird-support] How to install Firebird with a different Collation
Author Stefan Heymann
Hi Jorge,

there's one more thing you could try:

You don't apply a COLLATION to your columns, instead you apply the
COLLATION everytime you really *need* it. This should also work with
your black-box-package.


select ...
order by mycol COLLATE PT_BR

select ...
upper (mycol COLLATE PT_BR) = upper (:userentry COLLATE PT_BR)
^^^^^^^^^^^^^ ^^^^^^^^^^^^^




> Hi.
> I need to install FB but the PT_BR charset does not appears at create
> table time. How I can state that the database uses this collation in
> all the tables? I can not use a modificator as create table charset
> ISO8859_1 collation PT_BR, because I'm using a black-boxed table
> create and upgrade package, so I need that the database uses this
> collation at once on every table that is created inside it.
> Thanks
> Jorge

Stefan Heymann