README.length 486 B

12345678910111213141516
  1. SQL Language Extension: BIT_LENGTH, CHAR_LENGTH/CHARACTER_LENGTH and OCTET_LENGTH
  2. Function:
  3. Return number of bits, characters and bytes of a string.
  4. Author:
  5. Adriano dos Santos Fernandes <[email protected]>
  6. Format:
  7. <length function> ::=
  8. { BIT_LENGTH | CHAR_LENGTH | CHARACTER_LENGTH | OCTET_LENGTH } <left paren> <value expression> <right paren>
  9. Example:
  10. select
  11. rdb$relation_name, char_length(rdb$relation_name), char_length(trim(rdb$relation_name))
  12. from rdb$relations;