diff options
| author | Mark Newnham <mark@newnhams.com> | 2026-02-06 14:44:24 -0700 |
|---|---|---|
| committer | Mark Newnham <mark@newnhams.com> | 2026-02-06 14:44:24 -0700 |
| commit | ac03c91d02098afdd048ada747360c60a10737b7 (patch) | |
| tree | 04a3ed21f89c434eb94a5c75a36db314b1053397 /drivers | |
| parent | 25b9f414e83e184369e43f3496c5f19c34dcc207 (diff) | |
| download | adodb-ac03c91d02098afdd048ada747360c60a10737b7.tar.gz adodb-ac03c91d02098afdd048ada747360c60a10737b7.tar.bz2 adodb-ac03c91d02098afdd048ada747360c60a10737b7.zip | |
Adds the length function
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); + } + } /*-------------------------------------------------------------------------------------- |