Sorry to reopen an old thread, but I’m still having issues with this. Obviously I’m running my strings through sql.SQLStr(string) but it doesn’t seem to have any effect. If I enter a string such as “don’t” it causes an SQL syntax error due to the apostrophe.
I gave it a shot using string.Explode and then string.Implode with ’ as the separator to remove it from the string but now the ’ is showing up twice? (Like: “don’'t”). These strings are being inserted into a table that I’m saving as a table-to-json into SQL, at the moment (aside from punctuation causing issues) it works well and I’d like to preserve that functionality.
I’ve also done a search and can’t find any information at all about how lua handles punctuation within strings (i’m not talking about for use with SQL here). Does it change punctuation entered into DTextEntries at all or is everything preserved?