> - 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