[jira] [Commented] (CSV-64) CSVPrinter does not distinguish null and the empty string
[ https://issues.apache.org/jira/browse/CSV-64?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13690339#comment-13690339 ] Gary Gregory commented on CSV-64: - Can we resolve this issue now that we have org.apache.commons.csv.CSVFormat.CSVFormatBuilder.withNullToString(String)? > CSVPrinter does not distinguish null and the empty string > - > > Key: CSV-64 > URL: https://issues.apache.org/jira/browse/CSV-64 > Project: Commons CSV > Issue Type: Bug > Components: Printer >Reporter: Sebb > Fix For: 1.x > > > CSVPrinter does not distinguish null and the empty string. > There should be a way to denote that a string is null rather than empty. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CSV-64) CSVPrinter does not distinguish null and the empty string
[ https://issues.apache.org/jira/browse/CSV-64?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13238610#comment-13238610 ] Emmanuel Bourg commented on CSV-64: --- PostgreSQL can also use a special string for null values: http://www.postgresql.org/docs/current/static/sql-copy.html It supports two default text formats, a tab delimited format and a comma delimited format. The tab delimited format uses \N for null values. The comma delimited format uses an empty string. > CSVPrinter does not distinguish null and the empty string > - > > Key: CSV-64 > URL: https://issues.apache.org/jira/browse/CSV-64 > Project: Commons CSV > Issue Type: Bug > Components: Printer >Reporter: Sebb > Fix For: 1.x > > > CSVPrinter does not distinguish null and the empty string. > There should be a way to denote that a string is null rather than empty. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CSV-64) CSVPrinter does not distinguish null and the empty string
[ https://issues.apache.org/jira/browse/CSV-64?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13229764#comment-13229764 ] Sebb commented on CSV-64: - Other databases may use explicit text strings for null. I used to work on Ingres, and IIRC that used something like "]NULL[" by default. It may be OK to treat null as the empty string by default, but it should be possible to distinguish them when necessary. This will become vital if/when CSV is enhanced to create beans. > CSVPrinter does not distinguish null and the empty string > - > > Key: CSV-64 > URL: https://issues.apache.org/jira/browse/CSV-64 > Project: Commons CSV > Issue Type: Bug > Components: Printer >Reporter: Sebb > > CSVPrinter does not distinguish null and the empty string. > There should be a way to denote that a string is null rather than empty. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CSV-64) CSVPrinter does not distinguish null and the empty string
[ https://issues.apache.org/jira/browse/CSV-64?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13229755#comment-13229755 ] Emmanuel Bourg commented on CSV-64: --- This was discussed in CSV-13, the empty string is the common way to print null values. For example see the HSQLDB doc: http://hsqldb.org/doc/guide/texttables-chapt.html#ttc_nulls > CSVPrinter does not distinguish null and the empty string > - > > Key: CSV-64 > URL: https://issues.apache.org/jira/browse/CSV-64 > Project: Commons CSV > Issue Type: Bug > Components: Printer >Reporter: Sebb > > CSVPrinter does not distinguish null and the empty string. > There should be a way to denote that a string is null rather than empty. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira