Is there a datatype in SQlite that supports both String and Numerical values? I’ve tried many different datatypes with no success, this includes BLOB,CHAR,VARCHAR,TEXT,INT, ect.
Example Text: “360Spyder”
sql.Query(“ALTER TABLE RP_Cars ADD “…Name…” TEXT)”)
Upon using this function with “360Spyder” I receive the following error.
"unrecognized token: 360Spyder"
I’ve tinkered with this and have come to the conclusion that numerals are causing the error, when I use “Spyder” or any other string that doesn’t include a numerical value it works fine.