Firebird 3.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select rdb$get_context('SYSTEM', 'ENGINE_VERSION') as version
     , rdb$character_set_name
from rdb$database;


VERSION
RDB$CHARACTER_SET_NAME


3.0.10
UTF8


Select char_LENgth(1234) from rdb$database


CHAR_LENGTH


4


create table T (
  i integer,
  c char(20),
  v varchar(20)
)
insert into T values (1234, 1234, 1234)
1 rows affected

select * from T


I
C
V


1234
1234
1234


Select 
  char_length(1234) as const
  , char_length(i) as int_to_char
  , char_length(c) as fixed_char
  , char_length(v) as var_char
  , char_length(trim(c)) as char_t
  , char_length(cast(trim(c) as varchar(20))) as char_t_v
  , char_length(trim(cast(c as varchar(20)))) as char_v_t
from T


CONST
INT_TO_CHAR
FIXED_CHAR
VAR_CHAR
CHAR_T
CHAR_T_V
CHAR_V_T


4
4
20
4
4
4
4