SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast rekha_shp's Avatar
    Join Date
    Jan 2008
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PHP MYSQL Search for unicode data

    Hi,

    In my site I am storing tamil,hindi contents and store it in database using utf-8 data.I am using fulltext search for searching from the database and getting results.But search is not working if I search for tamil or hindi content.

    Can anyone help me to solve this issue pls.

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,706
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Again, please provide relevant details if you expect help with your questions. We can't guess at the data, the query nor the results.

  3. #3
    SitePoint Enthusiast rekha_shp's Avatar
    Join Date
    Jan 2008
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    Sorry for late reply.

    Im my database the values are stored like this,

    Code:
    நà¯à®à¯à®à®³à¯à®®à¯ தமிழில௠à®à®´à¯à®¤à®²à®¾à®®à¯
    which means

    Code:
    நீங்களும் தமிழில் எழுதலாம்
    If I search in the database using php like

    "select * from table where match(subject) against ('நீங்களும் தமிழில் எழுதலாம்')"

    But I can't get any result since the databse contains decoded values.

    Can anyone tell me a good soultion.


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
  •