Specifics digits

[#1]

Hi all,

In my DW, I have , for example, a name of town with 'ç'.When I load my data in QV, this character is modify by a '+'.

What's the procedure to keep my data with the original format?Should I manipulate directly with the language of QV or directly in the requests to load tables into QV?

Thanks for your help

Mk

[MK_QSL]

Try Text(YourFieldName) as YourFieldName

[Gysbert_Wassenaar]

If you're loading from a text file (.csv, .txt, etc) then you can specify the codepage of the text file.

LOAD * FROM a.txt (codepage is 10000, txt, delimiter is ',' , no labels)

You'll have to figure out what codepage you need yourself.

[ashwanin]

Gysbert is correct, you have to focus on code page and also on Delimiter while loading the file.