Web Wiz Support and Community Forums : Language error possibly ? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 10:23:55 +0000 Fri, 16 Nov 2007 08:56:14 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24836 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Language error possibly ? : I will check all the above, thank...]]> https://forums.webwiz.net/language-error-possibly_topic24836_post129385.html#129385 Author: Pezzer
Subject: 24836
Posted: 16 November 2007 at 8:56am

I will check all the above, thank you for looking into this for me.I will post back any results.
The main reason for not wanting to swap from MySQL is that even tho I run the server SQL is way past me and I got someone to set mysql and the forum up for me. So to now swap means doing the same again and it took me weeks to get it done the first time. Also the forum is now live with posts and wouldn't want to loose all the data.



]]> Fri, 16 Nov 2007 08:56:14 +0000 https://forums.webwiz.net/language-error-possibly_topic24836_post129385.html#129385 <![CDATA[Language error possibly ? : Looking again at your error a...]]> https://forums.webwiz.net/language-error-possibly_topic24836_post129383.html#129383 Author: WebWiz-Bruce
Subject: 24836
Posted: 16 November 2007 at 8:22am

Looking again at your error a \ is an escape character in mySQL, and the error message has \xC2\xA3<br> in it. This looks to be myODBC driver is trying to insert \xC2\xA3 into the database rather than £ or &pound;

To me this looks like either a server encoding issue or an issue with the myODBC driver. We still use the myODBC 3.51.12 as we have found a number of issues with the newer drivers when used on Windows server 2003 SP2, with the IIS app pool crashing under load with the newer versions of this driver.

You should also check the page encoding you have set for your forum, and in the server control panel, check the Regional Language Options are all set to English (united Kingdom) and you have ALL 'Code page conversion tables' installed on the server. Under the web edition these are all installed by default, but not with other version of Windows 2003 server.
]]> Fri, 16 Nov 2007 08:22:35 +0000 https://forums.webwiz.net/language-error-possibly_topic24836_post129383.html#129383 <![CDATA[Language error possibly ? : The reason I suggested using SQL...]]> https://forums.webwiz.net/language-error-possibly_topic24836_post129382.html#129382 Author: WebWiz-Bruce
Subject: 24836
Posted: 16 November 2007 at 8:13am

The reason I suggested using SQL Server is given the choice I would opt for SQL Server over mySQL on a Windows system using ASP and ASP.NET any day, as they work much better, and as you are on a dedicated server there is nothing stopping you installing SQL Server Express.

mySQL is a good database, but the myODBC driver that you use for ASP to talk to the mySQL databases has allot to be desired with many strange and unusual bugs. Infact, try reinstalling the myODBC 3.51 driver to see if that fixes the issue.

The mySQL version of Web Wiz Forums works fine with many 1,000's of users running it. We have over 100 users on our own systems using the mySQL version, some with over 500,000 posts with no issues at all.

The bugs you mention seem very odd, no-one else has reported them and we are unable to replicate them in the lab. There is certainly a setting wrong on the server somewhere for the £ sign not to work in mySQL.

If you want to stay with the mySQL version, then try reinstalling mySQL and the myODBC driver to see if that resolves the issue. Also check that the server is setup with UK locale settings.
]]> Fri, 16 Nov 2007 08:13:56 +0000 https://forums.webwiz.net/language-error-possibly_topic24836_post129382.html#129382 <![CDATA[Language error possibly ? : So you think that MySQL is the...]]> https://forums.webwiz.net/language-error-possibly_topic24836_post129369.html#129369 Author: Pezzer
Subject: 24836
Posted: 15 November 2007 at 7:33pm

So you think that MySQL is the issue then ?

Just odd that it only the pound sign £ that throws up the error. Also the password problem of when you change the status of a user in their profile to move them from one group to another it wipes their password out, is that MySQL issue too ?

To be honest after spending $129.99 on a product that proports to support MySQL to now be advised to get rid I don't really want to do. Is there no other solution ?


]]> Thu, 15 Nov 2007 19:33:25 +0000 https://forums.webwiz.net/language-error-possibly_topic24836_post129369.html#129369 <![CDATA[Language error possibly ? : To be honest with you if you are...]]> https://forums.webwiz.net/language-error-possibly_topic24836_post129368.html#129368 Author: WebWiz-Bruce
Subject: 24836
Posted: 15 November 2007 at 7:15pm

To be honest with you if you are running your own dedicated server, I would use SQL Server Express instead of mySQL.

SQL Server Express is a free download from MS and can be used legally in a web hosting environment without paying additional licensing fees to Microsoft on top of your monthly SPLA licensing fees for Windows 2003 server.
]]> Thu, 15 Nov 2007 19:15:24 +0000 https://forums.webwiz.net/language-error-possibly_topic24836_post129368.html#129368 <![CDATA[Language error possibly ? : Have the most strange error...]]> https://forums.webwiz.net/language-error-possibly_topic24836_post129365.html#129365 Author: Pezzer
Subject: 24836
Posted: 15 November 2007 at 5:07pm

Have the most strange error occuring that I know must be easy to solve if it isnt then it will create some amusement

When creating a post on my forum ( I'm new too by the way ) you can type every letter on your keyboard other than the £ sign. As soon as you press the pound sign and press to post the message you get the following error message

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/forum/edit_post.asp, line 505


Ok for those that are now thinking it's blah blah blah heres what I am running and using :-

Dedicated Windows Server 2003 rackmount
Fully updated and legal !
MySQL
WebWiz 9 just purchased and licensed
MySQL language set to Latin1

Rest of forum works fine other than one gripe about if you change something in somebodies profile it resets their password.

We are a UK site and people want to use the £ sign on a items for sale part of the board. So getting error messages kinda kills the forum useage.


Any ideas anyone?




Edited by Pezzer - 15 November 2007 at 5:08pm]]> Thu, 15 Nov 2007 17:07:32 +0000 https://forums.webwiz.net/language-error-possibly_topic24836_post129365.html#129365