[CSV-168] CsvFormat.nullString should not be escaped

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.2
• Fix Version/s: 1.3
• Component/s: Parser
• Assignee: Gary D. Gregory
• Reporter: cornel creanga
• Created: 17/Jan/16 13:57
• Updated: 19/Jan/16 09:57
• Resolved: 19/Jan/16 02:38

Description

Hello,

Use case: I'm generating MySQL dump files (text format) - for more details check this - http://dev.mysql.com/doc/refman/5.7/en/select-into.html.

Issue: The value null is represented as "\N". Also by default the escape char is '\N'. The CsvPrinter.printAndEscape method will convert this value into

"\\N"

I suggest to modify the CsvPrinter in order to not escape the nullString value - it should be written as it is. I can create a pull request if you want.

I consider it a minor issue because it can be mitigated by making sure that the escape character is not a part of the nullString - however in my case it means that the LOAD commands should be modified accordingly.

Issue Links

• is related to: CSV-170 CSVFormat.MYSQL nullString should be "\N"
• relates to: CSV-169 The null string should be case-sensitive when reading records