What I’m doing is capturing input from a TextEditor and converting it into a const char* which is then inserted into a mysql database with it’s library functions. However I am struggling to get it to hold certain characters.
For example, someone types in and is stored as a String called inputString:
Then the program places it into an INSERT sql statement, and finally the String is converted to a const char*:
Something goes wrong somewhere, because the above info really does not ever get placed into the database. I presume it’s struggling with the pound and euro symbols.
What exactly is going on? Any one have any work arounds? Do I need to escape the special characters? If so, can I suggest a getEscapedString() function for the String class.
Thanks for the help.