www.webdeveloper.com
Results 1 to 1 of 1

Thread: Searcing special characters in database

Threaded View

  1. #1
    Join Date
    Aug 2006
    Location
    Ankara, Turkey
    Posts
    37

    Question Searcing special characters in database

    Hi,

    I'm using a search function like this:

    Code:
    sql = "select * from table where title like '%" &trim(query)&"%' order by id desc"
    But when searching Turkish characters like ş or this function doesn't work. For example, there is a title named "Aşi". My search string is like search.asp?query=asci (it converts Turkish characters to English characters). But it doesn't find it. I want to find "Aşi" when I search for "asci". How can I make this?

    Thanks...
    Last edited by e-XPLoDeR; 02-18-2009 at 05:23 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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



Recent Articles