Basics about Umlauts

Moderator: Rathinagiri

APi
Posts: 6
Joined: Tue Dec 29, 2015 3:34 pm
Location: Germany (born in Austria)

Basics about Umlauts

Post 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)
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Basics about Umlauts

Post by Rathinagiri »

Welcome to HMG Forum.

Can you please give a small sample or screenshot?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
APi
Posts: 6
Joined: Tue Dec 29, 2015 3:34 pm
Location: Germany (born in Austria)

Re: Basics about Umlauts

Post by APi »

नमस्ते श्री Rathinagiri,

thank you for your welcome. Here are the screenschoots.

APi
Posts: 6
Joined: Tue Dec 29, 2015 3:34 pm
Location: Germany (born in Austria)

Re: Basics about Umlauts

Post by APi »

...or look please here: http://www.api-gm.de/HMG.pdf
User avatar
serge_girard
Posts: 3165
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Basics about Umlauts

Post by serge_girard »

Rathi,

I have the same problem with umlauts in german names/cities.

Serge
There's nothing you can do that can't be done...
User avatar
srvet_claudio
Posts: 2193
Joined: Thu Feb 25, 2010 8:43 pm
Location: Uruguay
Contact:

Re: Basics about Umlauts

Post by srvet_claudio »

Perhaps it is because the DBF file is in ANSI and the program code is in Unicode.
Best regards.
Dr. Claudio Soto
(from Uruguay)
http://srvet.blogspot.com
User avatar
serge_girard
Posts: 3165
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Basics about Umlauts

Post by serge_girard »

Thanks Claudio, this could be the cause. I'll check.

Serge
There's nothing you can do that can't be done...
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: Basics about Umlauts

Post by esgici »

more ...

After years since Unicode, we can not expect MS-Excel will recognize and right implement ANSI character sets :?

Viva HMG Unicoded :D ;)
Viva INTERNATIONAL HMG :D
APi
Posts: 6
Joined: Tue Dec 29, 2015 3:34 pm
Location: Germany (born in Austria)

Re: Basics about Umlauts

Post 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"
User avatar
serge_girard
Posts: 3165
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Basics about Umlauts

Post 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
There's nothing you can do that can't be done...
Post Reply