Page 1 of 2
Basics about Umlauts
Posted: Tue Dec 29, 2015 5:36 pm
by APi
Hi, first of all I want to thank you for this forum and for HMG.
I work with HMG 3.4.2 and W7. I have an old (1987) Programm written in Clipper.
When I open a *.dbf from this program with MS-Excel, I can see Umlauts (öäü ÖÄÜ)
When I work with HMG-IDE Unicode 1.0.9, there are all Umlauts stolen.
When I use the sample tutor21.hbp and I edit a name to "Müller" the name looks in Excel "M├╝ller".
Thanks in advance for an answer.
Arnulf W. Pickert (APi)
Re: Basics about Umlauts
Posted: Tue Dec 29, 2015 6:25 pm
by Rathinagiri
Welcome to HMG Forum.
Can you please give a small sample or screenshot?
Re: Basics about Umlauts
Posted: Tue Dec 29, 2015 6:48 pm
by APi
नमस्ते श्री Rathinagiri,
thank you for your welcome. Here are the screenschoots.
Re: Basics about Umlauts
Posted: Tue Dec 29, 2015 6:49 pm
by APi
Re: Basics about Umlauts
Posted: Wed Dec 30, 2015 8:45 am
by serge_girard
Rathi,
I have the same problem with umlauts in german names/cities.
Serge
Re: Basics about Umlauts
Posted: Wed Dec 30, 2015 3:16 pm
by srvet_claudio
Perhaps it is because the DBF file is in ANSI and the program code is in Unicode.
Re: Basics about Umlauts
Posted: Wed Dec 30, 2015 5:30 pm
by serge_girard
Thanks Claudio, this could be the cause. I'll check.
Serge
Re: Basics about Umlauts
Posted: Wed Dec 30, 2015 6:07 pm
by esgici
more ...
After years since Unicode, we can not expect MS-Excel will recognize and right implement ANSI character sets
Viva HMG Unicoded
Re: Basics about Umlauts
Posted: Sun Mar 06, 2016 11:38 am
by APi
I think I solved the problem:
Function Main
SET LANGUAGE TO GERMAN
SET DATE TO GERMAN
SET CODEPAGE TO GERMAN
EXTERNAL HB_CODEPAGE_ES850
REQUEST HB_SETCODEPAGE
HB_SETCODEPAGE ('ES850')
... and in the PSPad-Editor I use as Format "OEM"
Re: Basics about Umlauts
Posted: Sun Mar 06, 2016 1:14 pm
by serge_girard
Arnulf,
Can you please try
REQUEST HB_CODEPAGE_UTF8
(instead of your 6 lines of code) and let me known if it works.
Thx/Serge