I'm writting a little HTMLDecode function (which I'll share on here), and so far it's working pretty nice. However, it would greatly simplifiy my life if I could get characters from the extended HTML character sets into a char(), or if someone can help me see another way.For instance, given the escaped character – (charset 8879), I need to get an n-dash (-). Now, I can manually do this for every one of the common cahrset 8879 characters (and also the charset 10646 characters, which are 3 digits and always above 255). But that's ugly. Here's how I'm doing it for "normal" ascii characters now, which is far better than having a million "replace" functions:select @siPos=PatIndex('%&#___;%',@vcResult)WHILE @siPos>0 BEGIN select @vcEncoded=substring(@vcResult,@siPos,6) select @siChar=cast(substring(@vcEncoded,3,3) as smallint) if @siChar<255 select @vcResult=replace(@vcResult,@vcEncoded,char(@siChar)) else -- This is where we need to handle ISO 10646 select @vcResult=replace(@vcResult,@vcEncoded,'') select @siPos=PatIndex('%&#___;%',@vcResult) ENDIs it possible to get a character from another charset?Thanks-b 
Getting char() from a different character set?
Posted - 2002-10-15 : 13:17:36
