Web Wiz Forums - mysql error

Print Page | Close Window

mysql error

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=24833
Printed Date: 04 April 2026 at 8:14am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: mysql error

Posted By: Pezzer
Subject: mysql error
Date Posted: 15 November 2007 at 10:45am

Have had a quick look through the boards and cant find this post already so apologies if it has been discussed / solved and I have not seen it.

I am new to webwiz and just got license etc and am building my board.

On posting a thread if I use special characters ( pound sign in this case ££ ) I get the following error message when you press to submit post.. The screen goes white and I get :-

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Incorrect string value: '\xC2\xA310 o...' for column 'Message' at row 1

/forum/edit_post.asp, line 505

I'm not a Mysql coder or anything so am a bit lost. Any ideas greatfully received.

Thanks in advance

Replies:

Posted By: WebWiz-Bruce
Date Posted: 15 November 2007 at 11:31am

The £ sign isn't a special character, at least not for us as web Wiz is UK based.

There isn't any reason why you would get this error, unless it is coursed by some character encoding issue on the server.

The first thing I would try is reuploading the files to make sure it is not coursed by a corrupted file.

If this doesn't fix the issue, check that the mySQL database is setup with a default character set that supports the £ sign. We setup all our mySQL database servers using latin1 as the default character set.

-------------
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: Pezzer
Date Posted: 15 November 2007 at 12:40pm

Many thanks for your VERY prompt response.

Will check all the above..