- Home /
SQLite, quotation marks and GPX files
Hi!
I'm trying to write a text content of a GPX file into a SQLite table field. I donwload the file with
IEnumerator DownLoadGPXFile(string GPXFileName) {
WWW w = new WWW(GPXFileName);
yield return w.text;
}
and the content of the GPX file downloaded is ok, but when I try to update SQLite DB with INSERT INTO whit this GPX text I get, obviously, an error because of quotation marks in GPX file.
Someone could help me?
Many thanks!
Gius
I don't know the interface you're using to access SQLite, but usually there a "escapeString" method or similar that changes the string so it can be put into the database.
Thank you Double$$anonymous$$ax, I'm writing the query directly by code in $$anonymous$$onoDevelop;
System.Text.RegularExpressions.Regex.Unescape(stringToUnescape)
doesn't solve the problem...
$$anonymous$$
Your answer
![](https://koobas.hobune.stream/wayback/20220612094528im_/https://answers.unity.com/themes/thub/images/avi.jpg)
Follow this Question
Related Questions
Changing GUITEXT Value... 0 Answers
How to display *.txt file on the cube model? 2 Answers
Highscores in text file 0 Answers
ProjectSettings.txt is corrupt 1 Answer
retrieving data from SQLite to UNITY 1 Answer