Hi,
our database contains data of persons with amongst others their namens.
After the user has entered a name of person in the application it generates a
statement like this:
SELECT T_PERSSTAMM.ADELSTITEL,T_PERSSTAMM.NNAME,T_PERSSTAMM.VORNAME ...
where .....
and lower(substring(NNAME,1,4))=lower('Ru�b') order by 2,3
The select with substring is choosed to allow users to shorten the names to
find e.g. all persons whose names start with 'Ru�b'.
In case the given NNAME contains the german letter '�' (and only in this case)
and the statement is sent over JDBC to the databse
the following error message is returned:
[-5016] (at 691): Missing delimiter: )
If the order clause is omitted the statement returns the expected data !
The statements works perfect in SQL studio.
Elke
