Solved the BLOB issue -- Replace X' with 0X and removed the enclosing
apostrophe (').
Here's another problem. I presumed the problem is with the dump value in
fraction instead of in the format 'YYYYMMDD ...', etc. Can I change the date
format of the dump?
Operand type clash: numeric is incompatible with datetime2
CREATE TABLE ZADDRESS ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER,
ZADDRESSID INTEGER, ZADDRESSTYPE INTEGER, ZCITY INTEGER, ZORGANIZATION INTEGER,
ZPERSON INTEGER, Z23_PERSON INTEGER, ZDATECREATED DATETIME2, ZDATEUPDATED
DATETIME2, ZLATITUDE REAL, ZLONGITUDE REAL, ZSTREET1 VARCHAR, ZSTREET2 VARCHAR,
ZZIP VARCHAR );
INSERT INTO "ZADDRESS"
VALUES(1,1,3,1,NULL,NULL,NULL,NULL,NULL,378513273.224674,378513273.224674,53.307262,-6.219077,NULL,NULL,NULL);
On Jan 12, 2013, at 11:44 AM, Simon Slavin <[email protected]> wrote:
On 12 Jan 2013, at 7:32pm, Ted Heng <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
