This topic is locked

Regional setting problem.

3/13/2007 2:52:43 PM
ASPRunnerPro General questions
S
srlsir author

Dear Sirs,
I want to build an access db. My problem is that my db has text field in 3 different languages (English, Turkish, and Greek).
In the step 10 of 12 in ASP Runner I have to choose the language (regional settings). When I'm choosing Greek I can not view Turkish text & when I'm choosing Turkish I can not view Greek text.
Is there any way to help me fixing the above problem?
Thank you in advance.
Vasilis Dimitrakas
Athens

Greece

J
Jane 3/14/2007

Vasilis,
try to do the following:

  • build your project
  • open generated include/dbcommon.asp file
  • fine thie line:
    Charset = ...

and replace it with this one:

Charset = "utf-8"


  • then find following line:
    session.codepage=...

and replace it with this one:

session.codepage=65001

S
srlsir author 3/14/2007

Jane,

I can not found inside include the page dbcommon.asp.

But i can see page <commonfunctions.asp>. Is that ok?

J
Jane 3/14/2007

What version of ASPRunnerPro do you use?

S
srlsir author 3/14/2007

ASP RUNNER 4.0 (BUILD 97)

J
Jane 3/14/2007

You need to edit include/commonfunctions.asp file in this case.

S
srlsir author 3/14/2007

My problem doesn't solve. When I open the edit page, I can view text ok (in all language). But when I'm trying to write some new text and click the save button, then I can't see either Greek or Turkish text correctly. The only text that is correct is the English text.
Something else that I can try?

Sergey Kornilov admin 3/14/2007

I would suggest to upgrade to ASPRunnerPro 4.1, rebuild the project and apply Jane's fix.
If you still have problem with Greek/Turkish charaters after that publish your app to Demo Account and send me a link.

S
srlsir author 3/15/2007

Dear Jane or Sergey,
Below is the starting code of the include/dbcommon.asp page:
<%
cCharset = "utf-8"
response.AddHeader "Content-type", "text/html;charset=" & cCharset
dDebug=false
Session.LCID = 1055

session.codepage=65001
dSQL=""
Set tables_data = CreateObject("Scripting.Dictionary")
%>
I have the changes that you have told me. (utf-8) & (65001).

What about <Session.LCID = 1055>??? Is that ok? What means 1055??
Please help me because I have still problem.
I will tell you something if this can help you:

With the above combination (utf-8) & (65001) the problem is the following:
Any static text is already written in a page is OK (in both Greek or/& Turkish).

But any dynamic text (coming from the data base) still have problem in one of the 2 languages!!!
With my poor knowledge my mind goes only in <Session.LCID = 1055>. Is that important? Do I have possibilities to fix my problem if I change 1055 with somethimk else?
Please help me!! I'm desperate!
Vasilis

Athens - Greece

A
agmoraojr 3/17/2007

hello there to everybody,
I have a problem related to srlsir too, I cannot display the arabic characters, what should I modify? what charset should I use.
Thank you,

M
mazyad 3/21/2007

I also have the same problem with Arabic Characters presentation. Arabic text retrieved from the database is presented well, however, the text generated by Smarty is Scambled characters. I hope this is investigated because in the past (Version 4.0) we define the code page as follow <%@Language=Vbscript Codepage=1256%> and every thing is smooth thereafter. In version 4.1 build 225 this is not working and changing the charset/session.codepage/Session.LCID .. etc in every possible way did not fix the problem.
Sincerely,

Abdulrahman

Saudi Arabia

M
mazyad 4/3/2007

First I'm grateful for the level of support we continue to obtain. The Smarty Attachement I received from support@xlinesoft.com solved the Arabic language problem as long as I use Arabic only (not mix with english/hebrew for multilingual site). I indeed appreciate the propmt replay and accurate solution for now.
Sincerely,

Abdulrahman

Saudi Arabia