Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Why does Ö come after Z

Received Response
1
Views
3
Comments
Orkan
Orkan Rank 1 - Community Starter
edited Aug 13, 2024 5:15PM in Oracle Analytics Forum

Hi,

I am using 12.2.1.4 and when selecting a colomn with e.g. names, the name starting with 'Ö' should come after 'O', but they display after 'Z'. The Database ist ordering correctly, but BI screws is up.

Is there a setting?

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    What's your NQSConfig.ini say in terms of Locale etc?

  • Orkan
    Orkan Rank 1 - Community Starter

    LOCALE = "english-usa";

    SORT_ORDER_LOCALE = "english-usa";

    thanks for the hint

    so for German..?

    LOCALE = "german-ger";

    SORT_ORDER_LOCALE = "german-ger";

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Very common error since nobody checks those settings. German german (contrary to austrian german or swiss german) - that's for you to say. We DO have some funny differences between the countries ;)