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)