Re: "\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  
> 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@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: "\n" appearing in Unicode

[AndyP]

Have a look at this post..it may help.

http://forums.livecode.com/viewtopic.php?f=12=27797=145730=converting+mysql+to+sqlite#p145730
<http://forums.livecode.com/viewtopic.php?f=12=27797=145730=converting+mysql+to+sqlite#p145730>
  





-
Andy Piddock 


My software never has bugs. It just develops random features. 

Copy the new cloud space, get your free 15GB space now:
Get Copy 


Script editor Themer for LC http://2108.co.uk  

PointandSee is a FREE simple but full featured under cursor colour picker / 
finder.
http://www.pointandsee.co.uk  - made with LiveCode
--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/n-appearing-in-Unicode-tp4708916p4708921.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

"\n" appearing in Unicode

[Sannyasin Brahmanathaswami]

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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode