bignum unicode entities in htmlText?

[viktoras d.]

Thanks Devin, Richmond for even more hints!

Now I have my script almost working, it has to display both unicode and 
non-unicode in the same field, so I did this:

set the useUnicode to true
   set the itemdelimiter to "&"
 
   repeat for each item myItem in myInText
      if ";" is the last char in myItem and "#" is the first char in 
myItem then
         put numtochar(char 2 to -2 of myItem) after myOutText
      else
         repeat for each char myChar in myItem
            put myChar & null after myOutText
         end repeat       
      end if
   end repeat  
set the unicodeText of fld "f1" to myOutText  

unfortunately it still leaves the last unicode entity undecoded in each 
unicode string, besides I would need special formatting of the output, 
so I will definitely need to think more :-).

Devin, the database is not mine (it belongs to the species2000 project), 
so I can not change anything what's inside, only try to display its 
contents. Now I wonder if MySQL itself has any function to do the 
decoding of these html entities in SELECT statement...

Richmond, I still have Revolution 2.6 besides the 3.5, so I haven't 
burnt all bridges to the old revonline repositories yet. Nice example, 
btw. cool graphical background (where from (url) ?)!

All the best and thanks again for your help!
Viktoras

Richmond Mathewson wrote:
> People who have no access to the old version of revOnline and don't 
> want to
> write to me can download CKBD.rev.zip  (Chinese Typewriter) after 
> joining the
> RRText Tricks  Yahoo Group at:
>
> http://groups.yahoo.com/group/rrtexttricks/?yguid=254544547
>
> Devin Asay wrote:
>>
>> On Jun 12, 2009, at 2:31 PM, viktoras d. wrote:
>>
>>> sorry if I missed a possible hint in any of the previous threads on
>>> unicode. I am having trouble making Revolution correctly display bignum
>>> unicode entities like unicode characters of Mandarin Chinese. In mysql
>>> database all the unicode strings are encoded with leading ampersand and
>>> trailing semicolon like this: 西方黃黝魚
>>> These get correctly rendered in any web browser, but Revolution 
>>> fails to
>>> display them correctly in a field (I am seting htmltext of field).
>>>
>>> Is there any way to fix this?
>>
>> Viktoras,
>>
>> I'm jumping in here late, but wanted to add, when you save your 
>> HTMLtext with Chinese characters, you need to make sure than all of 
>> the font tags are saved with it. It seems that when you're using 
>> Unicode embedded in HTML you also have to tell Rev exactly what font 
>> and language to use to display it. It ends up coming out something 
>> like this:
>>
>> <p><font face="Kai" size="16" 
>> lang="zh-CN">您离开讲国</font></p>
>>
>> The font face attribute will of course determine the exact font, 
>> therefore the look of the characters. Make sure it's a font that you 
>> can reasonably assume will be on the target computer. The font lang 
>> attribute determines which variant of Chinese you use, Simplified 
>> (mainland) or Traditional (Taiwan primarily). For Simplified use 
>> lang="zh-CN". For Traditional use lang="zh-TW". Note that Simplified 
>> and Traditional Chinese fonts are not interchangeable. There are 
>> Traditional font faces and Simplified font faces.
>>
>> By the way, here's how to get a list of Simplified vs. Traditional 
>> fonts on your computer:
>>
>>    put the fontNames into tfonts
>>    repeat for each line tFont in tfonts
>>       if the fontLanguage of tFont is "SimpleChinese" then
>>       -- or use this test to find Trad.
>>       -- if the fontLanguage of tFont is "Chinese" then
>>          put tFont & cr after tList
>>       end if
>>    end repeat
>>
>> Having said all that, it might be better in the long run to store 
>> your Chinese text in your database as UTF-8. To do so, just put your 
>> unicode text into a variable and upload it to a database:
>>
>>   put unidecode(the unicodeText of fld "MyUniFld","UTF8") into myVar
>>   ## store the contents of myVar in the database
>>
>> Then when you are retrieving it, you reverse the process. (You have 
>> to make sure that the textFont for the destination field is set to a 
>> unicode-compatible font first. Usually if you just put it back into 
>> the field you got it from it's fine.)
>>
>>   set the unicodeText of fld "myUniFld" to 
>> uniencode(myDataFromDB,"UTF8")
>>
>> As I've said before, Unicode and Rev play together fairly nicely if 
>> you understand some basic concepts and know Rev's quirks. See my 
>> article at http://revolution.byu.edu/unicode/unicodeInRev.php for 
>> more details.
>>
>> Regards,
>>
>> Devin
>>
>> Devin Asay
>> Humanities Technology and Research Support Center
>> Brigham Young University
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your 
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>