Strange letters
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=31762
Printed Date: 28 March 2026 at 11:36am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Strange letters
Posted By: AllMor
Subject: Strange letters
Date Posted: 23 December 2022 at 9:09pm
|
Since the 21'th of December, users of my forum have been unable to log in if they have Danish letters in their username. If they´re allready logged in, their posts looks strange, with strange letters. I haven't touched the forum for a long time, and can't understand what's going on. ------------- https://forum.excel-regneark.dk |
Replies:
Posted By: AllMor
Date Posted: 27 December 2022 at 3:56pm
|
This is the error I receive when I try to update the members profile. All the other profiles are updating fine, but when this profile is posting i my forum, danish letters are not showing correctly.  ------------- https://forum.excel-regneark.dk |
Posted By: AllMor
Date Posted: 29 December 2022 at 2:05pm
|
I found the reason. My hostingprovider has updated the sql-driver from v5.3 to v8 the day i discovered the isue. It seems that WWF needs an update to run om that driver version. My forum is dead now  because I can't solve the problem myself.Allan ------------- https://forum.excel-regneark.dk |
Posted By: WebWiz-Bruce
Date Posted: 29 December 2022 at 4:21pm
|
Sorry to hear of your problems with your forum. Both the MyODBC 8 database driver and MySQL 8 Database server are supported by Web Wiz Forums 12.05.
To update the driver your host would have had to go in to your forum setting and changed the database connection string. This seems unlikely. What sounds more likely is that you host has updated their MySQL database servers to MySQL 8. MySQL 8 is supported by Web Wiz Forums with no changes needing to to made, we host hundreds of Web Wiz Forums for our customers using MySQL 8 without issue. If you host has upgraded their database servers to MySQL 8 it sounds like something went wrong and the encoding for the data in your database. If your host did go into your database/database_settings.asp file and change the database driver, which seems very unlikely, it needs to be set to the following for MyODBC 8 strMyODBCDriver = "8.0 Unicode"
------------- 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: AllMor
Date Posted: 29 December 2022 at 10:23pm
|
Hi Bruce Thank you Bruce, I really appreciate your help strMyODBCDriver = "8.0 Unicode" solved the connection-part of the problem. The forum is now running again, but still with the strange danish letters - only in new posts, not in post allready stored in the database before the sql update to v8. The page encoding in WWF is set to Western European iso-8859-1 in phpMyAdmin the Server connection collation is set to utf8mb4_unicode_ci Do I have to change something here? Allan ------------- https://forum.excel-regneark.dk |
Posted By: WebWiz-Bruce
Date Posted: 03 January 2023 at 8:28am
|
During the period that the incorrect driver was set any posts saved would have been using an incorrect encoding, now that you have the correct driver any new posts will use the correct encoding. It will likely mean that for those few days that the encoding was wrong those posts will always show incorrectly as the encoding that was used to save them would have been set incorrectly, ------------- 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: AllMor
Date Posted: 03 January 2023 at 1:24pm
|
Hi Bruce The solution that worked for me, was to change strMyODBCDriver to "8.0 ANSI" in the database_settings.asp file. After this change, the Danish letters are shown correct again. I am very happy now  thanks for your help//Allan ------------- https://forum.excel-regneark.dk |