Special characters after conv Access to MySQ
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28258
Printed Date: 02 April 2026 at 12:49am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Special characters after conv Access to MySQ
Posted By: Otzi
Subject: Special characters after conv Access to MySQ
Date Posted: 19 January 2010 at 9:44am
I converted old 8.02 forum with Access to 9.65 with MySQL database. Conversion from old win-1250 to new utf8 charset was done with Mysql migration toolkit.
If I browse topics in phpMyAdmin (connection collation utf8) special characters are OK, but in forum instead of special characters there are just ????
I included "charset:utf8" in connection string but without success.
My connection string is:
"Driver={MySQL ODBC 5.1 Driver};Port=3306;Option=3;Server=localhost;User ID=myuser;Password=****;Database=mydb;charset:utf8;"
For test I created 2 scripts in PHP and ASP with "charset=utf-8" in meta-header. PHP script with additional mysql_query("SET NAMES utf8") after connecting displays correct special characters, ASP DOESN'T.
Please help me!
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 19 January 2010 at 10:34am
Access to mySQL is not supported as there are to many issues to try and fix and rarely do you end up with a stable database due to the different schemas, datatypes, etc.
You should instead look at upsizing from Access to SQL Server.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: Otzi
Date Posted: 19 January 2010 at 11:03am
I stlil think my conversion was successful because PHP displays special character correcty. I think problem is in ODBC connection and some special settings.
|
|