Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Apr 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Searching Database in English and Chinese.

    We have a database with over 100,000 entires; most of the entires are in English, but some of the fields are in Chinese.

    We have built a website where we can search the database and list them in a table.

    We can search in English, but when we search in Chinese, it will say that it cannot find anything, even though I know it is there (I know this because when I search in English, I can see the chinese word there as well).

    I did not build the website, but I will post some of the code anyway.

    Ok, here is the code to search for the Company Name:

    Code:
    if trim(request.QueryString("CompanyName"))<>"" then
    	if search="" then
    		search = search & " WHERE "
    	else
    		search = search & " AND "
    	end if
    	search = search & " CompanyName like '%" & trim(request.QueryString("CompanyName")) & "%' "
    end if

  • #2
    New Coder
    Join Date
    Apr 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I think I should post this as well:

    Code:
    <meta http-equiv="content-type" content="text/html; charset=gb2312">


  •  

    Posting Permissions

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