topic Re: Messy characters while loading data into QlikView in QlikView

Messy characters while loading data into QlikView

NareshGuntur — Fri, 20 Jun 2014 11:04:12 GMT

While reading particular fields, I am getting messy characters(? 州方天电脑网络有 ?公 ?).

Cheers,

Naresh

rbecher — Fri, 20 Jun 2014 11:06:03 GMT

Hi Naresh,

the cause could be a wrong or mixed encoding, or an encryption. Could you provide more details?

- Ralf

MarcoWedel — Fri, 20 Jun 2014 23:24:51 GMT

Hi Naresh,

google translates your messy characters as:

"? State party day computer networks have? Public?"

Maybe this is valid content of your data sources after all?

regards

Marco

rbecher — Sat, 21 Jun 2014 09:05:43 GMT

Sounds a bit senseless.. 😉

MarcoWedel — Tue, 24 Jun 2014 19:58:01 GMT

Without the question marks:

"State parties have a fair day computer networks"

Maybe any chinese speaking community member can tell if this makes any sense?

Thanks

Regards

Marco

NareshGuntur — Wed, 02 Jul 2014 07:23:31 GMT

Hi,

Thanks all for the responses.

Please find my attachment.

FYI, those are not Chinese name... normal English words.

Cheers

rbecher — Wed, 02 Jul 2014 08:12:15 GMT

You have mutiple byte order marks in the data. You will see it with a hex editor: EF BF BF

Wikipedia:

The byte order mark (BOM) is a Unicode character used to signal the endianness (byte order) of a text file or stream.

I don't know yet how to fix but you should probably talk to the owner of the data..