SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru kgtrip's Avatar
    Join Date
    Jun 2003
    Location
    Karplakistan
    Posts
    804
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    UTF->multi languages problem

    Hi there,

    I'm building a multilingual table. It would have "names" column, which gets name in different languages. Now I have added English and Thai names to the table. When I perform a search say for the letter 'a%' I get as result both those name in English which begins with 'a' and also all the Thai names. I want to get only the English names when I search for 'a%', not the Thai ones. Can someone help me with this?
    Compare Hundreds of Web Hosting Plans

  2. #2
    SitePoint Addict pentium10's Avatar
    Join Date
    Apr 2004
    Location
    Transilvania
    Posts
    208
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    paste the table structure because if you do not provide full information we can`t help you
    Rype :: book, do, charge, collect,
    track time, track expenses and invoice easily on the go.
    Available on Mac, Win, iPhone, WinMobile.
    http://www.rypenow.com

  3. #3
    SitePoint Guru kgtrip's Avatar
    Join Date
    Jun 2003
    Location
    Karplakistan
    Posts
    804
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by pentium10
    paste the table structure because if you do not provide full information we can`t help you
    I manage to figure it up. When you write in UTF encoding, Thai letters begins with 'a' this is how the encoding goes, I don't know why. Anyway it only occurs when the search is performed for 'a%', in any other letter it works fine, so I guess I can live with it

    Thanks anyway
    Compare Hundreds of Web Hosting Plans

  4. #4
    SitePoint Addict pentium10's Avatar
    Join Date
    Apr 2004
    Location
    Transilvania
    Posts
    208
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    why don`t you try to create separate columns for the languages
    ex> eng,tha,ita,ger,esp

    and then the select statement would be more easier
    select eng_name like 'a%' // for english
    select tha_name like 'a%' // for thai
    Rype :: book, do, charge, collect,
    track time, track expenses and invoice easily on the go.
    Available on Mac, Win, iPhone, WinMobile.
    http://www.rypenow.com

  5. #5
    SitePoint Guru kgtrip's Avatar
    Join Date
    Jun 2003
    Location
    Karplakistan
    Posts
    804
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by pentium10
    why don`t you try to create separate columns for the languages
    ex> eng,tha,ita,ger,esp

    and then the select statement would be more easier
    select eng_name like 'a%' // for english
    select tha_name like 'a%' // for thai
    I liked the idea but I don't know upfront in what language the search would be. Anyway thanks
    Compare Hundreds of Web Hosting Plans


Bookmarks

Posting Permissions

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