On 12 Jan 2013, at 7:32pm, Ted Heng <tedh...@yahoo.com> wrote: > INSERT INTO "Z_METADATA" VALUES (1, '052A3800-692C-4A92-ACE8-F6CE6A3B204A', > X'62706C6973743030D601020304050607090A5556575F101E4E5353746F72654D6F64656C56657273696F6E4964656E746966696572735F101D4E5350657273697374656E63654672616D65776F726B56657273696F6E5F1019
Okay, the format X'hexdigits' is the way SQLite turns a BLOB into text. So if you can figure out the format SQL Server uses to express a BLOB as text, you can probably work out how to turn one into another using global search and replace commands in a text editor. As an alternative you could globally search and replace ', X' with ', ' which may allow SQL Server to import those values as hex. Then you can write your own code in SQL Server to turn those hex values into BLOBs. But once again: this is a SQLite list here, and if you want help with SQL Server you will have to explain SQL Server syntax to us or ask on a SQL Server list. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
