On 2-1-2017 15:51, Dimitry Sibiryakov wrote: > Hello, All. > > What would be the right constant for binary field subtype: ttype_binary, > CS_BINARY or > dsc_text_type_fixed? They all have value 1. >
As far as I can tell, you should use isc_blob_untyped, see consts_pub.h: /*****************/ /* Blob Subtypes */ /*****************/ /* types less than zero are reserved for customer use */ #define isc_blob_untyped 0 /* internal subtypes */ #define isc_blob_text 1 #define isc_blob_blr 2 #define isc_blob_acl 3 #define isc_blob_ranges 4 #define isc_blob_summary 5 #define isc_blob_format 6 #define isc_blob_tra 7 #define isc_blob_extfile 8 #define isc_blob_debug_info 9 #define isc_blob_max_predefined_subtype 10 CS_BINARY is the character set id of octets/binary, and ttype_binary as well, as it is defined as: #define ttype_binary CS_BINARY // 1 Given the definition of dsc_text_type_fixed and his peers, I suspect this also applies to dsc_text_type_fixed. Mark -- Mark Rotteveel ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel