Hi,

When I retrieve data entered via kexi any " quotes are doubled. A similar situation occurs with ' quotes.

Typically "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.

I see nothing in postgresql documentation referring to this. is it a kexi issue or a postgresql issue do you think?

Any guides to solving this issue gratefully received.

inksi

Hi inksi. Thanks for the report.

The problem is in Kexi however pgsql changed its behaviour and sets standard_conforming_strings=on option by default.

I can reproduce the issue with ' character . However I see no issue with the " character. Tested with psgsql 9.1, pgAdmin III after I entered text values into a kexi table. Kexi 2.6.3 (should have the same behavior as 2.5 or 2.4).

Please see the last line:



As you see in the line #8 ` character is properly handled. I also tested end-of-line and tab characters by the way, they're ok.

We have to replace ' with two ' characters as tested below. I'm working on the fix.



When reporting issues please always specify what's your Kexi version. What's your version?

Reported at https://bugs.kde.org/show_bug.cgi?id=318129. Next time please consider reporting there too to save us a lot of time. Thx!

Hello jstaniek,

thanks for prompt response. I am using kexi 2.4.0 as that is what comes with Linux Mint 13 -Maya. (cannot upgrade to 14 because of hardware issues.

in your display line 16 reproduces the effect that I get with a single ' quote. the problem with a single " quote is the same (or should we call that a double quote?).

I am still running pgsql 8.4.4 but also not due for upgrade until we build a new server or until necessary for some specific need.

did not list as bug as did not know that it was one, can never imagine that I could discover a bug that has not already been found by a hundred other people!

inksl

Hi, jstaniek,

At the moment I have a kludge in my perl formatting script to correct these things before the public see them.

inksi

inksi wrote:Hi, jstaniek,

At the moment I have a kludge in my perl formatting script to correct these things before the public see them.
inksi

The kludge is your only solution at the moment except building from the source code (not very hard). The fix will come to 2.6.4 and newer. Adding lack of backporting in your distro (and in general) this is not looking well. We're fixing bugs often in a matter of days and how to deploy the fixes remains a question. One option is a small virtual machine with always-updated Kexi in it, a modern solution that gets popular on newer hardware. How would you like this?

Hi,

Thanks for information gleaned from the past posts of yours.

I have reported another persistent bug that happens on a frequent basis, but not everytime. Did this properly through the bug reporting system which I installed - a major step forward at this end!

Maybe I should do a build when the quotes bug and this second 321262 bug are cleared. I wouldn't know where to start with installing / running a virtual machine, and this laptop I have here just runs Mint 13 and won't load Mint 14 for obscure hardware reasons. Like many of us in the 3rd world we are always compromising on hardware. I could probably cope with that.

What I would like to do would be to approach the maintainer for kexi on ubuntu (actually I am now on Linux Mint) to see if we can get an update there, but I don't think one can demand it. That could help more people than just myself. Not sure why it lags behind, perhaps compatability issues with certain libraries and other programmes? I would not have any idea.

Are other distros updated more frequently? I tend to stay with ones based on Debian because that is what I know.

Why not a patch?

Regards
Ian

Hi, marked as fixed on Aug 23: https://bugs.kde.org/show_bug.cgi?id=318129, will appear in 2.7.3 (Sep 11 http://community.kde.org/Calligra/Sched ... Plan#2.7.3)