Converting HTML entities to Unicode Characters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Converting HTML entities to Unicode...

Converting HTML entities to Unicode Characters

Rate Topic

Display Mode

Topic Options

Author

Message

vijay.singh 14112

Posted Monday, October 29, 2012 7:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 13, 2013 5:31 AM
Points: 149, Visits: 62

Hi Experts,

I am here with another question. I have a string where i have some HTML entities in between string(Please find the HTML entities below). I need to convert that to Unicode Character. Please help me in resolving this problem.

ü
ñ
Í
è
ë
Ó
Ú
á
º
°
ò
í
•
Ñ
‐

–
ó
É
é
ﬂ
…
Á
ú
’
ﬁ

Thanks in Advance.

Regards,

Vijay

Post #1378238

Lowell

Posted Monday, October 29, 2012 7:56 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:24 PM
Points: 11,605, Visits: 27,649

i played with something similar, where i was converting from xml/html entities to the unicode? character char definition.

the problem was i was using a recursive function, and the #of recursion levels is limited to 100, but of course there are more html entities than that that are defined.

because of limitations in the forum, you cannot paste html entities; they get displayed instead, which makes pasting code pointless for issues like this.

take a look at this Inline Table Valued Function i played with a while ago; it does most of what you want.
XML_To_ASCII.txt

(note the array of possible values in the function is the complete list...to get it to work, you need to remove/comment out some of the values so there are only 100 items to replace--much easier to edit and comment out than try to add in something that was missing but you need.)

thinking about it deeper, i think the right thing to do would be to create two or more functions, so each one can do 100 find/replaces, until the whole possible collection of html entities are replaced.

here's a list of all the entities for refernece:
http://www.w3schools.com/tags/ref_entities.asp

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1378254

vijay.singh 14112

Posted Monday, October 29, 2012 8:09 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 13, 2013 5:31 AM
Points: 149, Visits: 62

Thanks a lot Lowell. Smile

Regards,

Vijay

Post #1378262

« Prev Topic | Next Topic »

Permissions