[#MDEV-22870] Would like sort order for sql_mode=ORACLE to match Oracle sort order

[MDEV-22870] Would like sort order for sql_mode=ORACLE to match Oracle sort order Created: 2020-06-11 Updated: 2021-12-10
Status:	Open
Project:	MariaDB Server
Component/s:	None
Fix Version/s:	None

Type:

Task

Priority:

Major

Reporter:

Maria M Pflaum

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

Compatibility, Oracle

Issue Links:

Blocks
is blocked by	~~MDEV-23400~~	Add UCA case sensitive accent sensiti...	Closed

Description

MariaDB in oracle-mode orders alpha-numeric as follows:

In mariaDB

AA1

AAA

BBB

But In oracle:

AAA

AA1

BBB

Can we get MariaDB to act like Oracle when sorting in SQL_MODE=ORACLE?

Comments

Comment by Alexander Barkov [ 2020-06-16 ]

This is a different behaviour, not a bug.

Oracle compatible sort orders can be implemented via new MariaDB collations. That's relatively easy to do.

Generated at Thu Feb 08 09:18:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.