Web Wiz Forums - language encoding problems

Print Page | Close Window

language encoding problems

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=21719
Printed Date: 08 April 2026 at 7:09pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: language encoding problems

Posted By: edesigner
Subject: language encoding problems
Date Posted: 25 October 2006 at 2:07pm

Hi all,

My forum language is in greek.

I have language problems because I move MSSQL db from a local to foreign. Local has default language greek but the new one has english and I solve the problem partialy by putting the string <% @ Language=VBScript codepage=1253%> at the top of the page, also language package displays the greek characters right with this mod.

After this I had problem only with "text" type fields that is the main body of the messages. The displayed characters is like "??st???? ?p?? ?ata?a?a??? ?a? f?t??".

I tried to add the following code to the db's connection string "Auto Translate=False;" and now the characters is like "Aoooo??o u?uo eaoaeaaa?iu " (I thought something better done!)

I remove the <% @ Language=VBScript codepage=1253%> string and the main massage body displays greeks OK but the other fields like the name of the forum, title etc displays again ""??st???? ?p?? ?ata?a?".

Seems to not exists one middle way, I'm confused.

Please help
Chris

Replies:

Posted By: WebWiz-Bruce
Date Posted: 25 October 2006 at 4:08pm

Have you tried editing the includes/browser_page_encoding.asp and setting the correct page encoding for the language you are using?

Also try your web hosts as they may have some suggestions.

-------------
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: edesigner
Date Posted: 25 October 2006 at 4:53pm

Yes sure I try this.

But I think that will be a general problem with dbs with different contents languages than the server's default... Noone has it ever resolve?

The problem is that nvachar fields doesn't display right the character sets.

Regards

Chris

Posted By: WebWiz-Bruce
Date Posted: 25 October 2006 at 6:14pm

It maybe that your web host needs to install support for your character set on the actual server so that the SQL server can store your characters correctly.

-------------
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: edesigner
Date Posted: 26 October 2006 at 9:25am

Thanks borg,

I found that changing the field types from nvarchar to varchar the problem resolved but I wonder if this makes incombatibilities for later versions...

One other problem that I have is that I can't post/edit messages in my languages.

Any suggestion?

Chris

Posted By: WebWiz-Bruce
Date Posted: 26 October 2006 at 9:31am

Changing from nvarchar to varchar shouldn't make any difference to the running of the software.

Your edit issue could be that you need to get the browser_page_encoding.asp file set to the correct page encoding for your character set so that the browser sends the correct data to the server.

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