Issue Details (XML | Word | Printable)

Key: CORE-5259
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: Saber Da
Votes: 0
Watchers: 2

If you were logged in you would be able to see more operations.
Firebird Core

Problem of lower() and upper() commands

Created: 03/Jun/16 02:30 PM   Updated: 10/Jun/16 12:48 PM
Component/s: None
Affects Version/s: 2.5.5
Fix Version/s: None

Environment: Windows

QA Status: No test

 Description  « Hide
When i use lower() and upper() commands for persian language receive this result:
select lower('علی') from MON$DATABASE >> ْلي
select upper('علی') from MON$DATABASE >> عءح
and this not be correct. Please check this problem.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Sean Leyne added a comment - 03/Jun/16 04:33 PM
You must specify the appropriate COLLATE clause in order for the system to know how the characters should be handled.

Dmitry Yemanov added a comment - 03/Jun/16 04:39 PM
Worth mentioning what was the character set used for the Persian language. UTF8?

Saber Da added a comment - 03/Jun/16 05:32 PM
Yes, is UTF8

Adriano dos Santos Fernandes added a comment - 03/Jun/16 07:16 PM
And what is the correct result?

Saber Da added a comment - 04/Jun/16 03:02 AM - edited
Must return the same characters
And only for Latin characters make a difference.