Hello, I have a text field on database, and here the user could enter arabic or english language. When I'm trying to sort, they are not sorted properly. Is there any way to solve this?
Thanks.
Hi Mariana,
If you are sorting using the database, it's a database issue. If you are using an OutSystems cloud environment, contact OutSystems, though if it's a PE I'm not sure they can help you (as multiple users share the database). If it's an on-premise installation, contact your DBA.
Sounds like a Collation issue. You might have to speak with whoever is managing your database, but in the meantime, here's a couple of things you can try, assuming you're using SQL Server:
- check this for a solid primer on how sorting orders are extrapolated from your database/field collation;
- try querying your Entity in an advanced query and specifying a collation like this:
SELECT {ENTITY}.[Field] COLLATE Arabic_CI_AI_KS_WS AS CollatedColumn FROM {ENTITY} ORDER BY 1
SELECT {ENTITY}.[Field] COLLATE
{ENTITY}
Arabic_CI_AI_KS_WS
AS CollatedColumn FROM {ENTITY}
and see if the sorted fields are what you would expect.