I'm not going to promise that this is current, but here is what I think is happening.
Blobs have types assigned when they are created. Blob types, by and large, are advisory, but if you ask to open a blob with a specific type, say "text", the system will attempt to find a blob filter from the blob's declared type to type requested. This mechanism is used, for example, to pretty print BLR blobs. If the blob was defined as generic binary and requested as text, the system will use a built-in blob filter to return the the blob as hex. Beats returning binary gook. It's a pity the industry didn't pick up blob types. There's a great deal more to the world that just "text" and "binary". On 9/26/2014 12:55 PM, Martijn Tonies (Upscene Productions) wrote: >>>> 0x40 = 64, you're basically sayg c = 64, why do you think it should not >>>> be converted to '64' ? >>> Perhaps, because it is a binary blob, not text one. >>> >> Numbers are converted to string, just like when you would do this with a >> VARCHAR or CHAR. > > When I use: > c = 0x414243; > > I get: > 4276803 in characters (hex value 34 32 37 36 38 30 33). > > Why, with a binary blob, is the value returned as characters? > > > With regards, > > Martijn Tonies > Upscene Productions > http://www.upscene.com > > Download Database Workbench for Oracle, MS SQL Server, Sybase SQL > Anywhere, MySQL, InterBase, NexusDB and Firebird! > > > > > ------------------------------------------------------------------------------ > Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer > Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports > Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper > Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer > http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
