LiveCode Forums.

<RF> tags in db could be request filter stored procedures.
To strip those there will be a one-liner replacetext regex. I am out using phone atm, otherwise I would play and test but it should be easy to eliminate stuff between the tags.


Would love to see that being used...

I will have to use ...

This sounds like a Unicode problem.

try this on the result returned from the db query (textReturned)

put textDecode(textReturned,"UTF8") into textReturned


Very kind!

This is what I did, it worked but is that okay?
put databaseGetContactDetails() into textReturned
put textDecode ...

know of any tutorial that can lead me on this?

:(

Honestly, I am trying to wrap my head around lc.

So what I am working on is a Bible program to use as a tool for research im doing.

I am using different versions and some of the databases include characters which look horribly formatted in LiveCode but the SQL browser displays it right.

And ...

:cry: So here i am, trying my first SQLite app. I am writing a reader for existing databases. I am using the sample to guide me through the syntax.

I got it to open the database but when it imports the database it makes a mess of the text when ever it finds an accent or any character that is ...