--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy
<rrokytskyy@y...>" <rrokytskyy@y...> wrote:

> > - I've check the database and column encoding, it was set to
> > UNICODE_FSS. Should I use prepare statements to execute the query
> > instead of statement?
>
> This should work. Can you create a test case that reproduces this
> problem?
>
> > - Could you show me an example of using or perform the testing

for

> > this case? i often test this case in web application using jsp

page.

>
> Test what? There is a test case in CVS (client-
> java/src/test/org/firebirdsql/jdbc/TestFBEncodings.java) that
> performs various encoding testings.
>
> > - on jsp page I add the syntax like this :
> > <%@ page contentType="text/html; charset=UTF-8"%> is it correct
> > for this case?
>
> Sorry, I do not know. Try asking in some JSP forum.
>
> > - about casting into OCTETS, could you show me an example of this?
>
> SELECT CAST(my_char_col AS CHAR(100) CHARACTER SET OCTETS) FROM
> my_table
>
> But this is not correct way of doing things.
>
> Best regards,
> Roman Rokytskyy

Ok thanks. I've done the test like this:
SELECT field1 FROM my_table WHERE field1 =
UNICODE_FSS'some_unicode_charset';
and it work well.

Thanks a lot for your help.

Best regards,
wayan