Multilingual dbf ?

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
quartz565
Posts: 671
Joined: Mon Oct 01, 2012 12:37 pm
Location: Thessaloniki, Greece
Contact:

Multilingual dbf ?

Post by quartz565 »

Hi all!
It is possible to put different languages in a dbf file :?: (eg Russian, German, Greek, Spanish, etc.)

Nikos
Best Regards,
Nikos.

os: Windows Server 2019 - 64
User avatar
AUGE_OHR
Posts: 2108
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

Re: Multilingual dbf ?

Post by AUGE_OHR »

hi,

i "think" YES ... if you use UNICODE to display String.
while OEM (NTX) use Codepage i recommend to use FoxPro compatible DBF.

but still some Problem left e.g. Nation "Date-String" which need different PICTURE to validate.
have fun
Jimmy
User avatar
mustafa
Posts: 1175
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Contact:

Re: Multilingual dbf ?

Post by mustafa »

Hi Nicos
See if this sample may interest you?

Regards
Mustafa
Attachments
screenshot.jpg
screenshot.jpg (34.88 KiB) Viewed 2399 times
Sample.zip
(10.89 KiB) Downloaded 179 times
User avatar
quartz565
Posts: 671
Joined: Mon Oct 01, 2012 12:37 pm
Location: Thessaloniki, Greece
Contact:

Re: Multilingual dbf ?

Post by quartz565 »

Thanks Jimmy, Mustafa!
Yes Mustafa that's it ! thank you !
Do you know any dbf editor who is unicode? But to show all the languages together in the table? (as in grig)
i have total commader but it can show a language at a time... :(
Best Regards,
Nikos.

os: Windows Server 2019 - 64
User avatar
quartz565
Posts: 671
Joined: Mon Oct 01, 2012 12:37 pm
Location: Thessaloniki, Greece
Contact:

Re: Multilingual dbf ?

Post by quartz565 »

The same dbf with With LibreOffice - calc
Attachments
FromLibreCalc.png
FromLibreCalc.png (18.51 KiB) Viewed 2268 times
Last edited by quartz565 on Tue Apr 28, 2020 11:50 am, edited 1 time in total.
Best Regards,
Nikos.

os: Windows Server 2019 - 64
User avatar
serge_girard
Posts: 3364
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Multilingual dbf ?

Post by serge_girard »

Mustafa,

You sample compiled well but gives this as result:
MUSTAFA.jpg
MUSTAFA.jpg (34.29 KiB) Viewed 2312 times
Forgot something?

Serge
There's nothing you can do that can't be done...
User avatar
mustafa
Posts: 1175
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Contact:

Re: Multilingual dbf ?

Post by mustafa »

Hi Serge

The same thing happened to me when I tried to load
translations from https://translate.google.com/?hl=es
Copy and Paste to HMG Data Base Assistant "DBA"
on the contrary I pass compile the Sample with the DBF
without any data and I was pasting each record from
the translator and then with Botton Exit perform Save
and so I stay, ignore why it goes wrong one way and
not another.
if you look the PRg is UTF-8 and in the source code
this language is purposely canceled, I have only left
SET CODEPAGE TO UNICODE

Virtual Greetings
Mustafa
Attachments
screenshot2.jpg
screenshot2.jpg (33.86 KiB) Viewed 2292 times
User avatar
serge_girard
Posts: 3364
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Multilingual dbf ?

Post by serge_girard »

I cannot get it working!
There's nothing you can do that can't be done...
User avatar
quartz565
Posts: 671
Joined: Mon Oct 01, 2012 12:37 pm
Location: Thessaloniki, Greece
Contact:

Re: Multilingual dbf ?

Post by quartz565 »

With copy and paste from google translate directly to the grid of the program, I have this result.
After the save, everything remains.
Attachments
Mustafa.png
Mustafa.png (11.49 KiB) Viewed 2270 times
Best Regards,
Nikos.

os: Windows Server 2019 - 64
User avatar
mustafa
Posts: 1175
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Contact:

Re: Multilingual dbf ?

Post by mustafa »

Hi Serge
Delete the entire sample.dbf base with ZAP
start the sample the Grid with nothing
Translate with Google and Copy, then start Paste
in the Grid.
End with Exit Button, the different ones are saved
Languages , as Nikos indicates

Mustafa ;)
Last edited by mustafa on Tue Apr 28, 2020 1:55 pm, edited 1 time in total.
Post Reply