Hello Elke, 1) Is the statement sent as prepared or non-prepared statement (i.e. is 'Ru�b' sent as parameter or is it a literal? (That may be the difference between SQL Studio (no parameters) and JDBC Application (parameters))
2) Is the type of the columns CHAR ASCII or CHAR UNICODE? 3) Is the JDBC connect property unicode set to yes? (in case of use of Unicode at all) 4) And last, which version of JDBC (java -jar sapdbc.jar -V) and the database you are using? Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Elke Schmidtke [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 12, 2005 10:52 AM > To: [email protected] > Subject: JDBC - problem with � > > 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 > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
