SQL query is related to encoding.

SQL query is related to encoding.

In the last two days, we found that the query statement has a relationship with the encoding.

SQL = "select * from user where sex = 'Lady 'and datediff ('D', regtime, #" & currentuserregdate & "#) = 0"

The corresponding encoding must be

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

Previously, the <meta http-equiv = "Content-Type" content = "text/html; charset = UTF-8"/>

Therefore, it is concluded that the key subquery must use gb2312 encoding for Chinese characters.

Avoid keyword Query

Strconn = "provider = Microsoft. Jet. oledb.4.0; Data Source =" & server. mappath ("databases/DTA. mdb ")
Set conn = server. Createobject ("ADODB. Connection ")
Conn. Open strconn

SQL = "select * From productprice where language = '" & Language & "'order by serverstatus, servername, fractionname"

If jet4.0 is used as the driver of the earlier version, the driver of the earlier version is often disconnected.