hmmm... do you mean that you build SQL statement as static string?
If yes, what is your JVM default encoding? But I doubt that problem
is in your code if this code works with InterClient...

No clue... It should work, at least when I test storing data and
reading them back in WIN1251 encoding...

Regards,
Roman Rokytskyy

--- In Firebird-Java@y..., "yaha301973" <revyakin@u...> wrote:
> Hello!
>
> (Databases with
> default character set WIN1251)
>
> For Jdbc Interclient2.01 driver with
> charSet=Cp1251
>
> select fullname
> from clients
> where fullname like '%win1251_string_value%'
>
> it's OK :-))
>
> For Jdbc Type 4 driver with
> lc_ctype=WIN1251
>
> select fullname
> from clients
> where fullname like '%win1251_string_value%'
>
> it's bad :-((
>
> resultSet of query1 != resultSet of query2
> resultSet of query2 is incorrect and unexpected
>
> Is it my error or type4driver?
>
> ______________
> Yakov Revyakin
> Kyiv, Ukraine
> www.ugpp.com.ua