Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - language encoding problems
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

language encoding problems

 Post Reply Post Reply
Author
edesigner View Drop Down
Newbie
Newbie


Joined: 30 September 2006
Location: Greece
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote edesigner Quote  Post ReplyReply Direct Link To This Post Topic: language encoding problems
    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
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: 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.
Back to Top
edesigner View Drop Down
Newbie
Newbie


Joined: 30 September 2006
Location: Greece
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote edesigner Quote  Post ReplyReply Direct Link To This Post 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
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: 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.
Back to Top
edesigner View Drop Down
Newbie
Newbie


Joined: 30 September 2006
Location: Greece
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote edesigner Quote  Post ReplyReply Direct Link To This Post 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
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: 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.
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.