Problem with posting values from ASP.NET to mysql
I'm developing a web site with mysql backe开发者_如何学Pythonnd and I have the following problem. The site has a Search page that takes parameters in TextBoxes. When I'm posting the form and building the criteria from the values mysql doesn't return anything when I use greek characters. When I'm using Mysql Query Browser the same query works fine. I've set globalization in web.config and have everything in utf-8 encoding. Please Help.
I had a similar problem in PHP recently and had to run some SQL before each query along the lines of:
SET NAMES 'utf8'
Or:
SET CHARACTER SET utf8
Might be worth giving this a try? Hopefully it will help.
精彩评论