| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
