| Author |
 Topic  |
|
DoraMoon
Average Member
Taiwan
661 Posts |
 Posted - 05 November 2002 : 18:05:43
|
i apply a Free website (on 1ASPhost) for test v3.4 new forum..
see here: http://c.1asphost.com/doramoon/forum/default.asp
(sorry for Pop-up Ad and "turtle" speed and dead often.. no wonder it's Free!  )
coz i try upgrade from v3.3, my original Access db contain a lots Chinese words data.
and when i upload the db to server, ALL content with Chinese words become ???????????
but if i edit/new add a forum/topic with Chinese, it just work fine.
the same problem also occur when i try Brinker before...
so i think it may just Server Language or Access Language problem...
(the free server use English version Win2K, and my db is Chinese version Access.. so....)
maybe no good solution for this. (it's ok for me, it just test site..)
but still wonder if someone know what's real problem about this?
and is it a simple way can solve this?? thx!< |
|
|
David K
Junior Member
494 Posts |
Posted - 05 November 2002 : 18:43:35
|
| I belive it's a server problem< |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 05 November 2002 : 19:42:35
|
it's Access 2000,
but i seem remember when i try Snitz at first time(v3.3.03),
the db including in source zip is Access 97, and i've use my
Access 2K program to convert it to 2K when i try to edit it.
is this something bad influence ??< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Deleted
deleted
4116 Posts |
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 05 November 2002 : 21:12:06
|
thanks, ruirib & bozden
this Unicode/UTF-8 issue really too hard for me, i still can't understand it very well...
and about ruirib's solution... does it mean i need add this
<%@ CodePage=65001 Language="VBScript"%>
<% Session.Codepage =65001
Response.Charset="utf-8"
%>
to the beginning of ALL my .asp file ??
i try to test this..(modify about.asp file then upload it..)
if i add ]<%@ CodePage=65001 Language="VBScript"%>
then the website page show me HTTP 500 error.
(on my PWS, it tell me something "wrong CodePage....")
and if i just add this
<% Session.Codepage =65001
Response.Charset="utf-8"
%>
it seem nothing change...
or i need some tool to "convert" my .asp files to UTF-8 ??
a little screw up by this stuff... maybe take a rest first.. 
thanks again for helping, will try figure out it later...< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 06 November 2002 : 03:32:00
|
quote:
Originally posted by ruirib
PWS, you're running Win98?
i'm working on a Notebook computer now, it's temporarily. i'll plan on settin up a new computer, but not yet do it.
so it's right, my wroking environment now just Win ME with PWS..
but i've remembered updating the MDAC to the lastest version..(v2.7)
and it seem work fine as my demand...
(i have no too much knowledge to server or OS system though..)
< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 November 2002 : 05:45:20
|
Yes, but I think PWS does not support the settings I told you to use. Not sure about about it, but my impression is that you will need IIS to do this.
Anyway you can always use your Web server (1ASpHost) to test this. I suppose that problem was with the host, wasn't it?< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 06 November 2002 : 07:19:47
|
thx, ruirib
i think this problem just as bozden mention, something cause from the Server language/code different with my Access language/code..
and i try to search for more information about "CodePage".. then i found..
it seem a common issue for any case you try to use a Chinese db on a free foreign ASP website. there are also a lots solution articles i can found on my local search engine...
and i just try everyone on my 1ASPhost test site..
# someone say add this <%@LANGUAGE="VBSCRIPT" CODEPAGE=950%> (he said 950=Chinese Big5)
it really "save back" the ????? to correct Chinese character from db. but... some html page with Chinese words(not from db) now become #@%$^*&... strange code.
# someone say add this <%@LANGUAGE="VBSCRIPT" CODEPAGE=1252%> (1252=ANSI)
it return to the same situation as my previous problem.
# and if i try this <%@ CodePage=65001 Language="VBScript"%> (i think 65001=UTF-8 ?)
it give me error when encounter Chinese word like this..
quote:
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/doramoon/forum/default2.asp, line 510
Response.Write "<img src=""icon_folder_noaccess.gif"" alt=""Q?A_zS
--------------------------------------------------------------------^
# and someone say add a config.web file to web root folder.
not work....
# and someone say just convert Access db back to Access 97
a little doubt this... so no test this.
anyway, i think this issue far beyond my ability to deal with..
and everything is ok for me, it's just a test site. i think i wo'nt consider using a Free "turtle" site as my formal website. 
thanks again for helping....< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 06 November 2002 : 08:42:02
|
| I think if you start with a fresh Access 2k file, it will not be a problem. The problem is with the conversion process of Access...< |
 Stop the WAR! |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 06 November 2002 : 09:16:34
|
so can i just use a new blank 2K db from v3.4 snitz package, then just copy/overwrite all data table from my old(97-->2K) 3.4 upgraded Access db ??
it not a big problem for me if start a new db.(it only a little members and posts data..) but if possible, i'd still like to keep those old data anyway.. < |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 06 November 2002 : 09:21:57
|
| We don't have an import tool unfortunatelly, at least I dont know one... Cut-paste of members can work but this will not be the case for other tables because of autonumber fields...< |
Stop the WAR! |
|
|
|
David K
Junior Member
494 Posts |
Posted - 07 November 2002 : 06:27:49
|
I have Win XP and i get the following error:
Microsoft VBScript compilation error '800a0400'
Expected statement
/537437345846853864376/members.asp, line 39
<%@ CodePage=1255 Language="VBScript"
^
this is what i added:
<%@ CodePage=1255 Language="VBScript"%>
<% Session.Codepage =1255
Response.Charset="ISO-8859-8"
%>< |
|
|
|
cocu
Starting Member
8 Posts |
Posted - 07 November 2002 : 16:53:53
|
<%@ CodePage=1255 Language="VBScript"%>
The code about is for .NET! That why you got the error. Remove it!
You don't need add that code to all your asp file, just add the red line to inc_header.asp and give it a try.
<%
Session.Codepage =1255
<!--#include file="inc_func_common.asp"-->
<!--#INCLUDE FILE="inc_func_timezone.asp" -->
<!--#include file="privatemess.asp"-->
<!--#include file="inc_portalsyads.asp"-->
<%
and
Response.Write "<META http-equiv=Content-Type content=""text/html; charset=ISO-8859-8"">" & vbNewline
'## START - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT
Response.Write "<meta name=""copyright"" content=""This Forum code is Copyright (C) 2000-02 Michael Anderson, Pierre Gorissen, Huw Reddick and Richard Kinser, Non-Forum Related code is Copyright (C) " & strCopyright & """>" & vbNewline
'## END - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT
< |
|
|
|
Topic |
|
Forum Locked
