Differences

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

Link to this comparison view

dev:sql:functions:data_length [2010/07/28 02:46]
els
dev:sql:functions:data_length [2016/06/28 22:38] (current)
Line 5: Line 5:
 ====== Omnidex SQL Function: $DATA_LENGTH ====== ====== Omnidex SQL Function: $DATA_LENGTH ======
 ===== Description ===== ===== Description =====
-The $DATA_LENGTH function returns the number of characters in a column, plus a terminating null for STRING datatypes.  The $DATA_LENGTH function does not trim trailing spaces, unlike the CHAR_LENGTH function.+The $DATA_LENGTH function returns the number of characters in a column, plus a terminating null for STRING datatypes.  The $DATA_LENGTH function does not trim trailing spaces, unlike the CHAR_LENGTH function.
  
 $DATA_LENGTH should not be confused with CHARACTER_LENGTH and $COLUMN_LENGTH.  CHARACTER_LENGTH returns the number of characters in a string, trimmed of trailing spaces.  $COLUMN_LENGTH returns the length of the column as declared in the table. $DATA_LENGTH should not be confused with CHARACTER_LENGTH and $COLUMN_LENGTH.  CHARACTER_LENGTH returns the number of characters in a string, trimmed of trailing spaces.  $COLUMN_LENGTH returns the length of the column as declared in the table.
 
Back to top
dev/sql/functions/data_length.1280285184.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