Basics about Umlauts
Moderator: Rathinagiri
Basics about Umlauts
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)
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)
- 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
Welcome to HMG Forum.
Can you please give a small sample or screenshot?
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.
South or North HMG is worth.
...the possibilities are endless.
Re: Basics about Umlauts
नमस्ते श्री Rathinagiri,
thank you for your welcome. Here are the screenschoots.
thank you for your welcome. Here are the screenschoots.
Re: Basics about Umlauts
...or look please here: http://www.api-gm.de/HMG.pdf
- 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
Rathi,
I have the same problem with umlauts in german names/cities.
Serge
I have the same problem with umlauts in german names/cities.
Serge
There's nothing you can do that can't be done...
- srvet_claudio
- Posts: 2193
- Joined: Thu Feb 25, 2010 8:43 pm
- Location: Uruguay
- Contact:
Re: Basics about Umlauts
Perhaps it is because the DBF file is in ANSI and the program code is in Unicode.
- 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
Thanks Claudio, this could be the cause. I'll check.
Serge
Serge
There's nothing you can do that can't be done...
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: Basics about Umlauts
more ...
After years since Unicode, we can not expect MS-Excel will recognize and right implement ANSI character sets
Viva HMG Unicoded
After years since Unicode, we can not expect MS-Excel will recognize and right implement ANSI character sets
Viva HMG Unicoded
Viva INTERNATIONAL HMG
Re: Basics about Umlauts
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"
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"
- 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
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
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...