ASP with problem of utf8 in mysql

[duilio lupini]

Hi at all, i'm new of here.
I'm developing in ASP a multilingual web site and i need to use UTF-8 because in the same pages i must display more language as italian - russian or english-russian and so on. I have a big problem to store UTF-8 strings in the database from the web site's form.
Now i'm using Mysql 4.1 configured as Server Side and Client side in UTF-8, the fields of the database are in VARCHAR configured in UTF-8.
In the web pages are presents:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">.
the ODBC connection string is:
"MM_MySQL_STRING = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=name;USER=xxxxxx;PASSWORD=xxxx;"
and is the same i will use it on the server.
Are 7 days i become crazy to search information over internet about this problem, but nothing, my db doesn't work, i'm unable to store strings in UTF8 and are all ??????? in the db, so on the screen.
There's someone can say me why it doesn't work? I must to do some special encoding during the transfert of the strings from the web pages to the database???

Thanks a lot at all and i'm sorry for my poor english

P.S.: If i use Navicat to insert string for example in cyrillic, the inserted text on the web pages is right diplay.



Edited 3 time(s). Last edit at 10/25/2005 01:54AM by duilio lupini.