ERROR: datatype mismatch

[Former user]

Originally reported on Google Code with ID 257

What steps will reproduce the problem?
1.Trying to add a new row in the database
2.
3.

What is the expected output? What do you see instead?
A new column in the database.. but instead it gives me this error, or simply wont display
it on the web form. 

What version of the product are you using? On what operating system? Which
Database Extension (PDO/SQLiteDatabase/SQLiteDatabase3 - see Database
structure-tab in phpLiteAdmin)?
PDO

Please provide any additional information below.

Reported by rosemarygraham94 on 2014-07-07 22:05:29

[Christopher Kramer]

This is most likely because you are trying to insert something like characters into
a integer ID column.
SQLite does not usually enforce data types except on integer columns that are primary
keys. This is due to SQLite using these integers as internal rowids.

What is your CREATE TABLE SQL statement and what values are you trying to insert?

Reported by crazy4chrissi on 2014-07-08 08:02:18

[Christopher Kramer]

Closed (not enough feedback)

Reported by crazy4chrissi on 2014-12-27 23:16:53 - Status changed: Invalid