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

  New Posts New Posts RSS Feed - Problems with international characters in 10.14
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Problems with international characters in 10.14
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
FindTheWord.info View Drop Down
Newbie
Newbie


Joined: 06 February 2012
Location: Gothenburg, SE
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote FindTheWord.info Quote  Post ReplyReply Direct Link To This Post Topic: Problems with international characters in 10.14
    Posted: 07 January 2013 at 1:40pm
After upgrading Web Wiz Forum from version 10.03 to 10.14 it can't be used all since all the international (Swedish) characters are all garbled.

Have a look at:
http://forum-1014.kryssakuten.se - http://forum-1014.kryssakuten.se

I had to revert the installation to 10.03 to make the forum readable (but both runs against the same database): 
http://forum.kryssakuten.se - http://forum.kryssakuten.se

The web page is UTF-8 and the database is UTF-8. 

Writing a new message in version 10.14 with "åäöÅÄÖ" works, but the characters are saved all garbled in database (åäöÅÄÖ). In version 10.03, the characters was stored properly as "åäöÅÄÖ" i the database.

AngryOuchAngry


Edited by FindTheWord.info - 07 January 2013 at 1:46pm
Back to Top
FindTheWord.info View Drop Down
Newbie
Newbie


Joined: 06 February 2012
Location: Gothenburg, SE
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote FindTheWord.info Quote  Post ReplyReply Direct Link To This Post Posted: 07 January 2013 at 1:45pm
The server is IIS 6.0 on Windows Server 2003.
The database is MySql version 5.0.45-community-nt-log.
Back to Top
IanSmithISA View Drop Down
Groupie
Groupie


Joined: 21 October 2010
Location: Worcester
Status: Offline
Points: 127 		Post Options Post Options   Thanks (0) Thanks(0)   Quote IanSmithISA Quote  Post ReplyReply Direct Link To This Post Posted: 07 January 2013 at 2:22pm
Good afternoon,

I doubt that this is relevant but it might be, so I will post it just in caseSmile

A long time ago, when the current MySQL ODBC driver was myODBC 3.51 there were numerous issues with UTF-8 character sets, this was fixed in later versions.

I recently downloaded version 10.12 of the forum and the default value for the MySQL ODBC driver is 3.51.

File Database\database_settings.asp line 62

strMyODBCDriver = "3.51"

Is it possible that in the past you or someone else changed it to something more modern such as 5.1 in your existing and working forum?

Bye

Ian
Why does anyone need more than an 80x25 character only VDU?
Back to Top
FindTheWord.info View Drop Down
Newbie
Newbie


Joined: 06 February 2012
Location: Gothenburg, SE
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote FindTheWord.info Quote  Post ReplyReply Direct Link To This Post Posted: 07 January 2013 at 3:46pm
Thank you for your answer, Ian!

Unfortunately this is not the case. I've checked that both versions uses ODBC 5.1. 
I even tried to upgrade the forum with 3.51, but that did not work at all, since it isn't installed on the server.
Back to Top
FindTheWord.info View Drop Down
Newbie
Newbie


Joined: 06 February 2012
Location: Gothenburg, SE
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote FindTheWord.info Quote  Post ReplyReply Direct Link To This Post Posted: 07 January 2013 at 4:21pm
Now I have found the really strange solution!

By adding the translated language files all the characters was displayed properly again!

Now it works, but the serious problem is that the Web Wiz Forum does not support UTF-8 since all the asp files are encoded in ASCII and not in UTF-8.
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: 07 January 2013 at 4:56pm
You should set the correct locale in your common.asp file. The page below lists the different Locale ID's:-

http://www.webwiz.net/kb/asp-tutorials/date-time-settings.htm
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
FindTheWord.info View Drop Down
Newbie
Newbie


Joined: 06 February 2012
Location: Gothenburg, SE
Status: Offline
Points: 10 		Post Options Post Options   Thanks (1) Thanks(1)   Quote FindTheWord.info Quote  Post ReplyReply Direct Link To This Post Posted: 07 January 2013 at 5:14pm
Thank you, Bruce!

But that was not the problem, LCID was never set in the old version either.

To make Web Wiz Forum to use UTF-8 one solution I found was to change the encoding in language_file_inc.asp from ASCII to UTF-8. This seems to change the whole forum to work with UTF-8 (haven't tested all pages).
Back to Top
 Post Reply Post Reply

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.