> I have run into another probelm with searching on national characters.
> If I search the danish city "Næstved" as
>
> select * from ADRESSES where CITY starting with 'Næs'
>
> I get no rows back. If I search
>
> select * from ADRESSES where CITY containing 'stved'
>
> I get all rows from Næstved.
>
> I use {encoding", "NONE"}, {"charSet", "ISO-8859-1"}
>
> What is the problem?

How is your table defined and how do you insert your data into the table?

Roman