Messy characters while loading data into QlikView

[NareshGuntur]

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

Cheers,

Naresh

[rbecher]

Hi Naresh,

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

- Ralf

[MarcoWedel]

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]

Sounds a bit senseless.. 😉

[MarcoWedel]

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]

Hi,

Thanks all for the responses.

Please find my attachment.

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

Cheers

[rbecher]

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..