Thanks Michael and Juan, it works!

Now, just to know, what if I have two tables with different charsets?
There's a way to change the "lc_ctype" on the fly?

And if I have diff charsets in the same query?

Thanks again...

On Fri, 2003-09-12 at 05:06, Firebird-Java@yahoogroups.com wrote:

> Message: 2
> Date: Thu, 11 Sep 2003 15:20:50 +0200
> From: "Michael Hausl" <michael@...>
> Subject: RE: Where to configure Charsets?
>
> Try using "lc_ctype" as the property key instead of "CHARSET".
>
> This should work.
> Michael
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 3
> Date: 11 Sep 2003 15:27:11 +0200
> From: Juan Pedro López Sáez <jpls@...>
> Subject: Re: Where to configure Charsets?
>
> You have to use
>
> prop.setProperty("lc_ctype", "ISO8859_1");
>
> to set the charset.
>
> Best regards,
>
> Juan Pedro Lopez
>