Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
JDBC - problem with ß
From: Elke Schmidtke (elke.schmidtkembjs.brandenburg.de)
Date: Thu May 12 2005 - 03:51:57 CDT
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 ...
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.