Russian characters are showing up as "???"

[iBar]

I am reading a record from an Oracle database. The Russian names are showing up as "???"

<%
Response.ContentType = "text/html"
Response.AddHeader "Content-Type", "text/html;charset=UTF-8"
Response.CodePage = 65001
Response.CharSet = "UTF-8"

Dim objConn
Dim rs
Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open "dsn=orcldsn; uid=admin; pwd=password"

Set rs = Server.CreateObject("ADODB.Recordset")
sqlstr="SELECT e.username, e.fname, e.lname, e.email eemail, m.username, m.email memail FROM tableName e INNER JOIN tableName m ON e.manager_id=m.id WHERE e.username='K5700MAV';"

Set rs = objConn.Execute (sqlstr)

if rs.eof then
response.write "Username does not exist. Please access this link from a course."
response.end
else
rs.MoveFirst
While Not rs.EOF
e_name = Server.URLencode(rs.fields("fname") & " " & rs.fields("lname"))
e_email = rs.fields("eemail")
response.write e_name
rs.MoveNext
Wend
end if
objConn.Close
Set objConn = Nothing
%>

[iBar]

Enabling the "Force SQL_WCHAR Support" in the Oracle ODBC Driver Configuration fixed the issue.

Thanks

[ariful alam]

First check at Oracle using query that the Russian characters show perfectly or not. if there those characters not show perfectly, than check the field data type is set to Unicode supported or not. if not fix it. moreover if you used oracle query window to add record, those will also show data like ???. use form/server side web page to insert data.

Hope it works.

[iBar]

Hi Ariful,
Thanks. As mentioned in my previous post, this issue is resolved. I had to enable the "Force SQL_WCHAR Support" for the DSN settings.