Revision da2bf9b...

Go back to digest for 10th June 2012

Bug Fixes in Office

Jarosław Staniek committed changes in [calligra] /:

Set limit to 255 for Text type in MySQL Driver

MySQL Driver:
*set limit to 255 characters for Text type (VARCHAR)
*call "SET SESSION sql_mode='TRADITIONAL'" on opening database - needed to turn warnings about trimming string values into SQL errors
*practical solution for 'Kexi shows no indication that text is trimmed' bug in case of MySQL: error is displayed eg. "Record inserting on the server failed.Message from server: Data too long for column 'hn' at row 1. SQL statement: INSERT INTO table4 (hn) VALUES ('...................'). Server result: 1406"

More info on VARCHAR support in databases: http://www.ispirer.com/wiki/sqlways/mysql/data-types/varchar_n



REVIEW:105182
FIXED-IN:2.4.3

Bug 301136: Kexi shows no indication that text is trimmed
 
4 days
Bug 301277: Remove limits for Text data type, leave as option
1 days

File Changes

Modified 6 files
  •   kexi/kexidb/connection.cpp
  •   kexi/kexidb/driver.cpp
  •   kexi/kexidb/driver_p.h
  •   kexi/doc/dev/CHANGELOG-Kexi-js
  •   kexi/kexidb/drivers/mySQL/mysqlconnection_p.cpp
  •   kexi/kexidb/drivers/mySQL/mysqldriver.cpp
6 files changed in total