default length unit: 16-bit code units
BigQuery
Db2 (LUW)
Derby
H2
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
SQLite
2005
2007
2009
2011
2013
2015
2017
2019
2021
2023
2019 - 2022
b
2008R2 - 2017
11gR1 - 23.9
a
5.0 - 5.7
1.4.192 - 2.4.240
10.15.1.3 - 10.17.1.0
9.7 - 10.5
16 bit units for
national types
, depends on
nls_length_semantics
for the other types
Observed with the default character set