All fields in the database tables are generated as longtext when using csweb:proccess-cases

[michaego]

Dear all,

I am currently using cspro 8 and csweb 8 for data capture, but with the resulting database I have a problem when running the process:cases (relational database copy creation process php console csweb:process-cases), all the fields no matter that in the cspro dictionary are defined as numeric, in the replicated database they are assigned the longtext data type, why is this?

[savy]

This behavior is by design. CSPro on the client side stores the csdb data in SQLite format. SQLite is less strict about storing any content in the INTEGER type columns. For example, a record item's numeric column can contain '*' if the data is of invalid type for numeric content and if a dictionary changes mid-stream from three decimal places to two, the csdb table numeric column is still able to store both old values without any problem. This is not possible to do in MySQL tables hence we had to keep it as text to prevent loss of data.