Lisp HUG Maillist Archive

Mapping Oracle BLOB type to Common SQL type

Greetings. Ok, I'm trying to produce a database table that can be used by
our app from either MySQL or Oracle. What is the Common SQL mapping for type
BLOB? I *was* using MySQL's TEXT type, which mapped to (string 65536);
however, since Oracle doesn't have a TEXT type, BLOB seemed suitable. But
now I must find a mapping, and BLOB isn't a supported type in Common SQL.
Thanks much...

--
------------------------------------------
David E. Young
dyoung@bloodhoundinc.com
http://www.bloodhoundinc.com
http://lisa.sourceforge.net

"But all the world understands my language."
  -- Franz Joseph Haydn (1732-1809)


Updated at: 2020-12-10 09:00 UTC