asp access utf ÖÐÎÄ ÂÒÂëÔõô°ì
asp ÖÐÎÄÂÒÂë,asp access ÂÒÂë,asp ˢкóÂÒÂë,asp utf 8ÂÒÂë,ajax ÂÒÂë asp,asp ºº×ÖÂÒÂë,aspÂÒÂëÔõô°ì
ÓÃutf-8±àÂëÓÃÔÚеÄÍøÕ¾ÉÏ£¬²»ÏëÎÊÌâ»¹Õæ¶à£¬ËùÒÔÕÒÁËЩÎÄÕ£¬Ìû×Ó£¬¿´ÁË¿´£¬µÈÏÂÓÐÓõľÍÌùÏÂÃæÁË¡£
½ñÌ죬ÎÒ¿ªÊ¼°Ñ CODEPAGE="936" ¸Ä³É CODEPAGE="65001"
°Ñcharset=gb2312¸Ä³É charset=utf-8
¿ÉÊÇ»¹ÊÇÂÒÂ룬ֻҪÊǽű¾Óõĵط½»¹ÊÇÂÒÂ룬ÏÖÔÚÖÕÓÚÕÒµ½ÎÊÌâÁË£¬¾ÍÊǵ±½Å±¾Êä³öʱºò£¬ÒªÒÔutf-8±àÂëÊä³ö¡£
¾ÍÊÇÒª¼ÓÒ»¾ä<% Response.Charset = "utf-8" %>
¢ÙÊ×Ïȵ±È»ÊÇÒ³Ãæ±¾ÉíÓÃutf-8±àÂ룬ÔÚDWн¨Ò³Ê±Ä¬ÈϱàÂ붨Ϊ“Unicode(UTF-8)”
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001" %>
' ¢ÚCODEPAGE="65001" ¸æËß·þÎñÆ÷Ò³ÃæÊ¹ÓÃUTF-8±àÂëµÄ
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
' ¢Ûcharset=utf-8¸æËßä¯ÀÀÆ÷Ò³ÃæÊ¹ÓÃUTF-8±àÂëµÄ
</head>
<body>
<% Response.Charset = "utf-8" %>
' ¢Ü·þÎñÆ÷Êä³ö±àÂëΪutf-8
</body>
</html>
ˢкóÓÖ±ä³ÉÂÒÂ룬»òÕßä¯ÀÀÆäËûµÄgb2312µÄÒ³Ãæ»ØÀ´ÓÖÂÒÂëÁË¡£ÖµµÃÓÖÈ¥googleÁËһϣ¬ºÇºÇ£¬»¹ÊÇÕÒµ½´ð°¸ÁË
¿´¿´ÏÂÃæµÄÎÄ×Ö£¬¾ÍÖªµÀÁË£¬ËùÓÐÔÚºóÀ´ÎÒ¼ÓÁËÕâ¸ö£¬³ÌÐò¶¥¶Ë
<%Session.CodePage=65001%>
<%@ codepage=936%>¼òÌåÖÐÎÄ
<%@ codepage=950%>·±ÌåÖÐÎÄ
<%@ codepage=65001%>UTF-8
codepageÖ¸¶¨ÁËIIS°´Ê²Ã´±àÂë¶ÁÈ¡´«µÝ¹ýÀ´µÄ´®´®£¨±íµ¥Ìá½»£¬µØÖ·À¸´«µÝµÈ£©¡£
³öÂÒÂëµÄÔÒòÒ²¾ÍÊÇÍøÕ¾ÒªÕûºÏµÄʱºòÄ£¿é±àÂë²»Ò»ÑùÒýÆðµÄ¡£
²»Òª×ª»»ÈκÎÄ£¿éÍøÒ³µÄ±àÂë¸Ãutf-8µÄ»¹ÊÇutf-8£¬¸ÃGb22312µÄ»¹ÊÇGb2312
½«GB2312Ä£¿éµÄconn.aspÎļþÖмÓÈëÁËÒÔÏÂÕâ¶Î´úÂë
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%Session.CodePage=936%>
Ò»ÇÐOK!
ͬÑùÔÚÔÚUtf-8Ä£¿éµÄ°üÎļþ£¨Èçconn.asp£¬µ«ÊÇҪעÒâconn.asp±ØÐëÊÇÔÚµÚÒ»Ðе÷Óã©×îÇ°Ãæ¼ÓÉÏ
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%Session.CodePage=65001%>
Õ⼸Ììд¶«Î÷ʱ×ÜÊÇÓöµ½ÂÒÂ룬ÓôÃÆ£¬ÒÔǰ´ÓÀ´Ã»Ñо¿¹ý±àÂ룬ֻÊÇÄùýÓï¾äÖ±½ÓÓã¡ÏÂÎç¾¹ýÑо¿ºóÎҵóöÒÔϽáÂÛ£¡
Ê×ÏÈ£¬Ñ¡Ôñ±àÂ룺Äã±ØÐë°´ÕÕÄãÒ³ÃæµÄÄÚÈÝÑ¡Ôñ±àÂ룬²»¹ý½¨Òéǰ̨ºǫ́¶¼Ê¹ÓÃutf-8±àÂ룬·½·¨ÊÇÔÚconn.aspÖмÓÈ룺
ÒýÓÃ
<%@ CODEPAGE=65001 %>
<% Response.CodePage=65001%>
Ïà¹ØÎĵµ£º
<%
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from 0791idc_News where BigClassName='¼Ò×°¿ÎÌÃ' order by ID desc"
rs.Open sql,Conn,1,1
if rs.eof and rs.bof then
response.Write("ÔÝʱûÓмǼ")
else
%>
......
¡¡¡¡Ñ§Ï°Ä¿µÄ£ºÑ§»áÓÃ±íµ¥ÔªËØÏò·þÎñÆ÷´«ËͱäÁ¿£¬È»ºóÏÔʾ±äÁ¿ÔÚ¿Í»§¶ËµÄä¯ÀÀÆ÷¡£
¡¡¡¡Ê×ÏÈ£¬ÈÃÎÒÃÇÀ´¿´Ò»ÏÂDREAMWEAVERµÄ±íµ¥ÔªËØÃ«Ë¢¡£
¡¡¡¡ÏÂÃæÎÒÃÇÀ´Ò»¸öÒ»¸ö¿´±íµ¥ÔªËØ¡£1¡¢Îı¾Óò£¬Õâ¸öÊÇ×î»ù±¾µÄ£¬´«Ë͵ÄÊÇÎı¾ÐÅÏ¢£¬Ò»°ãÓû§Ãû£¬ÃÜÂë¶¼ÒªÓÃÕâ¸ö´«ËÍ£¬²»¹ýÒªÊÇÃÜÂëµÄ»°ÒªÔÚÀàÐÍÀïÃæÑ¡ÔñÃÜÂ룬ÕâÑù¾Í»áÒÔ*´úÌæÏÔʾ³ ......
1.Á¬½ÓAccessµÄÁ¬½Ó×Ö·û´®
string strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @FileName;
2.Á¬½ÓExcel
string strExcel = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + @FileName + ";Extended Properties=Excel 8.0;"; ......
<%Dim connstrconnstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Stu.mdb")
Set bb = Server.CreateObject("ADODB.Connection")
bb.Open connstr%>
<html>
<head>
<meta http-equiv="content-Language" content="zh-cn" />
<meta http-equiv="Content-Type ......