On Wed, Sep 3, 2014 at 9:56 PM, big stone <[email protected]> wrote:
> As a windows user, I would like that sqlite.exe would support the encoding > 'UTF-8-SIG' for files. > > 'UTF-8-SIG' = normal 'UTF-8' file, but starting by a Byte-Order-Mark. > > > (see http://en.wikipedia.org/wiki/Byte_order_mark#UTF-8) > If you'll read the second paragraph: The Unicode Standard permits the BOM in UTF-8 <http://en.wikipedia.org/wiki/UTF-8>,[2] <http://en.wikipedia.org/wiki/Byte_order_mark#cite_note-2> but does not require or recommend its use.[3] <http://en.wikipedia.org/wiki/Byte_order_mark#cite_note-3> (though that should be "nor" instead of "or") > - if I try to read an utf-8-sig file generated by excel or other thing, my > header is blowed up because of this lack of feature, > That's a bug. A BOM is senseless in UTF8 because UTF8 has no byte-ordering issues. Many software chokes on a BOM (e.g. i've seen PHP-based sites go down because a dev's editor inserted one and it got deployed). -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
