CSV to MySQL 8 issues
Posted by:
Jim Sawyer
Date: October 23, 2018 08:28AM
When converting a CSV file to MySQL 5.7 it would automatically accept a string 'T' or 'F' into a tinyint(1) unsigned field as a 1 or 0. After a couple hours playing with 8.0, I can't do this now.
Likewise I can't get it to accept a string value such as '57' into an int(8) field as 57. Since I'm converting client's data from FoxPro where this is necessary, for me this presents a major problem.
Is this something I have to live with, or am I missing something?
Thanks,
Jim Sawyer
Subject
Written By
Posted
CSV to MySQL 8 issues
October 23, 2018 08:28AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.