Sort Order Changed with a Different Database

If you’ve been using Liferay Portal, but are switching it to use a different database type, consult your database vendor documentation to understand your old and new database’s default query result order. The default order is either case-sensitive or case-insensitive. This affects entity sort order in Liferay Portal.

Here are some examples of ascending alphabetical sort order.

Case-sensitive:

111
222
AAA
BBB
aaa
bbb

Case-insensitive:

111
222
AAA
aaa
BBB
bbb

Your new database’s default query result order might differ from your current database’s order.

Consult your vendor’s documentation to configure the order the way you want.

0 (0 Votes)
Using OSGi Services from EXT Plugins Previous