On Tue, Aug 4, 2015 at 6:20 PM, Thomas Mueller <[email protected]
> wrote:

> Hi,
>
> I see, Wikipedia https://en.wikipedia.org/wiki/Comma-separated_values
> writes:
>
>     In some CSV implementations, leading and trailing spaces and tabs are
> trimmed. This practice is controversial, and does not accord with RFC 4180,
> which states "Spaces are considered part of a field and should not be
> ignored.".
>

it means that .., ABC  , ...

the value should be parsed as " ABC  ", being "ABC" is controversial

But right below that:
>
>     According to RFC 4180, spaces outside quotes in a field are not allowed
>

however ..., "ABC"  , ...
is not allowed, which is normal because quoted fields is to escape comma,
new lines etc.


> I think a "human parser" would trim spaces unless they are quoted.
>

I don't think so. the values should not be modified if I don't explicitly
ask for.

Best regards,
Sylvain

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to