Web Wiz Forums - Strings stored as utf-8 in sql server?

Print Page | Close Window

Strings stored as utf-8 in sql server?

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

Topic: Strings stored as utf-8 in sql server?

Posted By: kria
Subject: Strings stored as utf-8 in sql server?
Date Posted: 21 January 2008 at 11:33am

I just set up a new forum, web_wiz_forums_SQL_server_v9.07 with SQL server 2000.
When trying to import the real names of users from a different db i noticed that webwiz stores string as utf-8 in sql server. Is that the intended behaviour or do I have some setting wrong? As I understand storing utf-8 data in sql server isn't a good thing (order by etc.)

Replies:

Posted By: WebWiz-Bruce
Date Posted: 21 January 2008 at 11:42am

By default Web Wiz Forums page encoding is set to UTF-8 to support non-western languages.

You can change the page encoding by editing the file includes/setup_options_inc.asp in notepad.

For improved performance you should also look at upgrade your SQL Server to 2005 or 2008. This will have an even larger impact on performance when version 10 is released in the next couple of months.

-------------
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