topic Re: How can I use include files saved in UTF8 in QlikView

How can I use include files saved in UTF8

vadimtsushko — Sat, 06 Apr 2013 08:12:05 GMT

I keep all my load scripting in external qvs files. Typically my ETL QVW file contains only one line of code with (include=) command.

In development stage I satisfied with this configuration.

One annoying detail is that I cannot configure locale for such "include files".

My load scripts contain many Russian names for fields and so on. Load scripts (qvs files) saved with ANSI win1251 codepage run successfully with include statement.

But scripts saved in UTF8 does not run properly.

I think it is related to the fact that I'm on Windows with Russian locale (win1251) on my desktop and on server.

In deployment phase - IT staff on side of client frequently prefer to use windows servers with english locale. So currently deployment is complicated for me.

I would be happy always to keep all my scripts in utf8 (as rest of resource files used in project).

Maybe somewhere there is parameter for include files encoding?

Re: How can I use include files saved in UTF8

vadimtsushko — Tue, 04 Feb 2014 14:40:20 GMT

Well, after nine months I've found a solution.

QlikView works corrently with UTF-8 encoded files if they have BOM header.

So for example in Sublime text you may choose menu item File -> Save with encoding -> UTF-8 with BOM

Re: How can I use include files saved in UTF8

simeonlukich — Mon, 26 Aug 2019 22:29:57 GMT

Thanks for coming back to reply to your own comment this saved my bacon.

Re: How can I use include files saved in UTF8

kkmoraes — Sun, 02 Jan 2022 14:55:43 GMT

Thanks!
I had the same problem and your solution worked for me too!