XML+MySQL+UTF8 = MISERY

[Trevor DeVore]

On Sep 17, 2010, at 1:39 AM, Tereza Snyder wrote:

>   6b I upload the scored survey to a MySQL database on the remote  
> server, first escaping it:
> 	   put revXMLText( gTaxoDataA[gCurrentSlot][kID] ,,true) into tXML
> 	   replace "\" with "\\" in tXML
> 	   replace quote with "\" & quote in tXML
> 	   replace "'" with "\'" in tXML
> 	   replace tab with "\t" in tXML
> 	   replace cr with "\n" in tXML
> 	   put encodeUtf8( tXML ) into tData

What encoding does the column in your MySQL database use? I set the  
default encoding for the DB to UTF-8 and don't have any problems but I  
think you have to do that explicitly.

Regards,

-- 
Trevor DeVore
Blue Mango Learning Systems
www.bluemangolearning.com    -    www.screensteps.com