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.

Examples:

select ...
...
order by mycol COLLATE PT_BR
^^^^^^^^^^^^^


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



HTH


Regards

Stefan

> 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
www.destructor.de/firebird