diff options
| -rw-r--r-- | adodb.inc.php | 13 | ||||
| -rw-r--r-- | drivers/adodb-firebird.inc.php | 13 | ||||
| -rw-r--r-- | drivers/adodb-mssqlnative.inc.php | 13 |
3 files changed, 39 insertions, 0 deletions
diff --git a/adodb.inc.php b/adodb.inc.php index 84b64e09..ea1ac97f 100644 --- a/adodb.inc.php +++ b/adodb.inc.php @@ -3856,6 +3856,19 @@ http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_1 return ''; } + /** + * Returns SQL to obtain the length of data in a column, including + * CHAR fields + * + * @param string $fieldName The field length to measure + * + * @return string + */ + public function length(string $fieldName): string + { + return sprintf('LENGTH(TRIM(%s))', $fieldName); + } + } // end class ADOConnection /** diff --git a/drivers/adodb-firebird.inc.php b/drivers/adodb-firebird.inc.php index 6d495973..66d9c05f 100644 --- a/drivers/adodb-firebird.inc.php +++ b/drivers/adodb-firebird.inc.php @@ -1004,6 +1004,19 @@ class ADODB_firebird extends ADOConnection { return $rs; } + /** + * Returns SQL to obtain the length of data in a column, including + * CHAR fields + * + * @param string $fieldName The field length to measure + * + * @return string + */ + public function length(string $fieldName): string + { + return sprintf('CHAR_LEN(TRIM(%s))', $fieldName); + } + } /** diff --git a/drivers/adodb-mssqlnative.inc.php b/drivers/adodb-mssqlnative.inc.php index 528a7018..accc3c8c 100644 --- a/drivers/adodb-mssqlnative.inc.php +++ b/drivers/adodb-mssqlnative.inc.php @@ -1088,6 +1088,19 @@ class ADODB_mssqlnative extends ADOConnection { } + /** + * Returns SQL to obtain the length of data in a column, including + * CHAR fields + * + * @param string $fieldName The field length to measure + * + * @return string + */ + public function length(string $fieldName): string + { + return sprintf('LEN(TRIM(%s))', $fieldName); + } + } /*-------------------------------------------------------------------------------------- |