Issue recording Unicode characters from a host Windows C++ application

[DianaI13]

Hi,

Do you know if Unicode characters are supported in database fields (dBase 4). We are trying to update the database from Windows C++ application.

Thank you in advance,
Diana

[addsuminc]

Yes. See REF.PDF and the 6.5 reference: https://github.com/MPSystemsServices/CodeBase-for-DBF/blob/master/readme.txt Tony Frates Addsum Business Software, Inc.

…

----- Original Message ----- From: DianaI13 ***@***.***> To: MPSystemsServices/CodeBase-for-DBF ***@***.***> Cc: Subscribed ***@***.***> Date: Fri, 29 Jul 2022 11:02:04 -0700

Subject: [MPSystemsServices/CodeBase-for-DBF] Issue recording Unicode characters from a host Windows C++ application (Issue #13) Hi, Do you know if Unicode characters are supported in database fields (dBase 4). We are trying to update the database from Windows C++ application. Thank you in advance, Diana

-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

[DianaI13]

Thank you, Tony for your prompt response. I found the notes for Unicode. My team will explore. Best Regards, Diana Ivanov Software Development Manager @ Triconex/Schneider-Electric From: addsuminc ***@***.***> Sent: Friday, July 29, 2022 4:21 PM To: MPSystemsServices/CodeBase-for-DBF ***@***.***> Cc: Diana Ivanov ***@***.***>; Author ***@***.***> Subject: Re: [MPSystemsServices/CodeBase-for-DBF] Issue recording Unicode characters from a host Windows C++ application (Issue #13) [External email: Use caution with links and attachments]

…

________________________________ Yes. See REF.PDF and the 6.5 reference: https://github.com/MPSystemsServices/CodeBase-for-DBF/blob/master/readme.txt Tony Frates Addsum Business Software, Inc.

----- Original Message ----- From: DianaI13 ***@***.***<mailto:***@***.***>> To: MPSystemsServices/CodeBase-for-DBF ***@***.***<mailto:***@***.***>> Cc: Subscribed ***@***.***<mailto:***@***.***>> Date: Fri, 29 Jul 2022 11:02:04 -0700

Subject: [MPSystemsServices/CodeBase-for-DBF] Issue recording Unicode characters from a host Windows C++ application (Issue #13) Hi, Do you know if Unicode characters are supported in database fields (dBase 4). We are trying to update the database from Windows C++ application. Thank you in advance, Diana

-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus - Reply to this email directly, view it on GitHub<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgit.luolix.top%2FMPSystemsServices%2FCodeBase-for-DBF%2Fissues%2F13%23issuecomment-1200028414&data=05%7C01%7CDiana.Ivanov%40se.com%7Cbd88344b4be745fbb68408da71b908c2%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C637947336776646960%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yuxHE9HSLsHD2Zw208KxzDLgTuvfZrxNFdHufKaxkQc%3D&reserved=0>, or unsubscribe<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgit.luolix.top%2Fnotifications%2Funsubscribe-auth%2FA2JFUGXIJAX2ZA374ES5OCTVWRRORANCNFSM55BQQBFA&data=05%7C01%7CDiana.Ivanov%40se.com%7Cbd88344b4be745fbb68408da71b908c2%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C637947336776646960%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=fp5LiLSNzTJuXd9Zxs6Z02Lk6IuY1HXQe57UZ9G93%2FY%3D&reserved=0>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

[BobHocker]

Hello,

I'm working with Diana, above.

When we specify one or more "W" fields, the first byte of the generated DBF file changes from 0x03 (dBASE Level 5) to 0x30 which appears to be a FoxPro specific value. This means that we can no longer read the file with non-CBASE tools such as Excel. This corresponds to the CodeBase Reference Guide Appendix E text that says W fields "will not be recognized by other xBASE tools". So I have two questions.

1. Is there any way to alter the code to generate a type 0x03 dbf file with a "W" field that can be read by other tools?
2. If the above is not possible, then we are trying to use a FoxPro driver. Can you point me to an ODBC data source driver that will allow our application to read these files?

Thank you,
Bob Hocker

[BobHocker]

A follow-up question to my questions above:
We tried to open a dbf file that has a Unicode 'W' field in Microsoft Visual FoxPro, but it gave an error: " is not a table". So even Visual FoxPro doesn't appear to recognize type 0x30 dbf files. Is this correct? Shouldn't Visual FoxPro recognize a type 0x30 dbf file written by Codebase? Does this mean that no product other than Codebase can read these files as dBase files? Thanks in advance for any information you can provide.

[addsuminc]

That seems to be what the documentation indicates on page 202 (of REF.PDF) because of that particular field type: "Unicode fields store Unicode strings. The field is padded with nulls. When creating a table with this field type, remember to specify the length as twice the required number of Unicode characters, because each Unicode character is stored in 2 bytes. This field type is only compatible with CodeBase. It will not be recognized by other xBASE tools. When creating a Unicode field in a FoxPro table, CODE4.compatibility must be set to 30." We don't use FoxPro so can't otherwise be of much help. Tony Frates Addsum Business Software, Inc.

…

----- Original Message ----- From: BobHocker ***@***.***> To: MPSystemsServices/CodeBase-for-DBF ***@***.***> Cc: addsuminc ***@***.***>, Comment ***@***.***> Date: Wed, 24 Aug 2022 09:30:22 -0700

Subject: Re: [MPSystemsServices/CodeBase-for-DBF] Issue recording Unicode characters from a host Windows C++ application (Issue #13) A follow-up question to my questions above: We tried to open a dbf file that has a Unicode 'W' field in Microsoft Visual FoxPro, but it gave an error: "<the dbf file> is not a table". So even Visual FoxPro doesn't appear to recognize type 0x30 dbf files. Is this correct? Shouldn't Visual FoxPro recognize a type 0x30 dbf file written by Codebase? Does this mean that no product other than Codebase can read these files as dBase files? Thanks in advance for any information you can provide. -- Reply to this email directly or view it on GitHub: #13 (comment) You are receiving this because you commented. Message ID: ***@***.***>

-- This email has been checked for viruses by Avast antivirus software. www.avast.com

[BobHocker]

Thank you, Tony, for your response.