"\n" appearing in Unicode

[Bob Sneidar]

It's the newline replacement used in SQL, Applescript, others. It is possible that your data is using a combination of CR and LF, it's converting the CR but not the LF. 

Bob S


> On Sep 25, 2016, at 14:15 , Sannyasin Brahmanathaswami <brahma at hindu.org> wrote:
> 
> I have inserted quotes into a MySQL database. I thought I was careful to be sure it was all Unicode encoded.
> 
> We ported the content over SQLite for use in an mobile app.
> 
> I can fetch the quotes and then run
> 
> put textDecode ( aSelectedQuotes[tNo]["content"], UTF8) into sQuote
> 
> 
> 
> Diacritical marks are coming through nicely but endlines are an issue:
> but we are getting this output into the var/field
> 
> His fleet feet dancing\n--
> next line here…. \n
> next line here\n
> next line here
> 
> Anyone know why this might be?
> 
> BR
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode