Hello,
I have some problems in getting results, if I search for data with a German umlaut like "ä", "ö" or "ü".
In SQL*Plus the following query returns on row:
SQL> SELECT SYSBE.ID AS SYSBE_ID
2 , SYSBE.NACHNAME AS SYSBE_NACHNAME
3 , SYSBE.VORNAME AS SYSBE_VORNAME
4 FROM SYS_BENUTZER SYSBE
5 LEFT JOIN SYS_ABTEILUNGEN SYSAB ON SYSAB.ID = SYSBE.ABTEILUNG_ID
6 WHERE SYSBE.STATUS = 'aktiv'
7 AND ((SYSAB.KUERZEL <> 'SYS') OR (SYSAB.KUERZEL IS NULL))
8 AND SYSBE.ID NOT IN (SELECT PMPD.MITARBEITER_ID
9 FROM PM_PROJEKT_MITARBEITER PMPD
10 WHERE PMPD.PROJEKT_ID = 26 AND
11 PMPD.MITARBEITER_ID = SYSBE.ID)
12 AND (REGEXP_LIKE(SYSBE.NACHNAME, 'hö', 'i')
13 OR REGEXP_LIKE(SYSBE.VORNAME, 'hö', 'i'))
14 ORDER BY SYSBE.NACHNAME, SYSBE.VORNAME;
SYSBE_ID SYSBE_NACHNAME
---------- --------------------------------------------------
SYSBE_VORNAME
--------------------------------------------------
52 Höfling
Alexander
If I execute this from PHP via the oci8.dll no rows will be returned. Yesterday the DBA helped me to trace the query and it looks exactly the same as above.
Can anyone help?
Regards,
Stefan