> I have a problem with using sql select statement with unicode value.
> for example:
> Select * from Table where ID = 1.
> it's work well on unicode data.
> but when i try to find some record using where clause that contain
> a unicode character it never return a result and some time get
> SQLException.
> my query is :
> select * from Table where field = 'some unicode characters';
>
> i use jsp and java bean and firebirdsql jdbc.

- what exception do you get?

- what is your client encoding (value of lc_ctype connection
parameter)?

Thanks!
Roman Rokytskyy