0 Replies Latest reply on May 31, 2010 11:09 PM by omerzk

    character problem

    omerzk

      hi everyone

       

      in my air application  I  running query trough  sqlite but when I use like syntax  there is problem with turkısh  characters an example of query

       

      My table is like above

       

             fruit
      ---------------------------------------------------------
      id (INTEGER)               |  tur  (TEXT)
      ---------------------------------------------------------
      1                                |  ŞEFTALİ    -PEACH

       

      2                                | şeftali         -peach

       

      3                                 | İNCİR          -FIG

       

      4                                | incir            -fig

       


      select * from meyve where tur like '%Ş%' ;


      this  query makes only one record but two records should come , the records  coming İS "ŞEFTALİ" the other records
      which is written in lowercase  "şeftali" do not come

       

      select * from meyve where tur like  '%ş%' ; here "şeftali" which is lowercase  return , same case happen all 
      lower and upper turkish characters (ÖÇŞÜĞİ öçşüği) in air  applicaiton  data input is made  insert.... values ("ŞEFTALİ").
      How I  can solve this problem .

       

      Thanks  in adanvance .