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

Problem of lower() and upper() commands [CORE5259] #5538

Open
firebird-automations opened this issue Jun 3, 2016 · 5 comments
Open

Problem of lower() and upper() commands [CORE5259] #5538

firebird-automations opened this issue Jun 3, 2016 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Saber Da (dsaber)

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

You must specify the appropriate COLLATE clause in order for the system to know how the characters should be handled.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Worth mentioning what was the character set used for the Persian language. UTF8?

@firebird-automations
Copy link
Collaborator Author

Commented by: Saber Da (dsaber)

Yes, is UTF8

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

And what is the correct result?

@firebird-automations
Copy link
Collaborator Author

Commented by: Saber Da (dsaber)

Must return the same characters
And only for Latin characters make a difference.

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

No branches or pull requests

1 participant