[jira] [Created] (SANDBOX-410) Predefined format for MYSQL

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (SANDBOX-410) Predefined format for MYSQL

Gilles (Jira)
Predefined format for MYSQL
---------------------------

                 Key: SANDBOX-410
                 URL: https://issues.apache.org/jira/browse/SANDBOX-410
             Project: Commons Sandbox
          Issue Type: Improvement
            Reporter: Emmanuel Bourg
            Priority: Minor
             Fix For: CSV 1.0


MYSQL is able to import/export data in the CSV format. Commons CSV should have a predefined format for the default CSV format used by MYSQL:

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

The specifications of this format is:
- Field separator: \t
- Record separator: \n
- No quoted values
- Field and record separators in field values are escaped with '\'
- Field values are not trimmed
- No header


--
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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Resolved] (SANDBOX-410) Predefined format for MYSQL

Gilles (Jira)

     [ https://issues.apache.org/jira/browse/SANDBOX-410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Emmanuel Bourg resolved SANDBOX-410.
------------------------------------

    Resolution: Fixed
   

> Predefined format for MYSQL
> ---------------------------
>
>                 Key: SANDBOX-410
>                 URL: https://issues.apache.org/jira/browse/SANDBOX-410
>             Project: Commons Sandbox
>          Issue Type: Improvement
>          Components: CSV
>            Reporter: Emmanuel Bourg
>            Priority: Minor
>             Fix For: CSV 1.0
>
>
> MYSQL is able to import/export data in the CSV format. Commons CSV should have a predefined format for the default CSV format used by MYSQL:
> http://dev.mysql.com/doc/refman/5.1/en/load-data.html
> The specifications of this format is:
> - Field separator: \t
> - Record separator: \n
> - No quoted values
> - Field and record separators in field values are escaped with '\'
> - Field values are not trimmed
> - No header

--
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

       
Reply | Threaded
Open this post in threaded view
|

[jira] [Updated] (SANDBOX-410) Predefined format for MYSQL

Gilles (Jira)
In reply to this post by Gilles (Jira)

     [ https://issues.apache.org/jira/browse/SANDBOX-410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Emmanuel Bourg updated SANDBOX-410:
-----------------------------------

    Component/s: CSV
   

> Predefined format for MYSQL
> ---------------------------
>
>                 Key: SANDBOX-410
>                 URL: https://issues.apache.org/jira/browse/SANDBOX-410
>             Project: Commons Sandbox
>          Issue Type: Improvement
>          Components: CSV
>            Reporter: Emmanuel Bourg
>            Priority: Minor
>             Fix For: CSV 1.0
>
>
> MYSQL is able to import/export data in the CSV format. Commons CSV should have a predefined format for the default CSV format used by MYSQL:
> http://dev.mysql.com/doc/refman/5.1/en/load-data.html
> The specifications of this format is:
> - Field separator: \t
> - Record separator: \n
> - No quoted values
> - Field and record separators in field values are escaped with '\'
> - Field values are not trimmed
> - No header

--
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