This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
dev:sql:functions:data_length [2010/07/28 02:46] els created |
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 C 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. | ||
| Line 37: | Line 37: | ||
| See also: | See also: | ||
| - | {{page>dev:sql:functions:see_also_string&nofooter&noeditbtn&noheader}} | + | {{page>dev:sql:functions:see_also_utility&nofooter&noeditbtn&noheader}} |
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||