MySQL Forums
Forum List  »  Newbie

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

Options: ReplyQuote


Subject
Written By
Posted
CSV to MySQL 8 issues
October 23, 2018 08:28AM
October 23, 2018 10:24AM
October 23, 2018 10:57AM
October 23, 2018 12:02PM
October 24, 2018 09:24AM
October 24, 2018 11:24AM
October 24, 2018 11:57AM
October 24, 2018 04:46PM
October 24, 2018 08:10PM
October 25, 2018 02:23PM
October 25, 2018 03:44PM
October 25, 2018 08:53PM
October 25, 2018 10:01PM
October 26, 2018 06:56AM
October 26, 2018 09:53AM
October 26, 2018 10:19AM
October 26, 2018 10:49AM
October 26, 2018 11:27AM
October 27, 2018 08:41PM
October 28, 2018 12:58PM
October 29, 2018 11:41AM
October 29, 2018 12:23PM
October 29, 2018 07:53PM
October 23, 2018 10:27AM


Sorry, only registered users may post in this forum.

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.