[jira] [Commented] (CSV-64) CSVPrinter does not distinguish null and the empty string

2013-06-21 Thread Gary Gregory (JIRA)

[ 
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

2012-03-26 Thread Emmanuel Bourg (Commented) (JIRA)

[ 
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

2012-03-14 Thread Sebb (Commented) (JIRA)

[ 
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

2012-03-14 Thread Emmanuel Bourg (Commented) (JIRA)

[ 
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