Lookup for text with sami characters returns no results
Posted: Wed 25 Feb 2015 07:17
Hi,
We are using dotConnect for Oracle, version 8.4.333. Our Oracla database contains some data with Northern Sami national characters (columns are defined as NVARCHAR2). Here's the example of the text: "Bearráigeahččojođiheaddji".
If we try to lookup up a record with such text using dotConnect (with Entity Framework or directly, it doesn't matter), the search returns no results. I tested the application with Entity Framework Profiler, and the statement is generated correctly:
If I execute this statement using Oracle client tools, I get the correct result, so apparently both statement generation and statement execution by Oracle works correct. But if I execute it from C# code using Devart.Data.Oracle.dll, no results are returned. What can go wrong?
We are using dotConnect for Oracle, version 8.4.333. Our Oracla database contains some data with Northern Sami national characters (columns are defined as NVARCHAR2). Here's the example of the text: "Bearráigeahččojođiheaddji".
If we try to lookup up a record with such text using dotConnect (with Entity Framework or directly, it doesn't matter), the search returns no results. I tested the application with Entity Framework Profiler, and the statement is generated correctly:
Code: Select all
SELECT "top".ROLE_ID,
"top".ROLE,
"top".PURPOSE,
"top".REFERENCE,
"top".LINK,
"top".LABEL,
"top".RESTRICTION,
"top".CREATED,
"top".CHANGED
FROM (SELECT "Extent1".ROLE_ID,
"Extent1".ROLE,
"Extent1".PURPOSE,
"Extent1".REFERENCE,
"Extent1".LINK,
"Extent1".LABEL,
"Extent1".RESTRICTION,
"Extent1".CREATED,
"Extent1".CHANGED
FROM ROLES "Extent1"
WHERE (LOWER("Extent1".ROLE)) = N'bearráigeahččojođiheaddji'
ORDER BY "Extent1".ROLE_ID ASC) "top"
WHERE ROWNUM <= 1