I've just installed 2.4.1 and tried to open a database from the previous version (2.2?). Kexi opened it fine but now limits each text field to 200 characters. This results in my data being chopped off at the 200th character. Much of my data is now unusable. If I try to change the 200 limit, all my data will be erased. The previous version did not have a character limit. What should I do?

kexian

Hello,
Kexi does not strip your data on opening, so your data is safe. Some testing is needed what happened. Maybe some visual setting has a bug.
Could you try to create a new database in 2.4 and check if Kexi saved 200+ long fields (check if these are visible after opening)?
If it saved ok, could you please send me your database created in 2.2 (e.g. just one table with one row, and remove the rest)?

I created a 200+ character field in a new 2.4 database as you suggested. When I cut and pasted a long piece of text into it, it would only display 200 characters and the rest were cut off. I then saved the record, exited Kexi, then re-opened it. Again, it would only display 200 characters. According to the design of the table, the length of each field is 200 characters long. I had no say in the length of each field. I guess 200 characters is the default length.
Any way to change this?

waynevid

How do I get around the 200 character limit? If I try to create a new database with a larger character limit, then import my old data, wouldn't I first have to export the old data to a csv file? And by exporting it, it would limit each field to 200 characters thereby ruining the new data? Is Kexi able to import directly old Kexi files (instead of csv)?

Kexian

Dear Kexian,
Yes, 200 is the default limit set by Kexi itself. There is important problem with the GUI, I am sorry for the inconvenience. I reported the bug with expected solutions and want to have the fix for 2.5.0:

https://bugs.kde.org/show_bug.cgi?id=301136

I also provided current workarounds at http://community.kde.org/Kexi/Releases/ ... und_301136.
Please ask if more info is needed so the document can be updated.

Thank you for the information. I was able to use sqliteman and increase the limit beyond 200 characters. My database is functioning normally again.

kexian

Update: In Kexi 2.5 Beta (available in source code for now) it's now possible to set Length to 0 (unlimited), and by default it is now 0. For SQLite (.kexi files) and PostgreSQL backends this removes limits.

This will also appear in 2.4.3 soon.