File: README.length

package info (click to toggle)
firebird3.0 3.0.13.ds7-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 42,632 kB
  • sloc: ansic: 374,403; cpp: 319,973; sql: 14,691; pascal: 14,532; yacc: 7,557; fortran: 5,645; sh: 5,336; makefile: 1,041; perl: 194; sed: 83; awk: 76; xml: 19; csh: 15
file content (16 lines) | stat: -rw-r--r-- 486 bytes parent folder | download | duplicates (16) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
SQL Language Extension: BIT_LENGTH, CHAR_LENGTH/CHARACTER_LENGTH and OCTET_LENGTH

Function:
	Return number of bits, characters and bytes of a string.

Author:
	Adriano dos Santos Fernandes <adrianosf@uol.com.br>

Format:
	<length function> ::=
		{ BIT_LENGTH | CHAR_LENGTH | CHARACTER_LENGTH | OCTET_LENGTH } <left paren> <value expression> <right paren>

Example:
	select
		rdb$relation_name, char_length(rdb$relation_name), char_length(trim(rdb$relation_name))
		from rdb$relations;