Read and Display Chinese Characters

seemun · July 20th, 2004, 08:07 PM

Hi,

I use asp to develop a web page to read an excel file containing Chinese Character then display it in the web page. Unfortunately, I cant display it!!! it will display (?????????). Thx.-

happygv · July 21st, 2004, 02:19 AM

Use this within <HEAD></HEAD> tags of you page

Code:

<META HTTP-EQUIV="content-type" CONTENT="text/html; charset=charset_name">

where charset_name can be gb2312 or big5 or utf-8.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

seemun · July 21st, 2004, 09:16 PM

hi,

it doesnt work.
here are the codes:

' create and open the connection to the Excel file
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER=Microsoft Excel Driver (*.xls);" & "DBQ=" & Server.MapPath("uploadfolder/" & NewFileName)

Set RS = conn.Execute("Select * From [Customer_Group]")

'response.write connection
con.open connection
' Create recordset and retrieve values using the open connection
Set objRS = server.CreateObject("ADODB.Recordset")

%>
<TABLE Border=1 CellPadding=3>
<TR class=TRAlternate1>
<% For f = 0 To RS.Fields.Count-1%>
<TH>
<%= RS.Fields(f).value%></TH>

when i tried to display is using "RS.Fields(f).value", i only can c ???? so, I think the problem is can even get/read the chinese character from the excel file. Pls help me. :)

happygv · July 21st, 2004, 11:37 PM

Did you try my suggestion? Was that code added in the HEAD tags and still doesn't help?

_________________________
- Vijay G
Strive for Perfection

seemun · July 22nd, 2004, 12:07 AM

Yes, i tried ur suggestion by putting it in the HEAD tags and it just doesnt work... Any other suggestion. Thanks

AFei · July 27th, 2004, 01:55 AM

Simplified Chinese:

Code:

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

Traditional Chinese:

Code:

<meta http-equiv="Content-Type" content="text/html; charset=big5">

happygv · July 27th, 2004, 01:51 PM

This is the same I suggested in one of my posts. But seems it didn't solve the purpose. Not sure if the original poster is missing something there.

_________________________
- Vijay G
Strive for Perfection