Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    38

    Unanswered: Turkish character problem when sorting

    Hi there,

    I'm using PostgreSQL 8.0 Beta 4 for Win32 and it works almost perfectly."Almost" because i'm storing customer names in my DB and when i sort my query result by "names", PG does not sort correctly.For example :

    Names
    -----------------

    Ali
    Mustafa
    Şeyda
    Sanem
    Özgür
    Ilgaz
    Ferhat
    İlker

    When i sort it like "select * from names order by cust_name" the result is :

    Names
    -----------------

    Ali
    Ferhat
    Ilgaz
    Mustafa
    Sanem
    İlker
    Özgür
    Şeyda

    It sorts like above.But in Turkish alphabet, "İ" comes after "I" and "Ş" comes after "S" and "Ö" comes after "O".It does not sorts correctly.Should i change sth in my database or in my SQL query?

    Analyzer

  2. #2
    Join Date
    Apr 2004
    Posts
    38
    Sorry,

    By the way the correct sortment of my example is :

    Names
    -----------------

    Ali
    Ferhat
    Ilgaz
    İlker
    Mustafa
    Özgür
    Sanem
    Şeyda

    Analyzer

  3. #3
    Join Date
    Dec 2004
    Location
    Konya/Türkiye
    Posts
    4

    Cool Alphabetical order issue

    Selamlar!

    An environment variable LC_CTYPE should be set as LC_CTYPE=tr, and this variable is available only when PostgreSQL is compiled with locale support.

    Check your PostgreSQl installation.

    If you are not the administrator, you have to demand it from the administrator(s), if your ISP or who else provides you this service is "in Turkey", they have to do this like that way, as the "default" language in Turkey is Turkish ... Simply demand it...

    Oktay Poçan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •