Review Request: Set limit to 255 for Text type in MySQL Driver

[Jarosław Staniek]

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
http://git.reviewboard.kde.org/r/105182/#review14531
-----------------------------------------------------------


Example error message that we now get in MySQL for text larger than 255 bytes (this is expected):

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


- Jarosław Staniek


On June 7, 2012, 11:41 p.m., Jarosław Staniek wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> http://git.reviewboard.kde.org/r/105182/
> -----------------------------------------------------------
> 
> (Updated June 7, 2012, 11:41 p.m.)
> 
> 
> Review request for Calligra, Adam Pigg, Dimitrios Tanis, and Oleg Kukharchuk.
> 
> 
> Description
> -------
> 
> Set limit to 255 for Text type in MySQL Driver
> 
> MySQL Driver:
> *set limit to 255 for Text type (VARCHAR)
> *call "SET SESSION sql_mode='TRADITIONAL'" on opening database - needed to turn warnings about trimming string values into SQL errors
> 
> 
> Diffs
> -----
> 
>   kexi/doc/dev/CHANGELOG-Kexi-js 18e47c81f96b4382468369c59437dec54d573aa4 
>   kexi/kexidb/connection.cpp 6ffabc64364a46a65aa65e2a29a4e2d657c51445 
>   kexi/kexidb/driver.cpp 8b527c7c952e3b40546c10c52fc0a04dcf464341 
>   kexi/kexidb/driver_p.h b6d4af33f8a8279b5bdae1b1683770b91083ad98 
>   kexi/kexidb/drivers/mySQL/mysqlconnection_p.cpp 7c4ea06c053fb77fbb7ba808564a1d9f24b6e4b8 
>   kexi/kexidb/drivers/mySQL/mysqldriver.cpp 82edd6a678f27ce7b00bc90456ab5cb75b4e7683 
> 
> Diff: http://git.reviewboard.kde.org/r/105182/diff/
> 
> 
> Testing
> -------
> 
> works for MySQL because this commit reverts the behaviour of connection to previous state in case of MySQL
> 
> 
> Thanks,
> 
> Jarosław Staniek
> 
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/calligra-devel/attachments/20120609/b71fd4b6/attachment.htm>