to (2 63 - 1) The data type is available in Dialect 3 only BLOB Varying The size of a BLOB segment is limited to 64K. The maximum size of a BLOB field is 4 GB A data type of a dynamically variable storing large amounts of data, such as images, text, digital sounds. The basic structural unit is a segment. The blob subtype defines its content CHAR(n), CHARACTER(n) n characters. Size in bytes depends ] [SEGMENT SIZE <segment size>] [CHARACTER SET ] [COLLATE ] Chapter 3. Data Types and Subtypes 36 Shortened syntax BLOB (<segment size>) BLOB (<segment size>,

длины, зачастую очень большого объёма. Типы данных 45 Синтаксис: BLOB [SUB_TYPE ] [SEGMENT SIZE ] [CHARACTER SET ] Сокращённый синтаксис: CHAR} [VARYING] [(size)] [] | BLOB [SUB_TYPE {subtype_num | subtype_name}] [SEGMENT SIZE seglen] [CHARACTER SET charset] | BLOB [(seglen [, subtype_num])] ::= [[x:]y CHAR} [VARYING] [(size)] [] | BLOB [SUB_TYPE {subtype_num | subtype_name}] [SEGMENT SIZE seglen] [CHARACTER SET charset] | BLOB [(seglen [, subtype_num])] ::= [x:y [

2.1 Error Codes SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 101 335544366 segment Segment buffer length shorter than expected 100 335544338 from_no_match supported -406 335544457 out_of_bounds Subscript out of bounds -407 335544435 nullsegkey Null segment of UNIQUE KEY -413 335544334 convert_error Conversion error from string "@1" -413 335544454 nofilter 335544537 integ_index_seg_del Cannot delete index segment used by an Integrity Constraint -618 335544538 integ_index_seg_mod Cannot update index segment used by an Integrity Constraint -625 335544347 not_valid

Firebird 2.0 Error Codes Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 100 335544338 from_no_match No match for first value expression supported -406 335544457 out_of_bounds Subscript out of bounds -407 335544435 nullsegkey Null segment of UNIQUE KEY Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -413 335544334 convert_error 335544537 integ_index_seg_del Cannot delete index segment used by an Integrity Constraint -618 335544538 integ_index_seg_mod Cannot update index segment used by an Integrity Constraint -625 335544347

22 6.2. Get segment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 6.3. Put segment . . . . . . op_open_blob2) 6.2. Get segment Client Int32 Operation code (op_get_segment) Int32 Blob handle Int32 Segment length (max length = 32768) Chapter 6. Blobs 22 Int32 Data segment (0) Server Generic Generic response — where Data is the blob segment. 6.3. Put segment Client Int32 Operation code (op_batch_segments) Int32 Blob handle Buffer Blob Segments Server Generic response 6.4. Seek Client

1.5 Error Codes from msg.gbak, release sources SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 100 335544338 from_no_match No match for first value expression supported -406 335544457 out_of_bounds Subscript out of bounds -407 335544435 nullsegkey Null segment of UNIQUE KEY -413 335544334 convert_error Conversion error from string "" -413 335544454 335544537 integ_index_seg_del Cannot delete index segment used by an Integrity Constraint -618 335544538 integ_index_seg_mod Cannot update index segment used by an Integrity Constraint -625 335544347 not_valid

number of characters is not specified, 1 is used by default. BLOB Varying The size of a BLOB segment is limited to 64K. The maximum size of a BLOB field is 4 GB A data type of variable size for storing large amounts of data, such as images, text, digital sounds. The basic structural unit is a segment. The blob subtype defines its content BOOLEAN 8 bits false, true, unknown Boolean data type ] [SEGMENT SIZE <segment size>] [CHARACTER SET ] [COLLATE ] Chapter 3. Data Types and Subtypes 52 Shortened syntax BLOB (<segment size>) BLOB (<segment size>,

PAGE_SIZE, PAGES, PASSWORD, PRIVILEGES, PROTECTED, READ, RESERV, RESERVING, RETAIN, SCHEMA, SEGMENT, SHADOW, SHARED, SINGULAR, SIZE, SNAPSHOT, SORT, STABILITY, STARTING, STARTS, STATEMENT HELP, IMMEDIATE, INDICATOR, INIT, INPUT, ISQL, LC_MESSAGES, LC_TYPE, LEV, LOG_BUFFER_SIZE, MAX_SEGMENT, MAXIMUM, MESSAGE, MINIMUM, NOAUTO, NUM_LOG_BUFFERS, OUTPUT, PAGELENGTH, PREPARE, PUBLIC, PRIVILEGES PROTECTED 22 Руководство по языку SQL READ RESERV RESERVING RESTRICT RETAIN ROLE SCHEMA SEGMENT SHADOW SHARED SINGULAR SIZE SNAPSHOT SORT STABILITY STARTING STARTS STATEMENT STATISTICS SUB_TYPE

großen Datenmengen, wie z.B. Bilder, Texte, Audiodaten. Die strukturelle Basiseinheit is das Segment. Der BLOB-Untertyp definiert dessen Inhalt. BOOLEAN 8 Bits false, true, unknown Boolean-Datentyp BLOB [SUB_TYPE ] [SEGMENT SIZE <segment size>] [CHARACTER SET ] [COLLATE ] Verkürzte Syntax BLOB (<segment size>) BLOB (<segment size>, ) BLOB (, ) Syntax der BLOB-Datentypen ::= BLOB [SUB_TYPE {subtype_num | subtype_name}] [SEGMENT SIZE seglen] [CHARACTER SET charset] Chapter 3. Datentypen und Untertypen 56 | BLOB [(seglen