> does anyone knows how to insert and select data from unicode field
> in database step by step..??

1. define your database or column as UNICODE_FSS (mandatory).

2. add lc_ctype=UNICODE_FSS property to connection properties. You
might define any encoding that contains your national characters
except NONE. driver will perform translation.

3. use PreparedStatement to store data in database, not Statement.

Should work. If not, please create small program that demostrates the
problem and we will try to find the reason.

Note, if you're using InterClient property is called "charSet" and
you must use Java encoding names (UNICODE_FSS is UTF-8, WIN1252 is
Cp1252, etc.), not InterBase/Firebird ones.

Best regards,
Roman Rokytskyy