Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
dev:sql:functions:character_length [2010/07/09 20:03]
els
dev:sql:functions:character_length [2016/06/28 22:38] (current)
Line 1: Line 1:
 {{page>:​top_add&​nofooter&​noeditbtn}} {{page>:​top_add&​nofooter&​noeditbtn}}
-{{page>:​sql_bar&​nofooter&​noeditbtn}} 
  
 +====== Development:​ Omnidex SQL ======
  
-====== Omnidex ​SQL Function: CHARACTER_LENGTH ====== +===== SQL Functions: CHARACTER_LENGTH ====== 
-===== Description ​=====+ 
 +==== Description ====
 The CHARACTER_LENGTH function returns the number of characters in a string. The abbreviation,​ CHAR_LENGTH,​ is supported as a synonym for CHARACTER_LENGTH. The CHARACTER_LENGTH function returns the number of characters in a string. The abbreviation,​ CHAR_LENGTH,​ is supported as a synonym for CHARACTER_LENGTH.
  
-CHARACTER_LENGTH should not be confused with $DATA_LENGTH and $COLUMN_LENGTH. ​ $DATA_LENGTH returns the number of characters plus the null-terminator for STRING datatypes. ​ $COLUMN_LENGTH returns the length of the column as declared in the table.+CHARACTER_LENGTH should not be confused with $DATA_LENGTH and $COLUMN_LENGTH. ​ $DATA_LENGTH returns the number of characters plus the null-terminator for STRING datatypes. ​ $COLUMN_LENGTH returns the length of the column as declared in the table.
  
 This function returns an INTEGER datatype.  ​ This function returns an INTEGER datatype.  ​
  
-===== Syntax ​=====+===== Syntax ====
 CHAR[ACTER]_LENGTH ( character_expression ) CHAR[ACTER]_LENGTH ( character_expression )
  
Line 17: Line 18:
 Required. ​ Any expression that returns a character-class datatype. ​ Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype.  ​ Required. ​ Any expression that returns a character-class datatype. ​ Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype.  ​
  
-===== Examples ​===== +==== Examples ==== 
-==== Example 1: Column ​====+=== Example 1: Column ===
 <​code>​ <​code>​
 > select name, character_length(name) len from individuals;​ > select name, character_length(name) len from individuals;​
Line 34: Line 35:
 </​code>​ </​code>​
  
-==== Example 2: Character Expression ​====+=== Example 2: Character Expression ===
 <​code>​ <​code>​
 > select gender, name, char_length(gender || name) len from individuals;​ > select gender, name, char_length(gender || name) len from individuals;​
Line 49: Line 50:
  
 </​code>​ </​code>​
- 
 ====== Additional Resources ====== ====== Additional Resources ======
  
 See also: See also:
- +{{page>​dev:​sql:​functions:​see_also_string&​nofooter&​noeditbtn&​noheader}}
-  * [[dev:​sql:​functions | Summary of Functions]] +
-{{page>​dev:​sql:​functions:​see_also_string&​nofooter&​noeditbtn}} +
-  * [[dev:​sql:​functions | Summary of Functions]]+
  
 {{page>:​bottom_add&​nofooter&​noeditbtn}} {{page>:​bottom_add&​nofooter&​noeditbtn}}
 
Back to top
dev/sql/functions/character_length.1278705828.txt.gz · Last modified: 2016/06/28 22:38 (external edit)