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

Jump to bottom

ORDER BY works wrong with collate PT_PT [CORE202] #529

Closed
firebird-automations opened this issue Jun 6, 2001 · 19 comments
Closed

ORDER BY works wrong with collate PT_PT [CORE202] #529

firebird-automations opened this issue Jun 6, 2001 · 19 comments
Assignees
@asfernandes
Labels
component: charsets/collation fix-version: 2.1 Alpha 1 priority: major qa: done successfully type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Alice F. Bird (firebirds)

Is related to CORE1221
Is related to QA62

SFID: 430509#⁠
Submitted By: nobody

I have a table:

CREATE TABLE STOCKS
(
MNEN INTEGER NOT NULL,
ACTIVO VARCHAR(50) CHARACTER SET ISO8859_1
COLLATE PT_PT,
CONSTRAINT PK_STOCKS PRIMARY KEY (MNEN)
);

having the values

1, "B&A"
2, "BES"
3, "BCP"
4, "B&A Pref."
5, "Banif"

doing
SELECT ACTIVO FROM STOCKS ORDER BY ACTIVO

gives me:

B&A
Banif
B&A Pref.
BCP
BES

THAT IS WRONG!!!
If wanted i can give a test database i have (using it
on a site)

Pedro Costa
mailto:pbeck@ciberbit.pt

Commits: 72d74a2
@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2005-10-03 16:39
Sender: dimitr
Logged In: YES
user_id=61270

Adriano, could you please decide what's right and what's
wrong here?

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2003-01-24 02:41
Sender: brodsom
Logged In: YES
user_id=546439

This is not a bug but a unicode collation implementation.
Unicode allows four methods to collate "variable" characters
(this class include the ampersand).
The implemented method is the "shifted" one that only take
into account those caracters after it taked into account all
the other characters.
This is the default method for unicode, but I think is the
worse one for users.
The new collations will include the other methods to collate
variable characters.

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2001-10-12 17:10
Sender: dietertremel
Logged In: YES
user_id=275429

same with Collation DE_DE. Please help in next release.
Thank You Dieter Tremel, mailto:tremel@tremel-computer.de

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Syntax:
CREATE COLLATION PT_PT2 FOR ISO8859_1 FROM PT_PT 'SPECIALS-FIRST=1';

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1 [ 10041 ]

SF_ID: 430509 =>

@firebird-automations
Copy link
Collaborator Author

Commented by: Michael Brotr?ck (phreak1981)

Where do I have to write: CREATE COLLATION PT_PT2 FOR ISO8859_1 FROM PT_PT 'SPECIALS-FIRST=1'; ?
ISQL, IBExpert, IBOConsole fail with "token unknown - collation"
Thanks for help...
Greetings Michael Brotr?ck

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

In any tool you can run DDL commands.
But note, this is V2.1 feature, so you need this version. :-)

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

"Fix" confirmed for 2.1 Alpha 1. Test added.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

SF_ID: 430509 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to CORE1221 [ CORE1221 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Reopened to update ticket information.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

SF_ID: 430509 =>

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Reopened [ 4 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA62 [ QA62 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Michael Brotr?ck (phreak1981)

CREATE COLLATION DE_DE2 FOR ISO8859_1 FROM DE_DE 'SPECIALS-FIRST=1';

Tested above with 2.1 Beta 1, looks really good for german collation! Thx a lot!

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10226 ] => Firebird [ 14453 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test => Done successfully

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

@asfernandes asfernandes

Labels
component: charsets/collation fix-version: 2.1 Alpha 1 priority: major qa: done successfully type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@asfernandes @firebird-automations