====== length ======
~~NOTOC~~
<WRAP right box>
==Syntax==
  string length(string $columnName)
</WRAP>
===== Description =====
The method ''length()'' returns a database-specific SQL statement that retrieves the length of data in a field. This happens even when the field is defined as a fixed-length CHAR field, because the field's contents is trimmed before the length of the data is obtained.

Available since ADOdb 5.23.0.

===== Usage =====
<code php>
/*
 * Assume MySQL database
 */
$sql = $db->length(some_string_field);

/*
 * Returns: LENGTH(TRIM(some_string_field);
*/
</code>

<code php>
/*
 * Assume Firebird database
 */
$sql = $db->length(some_string_field);

/*
 * Returns: CHAR_LEN(TRIM(some_string_field);
*/
</code>