Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"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

Open
firebird-automations opened this issue Apr 20, 2016 · 2 comments

Comments

@firebird-automations
Copy link
Collaborator

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().

@firebird-automations
Copy link
Collaborator Author

Commented by: Rudolf Grauberger (rudolf_grauberger.org)

The comment by Geoff Worboys in 'Using a CONTAINING in a collumn with WIN1252 collate breaks with "Cannot transliterate character between character sets"' (CORE4546?focusedCommentId=28779&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#⁠action_28779) already describes this problem.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue is related to CORE4546 [ CORE4546 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment