This report is based on the forum http://forum.kde.org/viewtopic.php?f=221&t=110765: When I retrieve data entered via kexi any single ' quotes are replaces with doubled ". Eg. 'The Berea' shows up as ""The Berea"". Whether I retrieve the data via kexi or via a direct sql query on the database makes no difference. Reproducible: Always
Setting 2.5.0 as the version since it will be fixed for 2.5, 2.6 and later.
Created attachment 78767 [details] Proper escaping
Created attachment 78768 [details] Actual behavior
Still not fixed, -> 2.7
Related report for Ubuntu: https://bugs.launchpad.net/ubuntu/+source/koffice/+bug/1213336
Fixed in this commit http://commits.kde.org/calligra/ca9d1c3574b772e1d2ce0c2641c4e9a63c17f64b
Git commit 2002b62058ad7069681d0aa7cb03b0cd80e099b6 by Adam Pigg. Committed on 23/08/2013 at 07:36. Pushed by piggz into branch 'calligra/2.7'. Fixed postgresql escaping properly escape the ' character with \' re-ordered the escape order so that \' isnt double escaped to \\' tested with the following strings hi hi's 'hi' \o/ hi \o/ \' \' M +2 -2 kexi/kexidb/drivers/pqxx/pqxxdriver.cpp http://commits.kde.org/calligra/2002b62058ad7069681d0aa7cb03b0cd80e099b6
Git commit a1ad4ceb78a8f72ddf3015910f0886acbb150283 by Adam Pigg. Committed on 23/08/2013 at 07:36. Pushed by piggz into branch 'calligra/2.6'. Fixed postgresql escaping properly escape the ' character with \' re-ordered the escape order so that \' isnt double escaped to \\' tested with the following strings hi hi's 'hi' \o/ hi \o/ \' \' M +2 -2 kexi/kexidb/drivers/pqxx/pqxxdriver.cpp http://commits.kde.org/calligra/a1ad4ceb78a8f72ddf3015910f0886acbb150283