diff options
Diffstat (limited to 'drivers')
| -rw-r--r-- | drivers/adodb-firebird.inc.php | 13 | ||||
| -rw-r--r-- | drivers/adodb-mssqlnative.inc.php | 13 |
2 files changed, 26 insertions, 0 deletions
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); + } + } /*-------------------------------------------------------------------------------------- |