"Cannot transliterate character between character sets" with UPPER('ƒ') in Win1252 connection or UPPER(cast(x'83' as varchar(1) character set win1252)) in any connection [CORE5202] #5483
Labels
affect-version: 2.1.7
affect-version: 2.5.0
affect-version: 2.5.1
affect-version: 2.5.2 Update 1
affect-version: 2.5.2
affect-version: 2.5.3 Update 1
affect-version: 2.5.3
affect-version: 2.5.4
affect-version: 2.5.5
affect-version: 3.0 Alpha 1
affect-version: 3.0 Alpha 2
affect-version: 3.0 Beta 1
affect-version: 3.0 Beta 2
affect-version: 3.0 RC1
affect-version: 3.0 RC2
affect-version: 3.0.0
component: charsets/collation
priority: major
type: bug
Submitted by: Rudolf Grauberger (rudolf_grauberger.org)
Is related to CORE4546
Votes: 1
Executing Upper() on ''ƒ' in/for win1252 raises the exception
"arithmetic exception, numberic overflow, or string truncation
Cannot transliterate character between character sets"
Examples to reproduce (on any database default character set or connection character set):
select cast('ƒ' as varchar(1) character set win1252) from rdb$database; -- work without problems
select upper(cast('ƒ' as varchar(1) character set win1252)) from rdb$database; -- <= raised the exception:
-- Work only >= Firebird 2.5
select upper(cast(x'83' as varchar(1) character set win1252)) from rdb$database; -- <= raised also the exception
All other win1252 letters work without problems on upper().
The text was updated successfully, but these errors were encountered: