QVX Code pages - Qlik Community

etl_tools · ‎2012-01-26

Hello

We are curretly in process of adding support for QVX files to our ETL tools Advanced ETL Processor and Visual Importer ETL.

I am not able to find full list of Code pages supported and SDK documentation is confusing.

Can someone point me to the right direction please

Mike,

rbecher · ‎2012-01-26

Hi Mike,

you can read this from the XML header:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?> // Header Codepage = UTF-8

...

<FieldName>SomeField</FieldName>

...

<CodePage>65001</CodePage> // Data Codepage = UTF-8

In this case the codepage is UTF-8 (65001):

- Ralf

Astrato.io Head of R&D

etl_tools · ‎2012-01-26

Ralph

I uderstand that but I guess QVX support several codepages so we want to find a full list of codepages supported

by QlikVIew

so 65001 is UTF8

Any More?

Mike,

rbecher · ‎2012-01-26

Yea, would be interesting to know..

I would expect that those are also working:

Windows-1252, ISO-8859-1, UTF-16

but haven't tried so far.

Astrato.io Head of R&D

etl_tools · ‎2012-01-26

Character encoding used to write field values in the QVX

data stream. 1200/1201 implies UTF16. Byte order mark

(BOM) is not allowed. BigEndian has no effect on UTF16.

If not set then UTF8 is assumed.

Does it it mean 1200 or 1201 implies UTF16?

Mike,

etl_tools · ‎2012-01-31

Still no reply ...

Meantime we added support for QVX files generation to our ETL software

Note

All data is exported as UTF8 text using row delimiter

This our first release and we will continue working on improoving our software

Mike,

dbSL