• Replies 5 replies
  • Subscribers 582 subscribers
  • Views 424 views
  • Users 0 members are here
Options
Related

Dbase data with special characters

Miguel

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

Parents
  • 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.
Reply
  • 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.
Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.