Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » mod pl/sql and russian (Oracle Database 11g Release 11.2.0.2.0, Windows 2008 R2)
mod pl/sql and russian [message #514332] Mon, 04 July 2011 02:04
JohnHeinrich
Messages: 1
Registered: July 2011
Location: Copenhagen
Junior Member
I'm trying to show russian letters on a web page but i failed

The code:
procedure testRus is
cursor cComp is
select address1
from common.po_company
where id = 4331;
wComp cComp%rowtype;

begin
owa_util.mime_header('text/html',false,'utf-8');
owa_util.http_header_close;
open cComp;
fetch cComp into wComp;
close cComp;

htp.p('<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>');
htp.p(wComp.address1);
htp.p('<br>');
htp.p('ул. Берзарина, д.36, стр.22'); -- address1 copied from table po_company
htp.p('</body></html>');

end;

The address1 field i nvarchar2(500)
The NLS_NCHAR_CHARACTERSET is AL16UTF16
The NLS_CHARACTERSET is WE8MSWIN1252

The result is ¿¿. ¿¿¿¿¿¿¿¿¿, ¿.36, ¿¿¿.22
Previous Topic: Updatable views
Next Topic: Mod_plsql upload size restriction
Goto Forum:
  


Current Time: Mon Jun 01 23:31:16 CDT 2020