Problem: The Chinese characters read from the database are all "?"
Solution:
Step 1: Register Code Page to enable SQL Server to support Chinese
1. Copy the file C_936.nls to system32 in the system directory Directory
2. Use Regedit32.exe to add the following keys:
location: HKEY_LOCAL_MACHINEsystemCurrentControlSetControlNlsCode
Page
value name: 936
value: C_936.NLS
location: HKEY_LOCAL_MACHINEsystemCurrentControlSetCont rolNlsLang
uage
value name: 0804
value: l_intl.nls
3. Use Simplified Chinese character set to rebuild the Master database of SQL server
Step 2.
Add a line to the beginning of the ASP program:
<%@ codepage=936 %>
The advantage of this solution is that it does not require the installation of a Chinese platform system and can run NT stably (the English enterprise version is more stable than
)