Unicode & Database

[Al-Qaim]

it only matter with following two lines:

<% @ codepage=65001 %>
and
OpenSchema

This is ASP vbscript

Here is the Code:

<% @ codepage=65001 %>
<%
Dim  f
Response.CharSet = "utf-8"
	Set cnnDB = CreateObject("ADODB.Connection")
	
	strDBPath=server.MapPath ("TntjKuwait.mdb")
	
	With cnnDB 
	   .Provider = "Microsoft.Jet.OLEDB.4.0" 
	   .Open strDBPath 
	End With


	Set rstList = cnnDB.OpenSchema(4)
	Set rstList = cnnDB.Execute("SELECT * FROM tblfirst")
	Set f = rstList(1)
	Do Until rstList.EOF
		Response.Write f
		Response.Write "<BR>"
		rstList.MoveNext
	Loop
	
	rstList.Close
	cnnDB.Close
%>

I included 4 different language (Arabic, Persian,Urdu & tamil )strings in Database field to check Unicode functionality.

Al-Qaim