means to interpret the string of bytes in some way that is meaningful to the application and the human user. Character set OCTETS Data in OCTETS encoding are treated as bytes that may not actually be hexadecimal digits in any other positions, e.g. 'A0bF4E45- 3029-2a44-D493-4998c9b439A3' Converts a human-readable 36-char UUID string to the corresponding 16-byte UUID. CHAR_TO_UUID Examples select ch string) select char_to_uuid('A0bF4E45-3029-2A44-X493-4998c9b439A3') from rdb$database -- error: -Human readable UUID argument for CHAR_TO_UUID must -- have hex digit at position 20 instead of "X

fairly simplistic encoding of the source code. It would not be difficult to decode the BLR back to a human readable form. Such a decoding would be without comments and formatting, but the SQL that goes into

means to interpret the string of bytes in some way that is meaningful to the application and the human user. Character set OCTETS Data in OCTETS encoding are treated as bytes that may not actually be 3029-2a44-D493-4998c9b439A3' Result type CHAR(16) CHARACTER SET OCTETS Description Converts a human-readable 36-char UUID string to the corresponding 16-byte UUID. Examples select char_to_uuid('A string) select char_to_uuid('A0bF4E45-3029-2A44-X493-4998c9b439A3') from rdb$database -- error: -Human readable UUID argument for CHAR_TO_UUID must -- have hex digit at position 20 instead of "X

MyVariable = 'Equal'; These versions will give you the results that a normal (i.e. not SQL-brainwashed) human being would expect, whether there are NULLs involved or not. More about NULLs A lot more information

'Not equal'; else MyVariable = 'Equal'; These versions will give you the results that a normal human being (untouched by SQL standards) would expect, whether there are NULLs involved or not. More about

type -833 335544947 sysf_argviolates_uuidtype Human readable UUID argument for @1 must be of string type -833 335544948 sysf_argviolates_uuidlen Human readable UUID argument for @2 must be of exact 335544949 sysf_argviolates_uuidfmt Human readable UUID argument for @3 must have "-" at position @2 instead of "@1" -833 335544950 sysf_argviolates_guidigits Human readable UUID argument for @3 must

Пример: CREATE VIEW LOW_BONES AS SELECT SP1.ID, SP1.NAME, SP1.DESCRIPTION FROM THEM_BONES('HUMAN') SP1 WHERE NAME IN ('LEG_BONE', 'FOOT_BONE', 'TOE_BONE') Представления могут выводить имена столбцов

string) SELECT CHAR_TO_UUID('A0bF4E45-3029-2A44-X493-4998c9b439A3') FROM rdb$database -- error: -Human readable UUID argument for CHAR_TO_UUID must -- have hex digit at position 20 instead of "X (ASCII