Make editing Max Length property of table field not require data removal
Bug: https://bugs.kde.org/show_bug.cgi?id=408012
Manual workaround for any KEXI version:
- Close your KEXI database and back up it.
- Open the
Sqliteman
GUI app or any equivalent. //Note: You can do the same with sqlite3 console app if you have skills. You can do the same with MySQL Admin or PostgreSQL Admin for server KEXI databases.// - For given table T run this query to find out its id: select o_id from kexi__objects where o_name='T'. Note down the o_id number.
- For that o_id value (e.g. 217) and for given length (e.g. 1000) and field name (e.g. 'c') run this query: update kexi__fields set f_length=1000 where t_id=217 and f_name='c'
- Repeat steps 3 and 4 for any number of tables and fields you need. You can use skip the "and f_name='c'" part of the query to set all fields in the table to give length.
Note: This operation does not truncate or extend length of actual data, you need to do that separately using other queries. This makes implementation of the task more complex than it looks: actual data modification may be needed.
Edited by Jarosław Staniek