My query does not return anything when my query contains accents on the WHERE clause
The accents are the cause of the problem and I don’t know how to fix it.
I think that the encoding in UTF8 is not done, and the ORACLE UNISTR(”) method does not work.
The 2 queries return a result in ORACLE SQL DEVELOPER
This query works :
$database->Parse("SELECT
ID_WORKSPACE_USERS,
LOGIN_WORKSPACE_USERS,
FONCTION_WORKSPACE_USERS
FROM WORKSPACE_USERS
WHERE FONCTION_WORKSPACE_USERS = UNISTR('Job 1')"
);
This query does not work (I don’t have any extra space in my database) :
$database->Parse("SELECT
ID_WORKSPACE_USERS,
LOGIN_WORKSPACE_USERS,
FONCTION_WORKSPACE_USERS
FROM WORKSPACE_USERS
WHERE FONCTION_WORKSPACE_USERS = UNISTR('Job é')"
);