Connecting Tech Pros Worldwide Forums | Help | Site Map

Problem with reading utf-8 data from MS Access using asp search form

Newbie
 
Join Date: Nov 2007
Posts: 1
#1: Nov 29 '07
I have a form that registers the user with my website, the form is in farsi language and must use utf-8 standard.

I can store data in MS Access and also read it back with any problems. the characters are correct in database too.

but when I want to search a user in my asp search form, the "not found" phrase displayed! any keyword I use to search like username or name or city will fail.

but when I edit the user profile with my asp edit form and update the current data in db the search form can find the user! the data in db are the same as before updating.

I am wondering what is the problem?!!! please help

jhardman's Avatar
Moderator
 
Join Date: Jan 2007
Location: logan, utah
Posts: 2,690
#2: Dec 5 '07

re: Problem with reading utf-8 data from MS Access using asp search form


If you were to print out a search string (I assume you have some sort of SQL query), how does it appear?

Jared
Reply