topic Re: Why Qlik does not recognize latam symbols from database table record in App Development

Why Qlik does not recognize latam symbols from database table record

jprimera — Tue, 31 Jan 2023 20:07:29 GMT

First there is a Stage app that extract the table from the database and store it as QVD file.

Then Other app does some data transformation from that QVD.

The problem is this:

When I query the table from SQLServer the data comes this way: 'DEPÓSITOS'

When i try to read the QVD the same record retrives me the record this way: 'DEPËSITOS'

What could be the problem... Is there any setting that im missing in the script at the Main Sheet?

Re: Why Qlik does not recognize latam symbols from database table record

marcus_sommer — Fri, 02 Dec 2022 09:54:56 GMT

This may be related to the used charset (it's a configurable setting within some driver) or to the applied collation which is an interpretation setting within Qlik, see: Alphabetical sort order is not correct in local la... - Qlik Community - 1712534

- Marcus

Re: Why Qlik does not recognize latam symbols from database table record

jprimera — Sat, 03 Dec 2022 02:43:25 GMT

Hi Marcus, thanks for your advice... do you know wich is the specific CollationLocale for Spanish? I've tried 'es-ES' but didn't worked.

-Jesus

Re: Why Qlik does not recognize latam symbols from database table record

marcus_sommer — Sat, 03 Dec 2022 09:55:14 GMT

Unfortunately I don't know if your setting is the right one for Spanish and I couldn't find any overview which language-country settings are supported.

But I assume that your value is probably the correct one. Before going further in this direction I suggest to extract the relevant chars to ensure that they are already properly loaded from the database. Maybe something like the following would be helpful:

load *, mid(YourField, iterno(), 1) as Char,
ord(mid(YourField, iterno(), 1)) as CharIndex,
iterno() as IterNo, rowno() as RowNo
while iterno() <= Len;
load *, recno() as RecNo, len(YourField) as Len;
sql select YourField from YourDataBase;

- Marcus