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%>
Ïà¹ØÎĵµ£º
¡¡¡¡Ñ§Ï°Ä¿µÄ£ºÑ§»áÓÃ±íµ¥ÔªËØÏò·þÎñÆ÷´«ËͱäÁ¿£¬È»ºóÏÔʾ±äÁ¿ÔÚ¿Í»§¶ËµÄä¯ÀÀÆ÷¡£
¡¡¡¡Ê×ÏÈ£¬ÈÃÎÒÃÇÀ´¿´Ò»ÏÂDREAMWEAVERµÄ±íµ¥ÔªËØÃ«Ë¢¡£
¡¡¡¡ÏÂÃæÎÒÃÇÀ´Ò»¸öÒ»¸ö¿´±íµ¥ÔªËØ¡£1¡¢Îı¾Óò£¬Õâ¸öÊÇ×î»ù±¾µÄ£¬´«Ë͵ÄÊÇÎı¾ÐÅÏ¢£¬Ò»°ãÓû§Ãû£¬ÃÜÂë¶¼ÒªÓÃÕâ¸ö´«ËÍ£¬²»¹ýÒªÊÇÃÜÂëµÄ»°ÒªÔÚÀàÐÍÀïÃæÑ¡ÔñÃÜÂ룬ÕâÑù¾Í»áÒÔ*´úÌæÏÔʾ³ ......
Ìí¼Ó¡¢É¾³ý¡¢ÐÞ¸ÄʹÓÃ
db.Execute(Sql)ÃüÁîÖ´ÐвÙ×÷
╔----------------╗
¡î Êý¾Ý¼Ç¼ɸѡ ¡î
╚----------------╝
×¢Ò⣺µ¥Ë«ÒýºÅµÄÓ÷¨¿ÉÄÜÓÐÎó(ûÓвâʽ)
Sql = "Select
Distinct
×Ö¶ÎÃû from Êý¾Ý±í"
Distinctº¯Êý£¬²éѯÊý¾Ý¿â´æ±íÄÚ²»Öظ´µÄ¼Ç¼
......
ASPϵÁк¯Êý´óÈ«-ÍøÉÏÊÕ¼¯µÄһЩASPº¯Êý¼°±í´ïʽ
ASPº¯Êý
´óÈ«¡¡
ASPº¯ÊýÓëVBSCRIPTÀàËÆ£¬ÒÔϾÙһЩ³£Óõĺ¯Êý¡¡
¡¡
Array()¡¡
¡¡
º¯Êý·µ»ØÒ»¸öÊý×é¡¡
¡¡
±í´ïʽ Array(list)¡¡
¡¡
ÔÊÐíÊý¾ÝÀàÐÍ: ×Ö·û£¬Êý×Ö¾ù¿É¡¡
¡¡
ʵÀý£º <%¡¡
¡¡
Dim
myArray()¡¡
¡¡
For i = 1 to 7¡¡
¡¡
Redim Preser ......
Dim FilePath,FileName
Set ObjFileStream = Server.CreateObject("ADODB.Stream")
ObjFileStream.Type = 1
ObjFileStream.Mode = 3
ObjFileStream.open
ObjFileStream.LoadfromFile FilePath&"\"&FileName&".doc"
ObjFileStream.Position = 0
response.binarywrite  ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚ Transact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERV ......