I made a misstake and wrote one line wrong of your simple testing code. The line in your example was:
query = """CREATE TABLE HighScores (id INTEGER PRIMARY KEY, name VARCHAR(100), score INTEGER)"""

But i wrote:
query = """CREATE TABLE HighScores (id INTEGER PRIMARY KEY, name text(100), score INTEGER)"""
And it look likes the database works fine..? So it is possible to use sqlite3 data types to?