Strings stored as utf-8 in sql server?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
kria Members Profile Find Members Posts Newbie Joined: 21 January 2008 Status: Offline Points: 2	Post Options Post Reply Quote kria Report Post Thanks(0) Quote Reply Topic: Strings stored as utf-8 in sql server? 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.)

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

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.