Dbase data with special characters

Hello All

When we try to get text from dBase files, if the dbase file has information in portuguese language (for example: "Disparo de Disjuntor de Proteção" that means Circuit Beaker Trip in English) the return text from the function:

Text = DevGetField(hDev, "Desc");

is:

It should Return "Disparo de Disjuntor de Proteção". How we can fix this?

Thank you

Patrick over 5 years ago

Might be a problem with the Windows region settings. The text string looks like it is a unicode string displayed as a non-unicode text.
How did you enter the text in the dbf? Is it displaying correctly when you open the dbf in the official Citect Excel Add-In?
I would not trust the old Save_Dbf macro or loading/saving from OpenOffice.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Miguel over 5 years ago

Hello Patrick

The data was enter by Access (DBaseIV).
we cannot use Excel Add-In using Excel 64-bits (Office 365).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Patrick over 5 years ago

You might have a problem here. MS Access works internally with unicode (UTF-16) text.
It looks like you have to find a way to convince Access to save text in dbf files as Windows ANSI (or UTF-8) characters and not as Unicode (or UTF-16).
I have no clue on how to do that though.

I agree that more and more users are using 64-bit version of MS Office and therefore I hope that the Excel add-in will be released for 64-bit Excel soon.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Anton over 5 years ago

Unknown said:
I would not trust the old Save_Dbf macro or loading/saving from OpenOffice.

some days ago we tried OpenOffice and it works very well ....... compiled and started Runtime
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Patrick over 5 years ago

I know that OpenOffice works well with dbf files in general, but OP was specifically mentioning the special character problems he had.
At least OpenOffice is safer to use than the old Save_Dbf macro in Excel, but it is not officially supoorted by Citect.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel