Hi, How was this file generated?
The problem is that the first 3 bytes of the test file are: EF BB BF. 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 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. 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. Regards, Thomas -- 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.
