Re: Incorrect String Value
Posted by:
Tames Bond
Date: April 12, 2022 07:45PM
The database, table and colunmns were all created in the workbench not in the command line, There were no errors.
The create table info I posted in my previous post was from me running the create table command in the command line, I simply copied and pasted the info that was displayed, I assumed that's what you were asking for. I am assuming you ran that info in the command line and got the errors you are talking about.
The file I am importing is a tsv file so it is tab delimited and I am doing it in the command line because the workbench only allows csv file imports.
The readout of the offending line has only five fields.
00100298
3271 RTE 202
325
Terrain & Résidence
2021
The original error flags on line 8 so it has no problem reading the previous seven lines it is just the é that is giving the problem.
Subject
Written By
Posted
Re: Incorrect String Value
April 12, 2022 07:45PM
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.