Differences

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

Link to this comparison view

dev:sql:functions:character_length [2011/01/23 23:09]
els
dev:sql:functions:character_length [2016/06/28 22:38] (current)
Line 8: Line 8:
 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.  
 
Back to top
dev/sql/functions/character_length.1295824169.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0