"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
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5202
URL: http://tracker.firebirdsql.org/browse/CORE-5202
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation
Affects Versions: 3.0.0, 3.0 RC2, 2.5.5, 3.0 RC1, 3.0 Beta 2, 2.5.4, 2.5.3
Update 1, 2.1.7, 3.0 Beta 1, 2.5.3, 3.0 Alpha 2, 3.0 Alpha 1, 2.5.2 Update 1,
2.5.2, 2.5.1, 2.5.0
Environment: Windows 32/64 bits
Reporter: Rudolf Grauberger
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().
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
