ASP with problem of utf8 in mysql
Posted by: duilio lupini
Date: October 24, 2005 01:01AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
ASP with problem of utf8 in mysql
2868
October 24, 2005 01:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.