Skip to content

String truncation exception on UPPER/LOWER functions, UTF8 database and some multibyte characters [CORE5255] #5534

@firebird-automations

Description

@firebird-automations

Submitted by: Олег Короткий (олег короткий)

Votes: 2

select upper('ɐ') from rdb$database
-----------------
arithmetic exception, numeric overflow, or string truncation.
string right truncation.
expected length 2, actual 2.

select lower('ɐ') from rdb$database
-----------------
LOWER
ɐ

select lower('Ⱥ') from rdb$database
-----------------
arithmetic exception, numeric overflow, or string truncation.
string right truncation.
expected length 2, actual 2.

select upper('Ⱥ') from rdb$database
-----------------
UPPER
Ⱥ