Uploaded image for project: 'Commons CSV'
  1. Commons CSV
  2. CSV-235

WRONG Implementation for RFC4180

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.6
    • None
    • Parser
    • None

    Description

      https://tools.ietf.org/html/rfc4180#section-2
      7. If double-quotes are used to enclose fields, then a double-quote
      appearing inside a field must be escaped by preceding it with
      another double quote. For example:

      "aaa","b""bb","ccc"
      Apparently, base on a previous issue: https://issues.apache.org/jira/browse/CSV-208, it turns out common-csv does not even support quote and escape to be the same character.

      RFC 4180 defines that quote and escape are both DQUOTE, however in common-csv implementation, the default escape character is not DQUOTE, and it does not work if changed to DQUOTE.

      This means common csv is not rfc4180 compliant.

      Also, I'm puzzled by the fact that someone marked CSV-208 as fixed when nothing is fixed. Instead, it changed the behavior without documenting that the POSTGRESQL_CSV format does not even work out of the box with the default csv format that postgresql produces.

      Attachments

        Activity

          People

            Unassigned Unassigned
            exia Edward Xia
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: