Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Sort order of foreign language text in sort rows step

  1. #1

    Default Sort order of foreign language text in sort rows step

    How do I get the sort rows step in PDI to sort foreign language text correctly?

    I am trying to sort rows with a text field (type STRING) containing person names. The text field is coded
    in UTF-8. The rows are not sorted correctly according to the set locale (LANG)!
    E.g
    Öa,
    Åa,
    Äa
    Should be sorted
    Åa,
    Äa,
    Öa
    Insted it seems like it is sorted in the UTF-8 order.
    Last edited by ken@omicron.se; 05-22-2014 at 04:18 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.