html character to unicode [message #648662] |
Mon, 29 February 2016 01:54 |
mshrkshl
Messages: 247 Registered: September 2006 Location: New Delhi
|
Senior Member |
|
|
convert 100 in thai character to html text like below
หนึ่งร้อยบาทถ้วน
this is opening fine in html as หนึ่งร้อย
now i want to change the same html text into unicode to save the same in database as หนึ่งร้อย
so how to change the html text into unicode ?
what is character set for html text ?
|
|
|
|
Re: html character to unicode [message #648667 is a reply to message #648663] |
Mon, 29 February 2016 03:43 |
mshrkshl
Messages: 247 Registered: September 2006 Location: New Delhi
|
Senior Member |
|
|
have found the help from below linkWITH DATA AS
(SELECT XMLTYPE ('
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
</HEAD>
<BODY>This is for testing that 11>12>13</BODY>
</HTML>') xml_data
FROM dual)
SELECT
EXTRACTVALUE (xml_data, '//BODY') htmltxt
FROM DATA;
htmltxt
------------------------------------------
This is for testing that 11>12>13
http://www.orafaq.com/forum/t/153387/
|
|
|