28.10.2017, 14:20
Because you don't create that table, it has errors
AUTO_INCREMENT
and COLLATE NOCASE is suppose to be used in a select query.
You don't need case sensitivity on table creation/insert value, it is saved as is, you use it when you want to select.
EDIT:
You don't need ' for integers (i.e. %d)
Код:
Static analysis: 1 errors were found during analysis. A comma or a closing bracket was expected. (near "AUTOINCREMENT" at position 99) SQL query: CREATE TABLE IF NOT EXISTS vehicles (owner VARCHAR(24) COLLATE NOCASE, ownerid INTEGER PRIMARY KEY AUTOINCREMENT, forsale INTEGER DEFAULT 1 NOT NULL, model INTEGER DEFAULT 0 NOT NULL, color1 INTEGER DEFAULT 0 NOT NULL, color2 INTEGER DEFAULT 0 NOT NULL, price INTEGER DEFAULT 0 NOT NULL, posx FLOAT, posy FLOAT, posz FLOAT, posa FLOAT) MySQL said: Documentation #1273 - Unknown collation: 'NOCASE'
and COLLATE NOCASE is suppose to be used in a select query.
You don't need case sensitivity on table creation/insert value, it is saved as is, you use it when you want to select.
EDIT:
Quote:
'%s', '%d', '%d', '%d', '%d','%f', '%f', '%f', '%f' |