convert MySql to DBF

convert MySql to DBF

Postby dutch » Wed Jul 24, 2019 9:46 am

Dear Master,

I try to save all MySql tables to DBF but MySql use UTF8. The DBF columns will be bigger 3 times.
Example
-------------
I use oCn:SaveToDBF( cSql, cDbfFileName )

oRs:name Varchar 30
when I save to DBF
customer->name Charactor 90

How can I fix this issue?
Regards,
Dutch

FWH 19.01 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio
FWPPC 10.02 / Harbour for PPC (FTDN)
ADS V.9 / MySql / MariaDB
R&R 12 Infinity / Crystal Report XI R2
(Thailand)
User avatar
dutch
 
Posts: 1542
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

Re: convert MySql to DBF

Postby nageswaragunupudi » Wed Jul 24, 2019 11:36 am

You can't.
We need to fix this.
We'll let you know.

Meanwhile, you may please adopt this solution for the time being.

viewtopic.php?f=3&t=37508
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10643
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: convert MySql to DBF

Postby dutch » Wed Jul 24, 2019 12:59 pm

Thank you so much, Master.
nageswaragunupudi wrote:You can't.
We need to fix this.
We'll let you know.

Meanwhile, you may please adopt this solution for the time being.

viewtopic.php?f=3&t=37508
Regards,
Dutch

FWH 19.01 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio
FWPPC 10.02 / Harbour for PPC (FTDN)
ADS V.9 / MySql / MariaDB
R&R 12 Infinity / Crystal Report XI R2
(Thailand)
User avatar
dutch
 
Posts: 1542
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

Re: convert MySql to DBF

Postby nageswaragunupudi » Mon Jul 29, 2019 12:06 am

Fixed in FWH 1907.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10643
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: convert MySql to DBF

Postby dutch » Mon Jul 29, 2019 12:33 pm

Dear Master,

Thank you so much.
Dutch
Regards,
Dutch

FWH 19.01 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio
FWPPC 10.02 / Harbour for PPC (FTDN)
ADS V.9 / MySql / MariaDB
R&R 12 Infinity / Crystal Report XI R2
(Thailand)
User avatar
dutch
 
Posts: 1542
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 40 guests