> > Nothing changed, except now the SQLite 3 API *EXPLICITLY* says the > text functions require either UTF-8 or UTF-16, but nothing stops > someone doing the same as with SQLite2 and store it's text as BLOBs. > > I forgot to reply this. I thought about BLOB as it uses single byte storage but besides the dirt solution it has no support for collation. Case insensitive can be emulated in a simple and clean way using BLOBs instead of TEXT?
Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users