Subject | Re: [firebird-support] External File Construction |
---|---|
Author | Ivan Prenosil |
Post date | 2004-02-09T20:16Z |
> all. I can live without blob data, but not without nulls.Nulls are not supported directly, but you can easily emulate them
by defining your own null-indicator column:
CREATE TABLE t (
a integer,
ni char(1) )
INSERT INTO t VALUES (123, ' ')
INSERT INTO t VALUES (234, ' ')
INSERT INTO t VALUES (345, 'N')
SELECT CASE ni WHEN 'N' THEN NULL ELSE a END
FROM T
CASE
===========
123
234
<null>
> Also, paddingThen just zip/rar/compress that file ...
> would increase my file sizes by a factor of 10-20 times ( Unused field space
> + a lot of 50 character nulls add up quickly). I need to be able to
> preserve bandwidth here as well. So what would normally be a 100 meg file
> blowing up into 2 gig file to transfer is unworkable.
Ivan
http://www.volny.cz/iprenosil/interbase/