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%>
Ïà¹ØÎĵµ£º
Õ⼸ÌìºÃ¶àÈËÎÊÎÒÈçºÎÔÚasp³ÌÐòÖпØÖÆÉãÏñÍ·È¥×¥ÅÄÕÕÆ¬£¬asp¼¼Êõ»¹ÊÇ99ÄêµÄʱºò¿´¹ýÒ»µãµã£¬Ôç¾Í×ÅÃ×·¹³ÔÁË£¬²»¹ý¼ÈÈ»ÓÐÈËÎÊ£¬ÄǾÍÊÇ¿´µÃÆðÔÛ£¬»¨ÁËÒ»¸öÍíÉϵÄʱ¼ä°Ñasp³ÌÐòµ÷ÓÃÉãÏñÍ·ÅÄÕÕµÄÎÊÌâ¸ã¶¨ÁË£¬ÏּǼÈçÏ£¬ÈÃÓÐÀàËÆÐèÇóµÄͬѧ¿ÉÒÔÉÙ×ßЩÍä·¡£
Óõ½µÄ¼¼Êõ£º
1.asp³ÌÐòÖÐ×÷base64±àÂëºÍ½âÂ룬ʹÓõÄÊÇmsxml×é¼þ£ ......
<?php
$connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("data.mdb");
$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC);
$issuetime=date("Y-m-d H:i:s");
$sql="insert into test values("","",...)";
$result=odbc_exec($connid,$sql);
if($result) echo "successful";
else ec ......
ASPϵÁк¯Êý´óÈ«-ÍøÉÏÊÕ¼¯µÄһЩASPº¯Êý¼°±í´ïʽ
ASPº¯Êý
´óÈ«¡¡
ASPº¯ÊýÓëVBSCRIPTÀàËÆ£¬ÒÔϾÙһЩ³£Óõĺ¯Êý¡¡
¡¡
Array()¡¡
¡¡
º¯Êý·µ»ØÒ»¸öÊý×é¡¡
¡¡
±í´ïʽ Array(list)¡¡
¡¡
ÔÊÐíÊý¾ÝÀàÐÍ: ×Ö·û£¬Êý×Ö¾ù¿É¡¡
¡¡
ʵÀý£º <%¡¡
¡¡
Dim
myArray()¡¡
¡¡
For i = 1 to 7¡¡
¡¡
Redim Preser ......
Adodb.StreamÊÇADOµÄStream¶ÔÏó,Ìṩ´æÈ¡¶þ½øÖÆÊý¾Ý»òÕßÎı¾Á÷,´Ó¶øÊµÏÖ¶ÔÁ÷µÄ¶Á¡¢Ð´ºÍ¹ÜÀíµÈ²Ù×÷.
ÓÐÏÂÁз½·¨£º
Cancel ·½·¨
ʹÓ÷½·¨ÈçÏÂ
Object.Cancel
˵Ã÷£ºÈ¡ÏûÖ´ÐÐ¹ÒÆðµÄÒì²½ Execute »ò Open ·½·¨µÄµ÷Óá£
Close ·½·¨
......
×î½üдվÄÚËÑË÷£¬ËùÒÔÑо¿ÁËÒ»ÏÂËã·¨£¬¸ÃËã·¨µÄÔÀíÈçͼÏÔʾ¡£
ÒÔÏÂÊÇÒ»¸öÓÃaspдµÄ¼òµ¥µÄ·Ö´Ê³ÌÐòÖ÷ÒªµÄ´úÂ룬´Ê¿âÎÒÒѾÓÃaccess½¨Á¢ºÃÁË¡£
Èç¹ûÒª×¢ÖØÐ§ÂÊ£¬MarLenµÄѡȡºÜÊÇÖØÒª£¬·ñÔòЧÂÊ»áÊ®·ÖµÍÏ£¬ÕâÀïMarLenÎÒѡȡµÄÊÇ5¡£
dim faword : faword = ""
do while (len(fword) > 0)
tword = left(fwor ......