Sophie

Sophie

distrib > Mandriva > 2009.0 > x86_64 > by-pkgid > 9af421e16629a7b4a01aeedd04ffb445 > files > 62

firebird-2.1.3.18185.0-1mdv2009.0.x86_64.rpm

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;