Re: Is this bug in MySQL Server 5.7.14?
Posted by: Peter Brawley
Date: March 26, 2017 02:34PM

> It is mistake. This string can not have '"'.

in.txt contains one line which is a copy of what you posted ...

"Coleção Roadster casaco/colete\ - 2016".

> Also you example lost symbol '\'.

`\` is the escape char. it means: escape ie ignore the next char. If you want it to be accepted as data, you'll need to escape it with a preceding '\'

So, if we remove the quotes and the period from in.txt, and escape the escape backslash with a preceding backslash, we get ...

+------------------------------------------+
| ben_text                                 |
+------------------------------------------+
| Coleção Roadster casaco/colete\ - 2016   |
+------------------------------------------+

In no case do we see '�'.

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.