Re: Is this bug in MySQL Server 5.7.14?
Posted by: Мих ТехСпец
Date: March 26, 2017 12:24PM

Hm
select * from t.gk;
+---------------------------------------------+
| ben_text |
+---------------------------------------------+
| "Coleção Roadster casaco/colete - 2016". |
+---------------------------------------------+
It is mistake. This string can not have '"'. This symbol is enclosed by '"' in load data local infile query. And what is symbol '.' in the end?

Also you example lost symbol '\'. But this symbol is present in file and it must be import to table.


I can send you my file and all queries (create table, load infile) fo testing.

Options: ReplyQuote




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.