Solution of garbled problem when ASP reads SQL data

If you are doing the site, can not execute the SQL statement correctly, after response, found in the SQL statement inside the text section has become garbled, you can use the following method to resolve:

<%@ codepage=936%>简体中文
<%@ codepage=950%>繁体中文
<%@ codepage=65001%>UTF-8

CODEPAGE specifies what IIS encodes to read the string passed over (form submission, address bar delivery, etc.).

The reason for the garbled is that the site should be integrated when the module code is not the same cause.

The most convenient methods are as follows:

Do not convert any module page encoding the Utf-8 or utf-8, the Gb22312 or Gb2312.

In the Utf-8 module of the package file (such as conn.asp, but note that conn.asp must be called in the first line), add the front:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%Session.CodePage=65001%>

At the top of the package file for the GB2312 module, add:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%Session.CodePage=936%>