RE: [firebird-support] Help required

[Mahesh Pratihari]

Thanks

 

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas
Steinmaurer
Sent: Wednesday, August 01, 2012 12:15 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Help required

 

  

Mahesh,

 Could you please let me know what is the equivalent of varbinary( max)
 of SQL datatype in Firebird.

In general, BLOB with an appropriate sub-type. If you are storing binary

data (images, ...) use a sub-type of 0. If you intend to store text 
data, use sub-type 1.

E.g.

column BLOB SUB_TYPE 0
column BLOB SUB_TYPE 1

-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/





[Non-text portions of this message have been removed]

Re: [firebird-support] Help required

[Paul Vinkenoog]

Hi,

  Could you please let me know what is the equivalent of varbinary( max)
  of  SQL  datatype  in Firebird.

 In general, BLOB with an appropriate sub-type.

I'd rather say varchar(max) character set octets, unless max is between 32K and 
64K. In that case you need a BLOB in Firebird, whereas MySQL supports 
(var)chars up to 64K.

Cheers,
Paul Vinkenoog