Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - MySQL version non-English character garbled.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MySQL version non-English character garbled.
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
chixiaojie View Drop Down
Newbie
Newbie


Joined: 05 October 2008
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote chixiaojie Quote  Post ReplyReply Direct Link To This Post Topic: MySQL version non-English character garbled.
    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)

 
 


Edited by chixiaojie - 15 October 2008 at 1:27am
Back to Top
chixiaojie View Drop Down
Newbie
Newbie


Joined: 05 October 2008
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote chixiaojie Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
chixiaojie View Drop Down
Newbie
Newbie


Joined: 05 October 2008
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote chixiaojie Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
chixiaojie View Drop Down
Newbie
Newbie


Joined: 05 October 2008
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote chixiaojie Quote  Post ReplyReply Direct Link To This Post 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.


Edited by chixiaojie - 16 October 2008 at 12:14am
Back to Top
chixiaojie View Drop Down
Newbie
Newbie


Joined: 05 October 2008
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote chixiaojie Quote  Post ReplyReply Direct Link To This Post 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 ????????????
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
chixiaojie View Drop Down
Newbie
Newbie


Joined: 05 October 2008
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote chixiaojie Quote  Post ReplyReply Direct Link To This Post 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
 
what actuly issue relate??
 
I using "EMS sql manager for mysql" to create database.
 
help please.
 
 


Edited by chixiaojie - 17 October 2008 at 5:39pm
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.