Hi Thomas.
> How was this file generated?
>   
It's a fragment of a big one generated with a VBScript in MS-Excel.

> The problem is that the first 3 bytes of the test file are: EF BB BF.
>   
Very interesting, I don't see that !
> This is like a byte order mark (BOM) but actually it isn't because
> there is no "byte order" in UTF-8. As far as I read the UTF-8 spec the
> file shouldn't start with those bytes. See also
> http://tools.ietf.org/html/rfc3629#section-6 "A protocol SHOULD forbid
> use of U+FEFF as a signature for those textual protocol elements that
> the protocol mandates to be always UTF-8, the signature function being
> totally useless in those cases". See also
> http://en.wikipedia.org/wiki/Byte_order_mark#cite_note-utf-8-bom-3
>   
I agree with you , but comming from an xls anything can be possible.
> The CSV tool could support those bytes, however it would slow down
> processing of everything else, therefore I think I will not support
> this case. In my view, those 3 bytes are an error. There is no byte
> order for UTF-8, therefore those 3 bytes are meaningless.
>   
Don't  do that , I can filter this bytes at my program.
> Still, I will add a feature request to support this case. But it would
> be good to know what tools do generate such a BOF

Thanks for help - regards
Dario.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to