I'd developed some asp-pages that reads data from Acces'97 database.
All works well, but when I copied asp-files and database to hosting serve
r
all national characters (Cyrillic) converted incorrectly
For example:
"Anec Au ala ka easaccnnscsiaaku, lsi?ncna Lsaacea c ealiekcna Akzano"
instead of:
"=C5=F1=EB=E8 =C2=FB =E5=F9=E5 =ED=E5 =E7=E0=F0=E5=E3=E8=F1=F2=F0=E8=F0=EE
=E2=E0=ED=FB, =EF=F0=EE=F7=F2=E8=F2=E5 =CF=F0=E0=E2=E8=EB=E0 =E8 =E7=E0=EF
=EE=EB=ED=E8=F2=E5 =C0=ED=EA=E5=F2=F3"
but it is not browser problem, I got the same wrong characters when I
open page in Source View mode.
I got that something differ with Default Locale.
I set tried to use
Session.CodePage=3D1251
but this didn't worked out
when I appened
<%@ CODEPAGE =3D 1251%>
to my asp-script hardcoded russian text became normal,
but all datas I read from Access ('97) database using ADO are still
looks invalid
the following code is used to connect to database:
Set conn =3D Server.CreateObject("ADODB.Connection")
conn.Provider =3D "Microsoft.Jet.OLEDB.4.0; Data
Source=3DC:\users\!webs\web174\Data\BO.mdb"
conn.Open
setting conn.Properties("Locale Identifier")=3D1049 (instead of 1062 -
that was default at hosting server)
also didn't help
the structure of my asp-pages is
---- set code pade used to write asp-script
<%@ CODEPAGE =3D 1251%>
---- buffering is on
<%Response.Buffer =3D True%>
----- include some libraries with functions to read datas from database;
there is also some #include in first onr included
<!-- #include virtual=3D/ListLv/Actions/Routine/register.asp -->
<!-- #include virtual=3D/ListLv/Actions/ASP_LIB/reports.asp -->
<!-- #include virtual=3D/ListLv/Actions/ASP_LIB/events.asp -->
<!-- #include virtual=3D/ListLv/Actions/Advanced/dbscript.asp -->
----- code to process request
<%
Dim nEvent, sFormRequested, sNavigator
sNavigator=3DRegist_Request() 'regists page request in database
=2E.....
=2E. some code here
=2E.....
%>
---- now formatting output
<HTML>
<%
Call Gen_PageHeader("Primary", sTitle)
Response.Write "<BODY " & Get_PageStyle(DBLookUp("Style", "i_Pages",
"Name=3D'" & sFormRequested & "'")) & ">"
----- call function to generate output with data from database
Call GenForm(sFormRequested, sFilter, "")
%>
</BODY>
</HTML>
<%
Response.End
%>
Once more: everything is OK on my local PC with WIN2k-Pro
but it works incorrectly on my hoster server