468,510 Members | 1,733 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,510 developers. It's quick & easy.

Russian characters are showing up as "???"

3
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
%>
Aug 1 '12 #1

✓ answered by iBar

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

Thanks

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

Thanks
Aug 1 '12 #2
ariful alam
185 100+
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.
Aug 2 '12 #3
iBar
3
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.
Aug 2 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Ross Noe via .NET 247 | last post: by
2 posts views Thread by Victor | last post: by
6 posts views Thread by Victor | last post: by
2 posts views Thread by Victor | last post: by
1 post views Thread by manchin2 | last post: by
1 post views Thread by kersti | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.