Print Page | Close Window

MySQL version non-English character garbled.

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=26404
Printed Date: 03 April 2026 at 4:49am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: MySQL version non-English character garbled.
Posted By: chixiaojie
Subject: MySQL version non-English character garbled.
Date Posted: 15 October 2008 at 1:15am

Hi!

I'm using Web Wiz Forums for MySQL Version,  the post send to MySQL will garbled.
 
but broswe in forum is ok. using phpmyadmin to see it will garbled. what's the issue, and how to fix it.
 
as mysql & phpmyadmin configuration is:
 

MySQL charset: UTF-8 Unicode (utf8)

 
 



Replies:
Posted By: chixiaojie
Date Posted: 15 October 2008 at 1:35am
my mean is forum reading form mysql appear ok, but write to mysql will not ok, any helps will appreciate.


Posted By: chixiaojie
Date Posted: 15 October 2008 at 1:47am
i'm form phpmyadmin try to create a blank batabase and wrint some string to store in mysql, it works.
 
i don't know why web wiz forum write some string into mysql garbled, but read form mysql is ok.


Posted By: WebWiz-Bruce
Date Posted: 15 October 2008 at 9:40am
You could try changing the LCID in your common.asp file.

For more info on LCID see the page below:-

http://www.webwiz.net/kb/asp_knowledgebase/date_time_settings.asp - http://www.webwiz.net/kb/asp_knowledgebase/date_time_settings.asp


-------------
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: chixiaojie
Date Posted: 16 October 2008 at 12:11am

i change lcid in common.asp the same problem.

google search many many method.
 
i try to change
 
strCon = "Driver={MySQL ODBC " & strMyODBCDriver & " Driver};Port=3306;Option=3; Stmt=set names 'utf8';charset=utf8;" & strCon
 
in database_connection.asp & mysql_server_setup.asp, see the read append parts, but still the same problem.
 
hlep please.


Posted By: chixiaojie
Date Posted: 16 October 2008 at 2:17am

by the way, how to fouce web wiz forums configration to everything to "uft8-unicode",

I presume write to mysql topics & threads must be uft8 format, because mysql everything is set to "uft8-unicode", I using navicat for mysql client to operate mysql, encoding betwin unicode & chinese, something like ????????????


Posted By: WebWiz-Bruce
Date Posted: 16 October 2008 at 8:16am
When using mySQL with ASP you have to use the myODBC driver, it maybe this which doesn't support UTF-8 as Web Wiz Forums can use UTF-8 fine with other supported databases.

Try installing the newer myODBC 5.1 database driver on the server and edit in notepad the database/database_connection.asp file and change it from the default myODBC 3.51 driver to myODBC 5.1 driver.

If this doesn't work try using SQL Server instead.


-------------
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: chixiaojie
Date Posted: 17 October 2008 at 5:36pm

hi, on my localhost, I also did a lot of test,  and on my hosting provide server. both are the same, once again, the web wiz forums have this issue.

in my localhost, when I configration everything set by default. I didn't do any change. then I extractor the web wiz forums, just setup database_connetion.asp this file, and everything also set by default.
 
then this issue happening. write topics & threads into mysql, then read them form mysql, both are not ok.
 
text appear each property with behide.
 
like:
枉逝岁朿browser=RTE
我们都是中国亿priority=0
Delphi技术交浿description=交流技朿showTopics=0
http://localhost/sss/forum_topics.asp?FID=1 -
 
what actuly issue relate??
 
I using "EMS sql manager for mysql" to create database.
 
help please.
 
 


Posted By: chixiaojie
Date Posted: 17 October 2008 at 5:45pm

localhost & virtual hosting both are garbled.

now I more & more certain "Web Wiz Forums for MySQL" have big issue or maybe is a bug.
 
hope also can get certain form other user.


Posted By: chixiaojie
Date Posted: 17 October 2008 at 5:51pm
"RTE_setup.asp"
 
what this file for? I also presume this file have some problem.


Posted By: 123Simples
Date Posted: 17 October 2008 at 6:09pm
Am I missing the point here, or you trying to run web wiz asp applications on a server that does not support the software?
ASP Application/Script won't run!

This seems to be the most common problem that people have.

ASP need's to be run through a web server, hence the name Active Server Pages, no Server, no Active Pages. If you are not familiar with ASP please read through the article on, What is Active Server Pages (ASP)?

If you are finding that you can't get an ASP script to run on your web space provided by your web space provider then check with them that they fully support ASP.

ASP is completely different to CGI and Pearl, so having support for CGI does not mean that you have support on your web space for ASP.

How can I tell if my web space supports ASP?
To be able to tell if your web space provider supports ASP, the easiest way is to look at any FAQ or support pages that your hosting provider may have, or contact them by email or phone and ask them

The type of "bug" you seem to be describing seems weird


-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design


Posted By: chixiaojie
Date Posted: 18 October 2008 at 2:02am
find a solution,
 
first: using "navigate for mysql" software encoding to chinese, then ok.
 
second, call my hosting provider configration phpmyadmin support webpage encoding appear to chinese character.
 
that's it.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net