CREATE TABLE PROPS_TXT (
    PTX_ID       BIGINT NOT NULL,
    PTX_ID_OBJ   BIGINT NOT NULL,
    PTX_ID_LANG  BIGINT NOT NULL,
    PTX_PROP     VARCHAR(48) NOT NULL,
    PTX_VALUE    VARCHAR(8192) CHARACTER SET UNICODE_FSS
);

CREATE OR ALTER PROCEDURE GET_TOVAR_NAME_NEW_2
returns (
    yname varchar(8192) character set unicode_fss
    )
as
declare variable i integer;
declare variable s varchar(8192) character set unicode_fss;
begin
  i = 0;
  while (i <= 5) do
  begin
    s = null;
    select first 1 lower(pr.ptx_value)
    from extra_values_ref r
    left join extra_props ep on ep.ep_id = r.ref_ep
    left join props_txt pr on pr.ptx_id_obj = r.ref_ev and pr.ptx_id_lang = 27004 and pr.ptx_prop = 'EV_NAME'
    where r.ref_obj1 = -257962846 and ep.ep_order = :i and ep.ep_obj is not null
    into :s;
    yname = :s;  -- вот тут ошибка
    end
    i = i + 1;
  end
  suspend;
end

arithmetic exception, numeric overflow, or string truncation.
Cannot transliterate character between character sets.

select list( lower(pr.ptx_value), ', ' )
    from extra_values_ref r
    left join extra_props ep on ep.ep_id = r.ref_ep
    left join props_txt pr on pr.ptx_id_obj = r.ref_ev and pr.ptx_id_lang = 27004 and pr.ptx_prop = 'EV_NAME'
    where r.ref_obj1 = -257962846 and ep.ep_obj is not null

CREATE TABLE PROPS_TXT (
    PTX_ID         BIGINT NOT NULL,
    PTX_ID_OBJ     BIGINT NOT NULL,
    PTX_ID_LANG    BIGINT NOT NULL,
    PTX_PROP       VARCHAR(48) NOT NULL,
    PTX_VALUE      VARCHAR(8192) CHARACTER SET UNICODE_FSS,
    PTX_VALUE_UTF  VARCHAR(4096) CHARACTER SET UTF8
);

update props_txt t set t.ptx_value_utf = t.ptx_value

arithmetic exception, numeric overflow, or string truncation.
Cannot transliterate character between character sets.

ALTER TABLE PROPS_TXT ADD PTX_VALUE_UTF VARCHAR(8192) CHARACTER SET UTF8 COLLATE UTF8

Implementation limit exceeded.

CREATE OR ALTER PROCEDURE GET_TOVAR_NAME_NEW_2
returns (
    yname varchar(8191) character set utf8
    )
as
declare variable i integer;
declare variable s varchar(8191) character set utf8;
begin
  i = 0;
  while (i <= 5) do
  begin
    s = null;
    select first 1 lower(pr.ptx_value_utf)
    from extra_values_ref r
    left join extra_props ep on ep.ep_id = r.ref_ep
    left join props_txt pr on pr.ptx_id_obj = r.ref_ev and pr.ptx_id_lang = 27004 and pr.ptx_prop = 'EV_NAME'
    where r.ref_obj1 = -257962846 and ep.ep_order = :i and ep.ep_obj is not null
    into :s;
    yname = :s;
    end
    i = i + 1;
  end
  suspend;
end

update props_txt_2 t set t.ptx_value_utf = 'ёпрст'