Backward slash (\) problem

danielweinmann · Post by **danielweinmann** » 13.11.2006, 13:30

Hi folks! I have the following situation:

Unless I have stored in the database field double backwards slashes, TZQuery will return no \'s at all in myQuery.FieldByName('mycolumn').AsString...

Ex.:
Content of "mycolumn" stored in the database: "\\server\html\index.html" -> myQuery.FieldByName('mycolumn').AsString returns "\serverhtmlindex.html"

...is anybody facing the same problem? People from Zeos Team is aware of this? Is there any solution?

My systems wont work if this is not working.

Thanks in advance,
Daniel Weinmann

barko · Post by **barko** » 13.11.2006, 22:55

it works for me on firebird-1.5 and latest zeosdbo (testing branch) from svn, lazarus, fpc, linux

danielweinmann · Post by **danielweinmann** » 14.11.2006, 12:42

Ops...I forgot to tell I am using PostgreSQL.
I've tryed with PostgreSQL 8.2 and 7.1.2.

Both of them wont work.

Does anybody know a possible solution?

Thanks in advance,
Daniel Weinmann

danielweinmann · Post by **danielweinmann** » 14.11.2006, 13:01

...I did make it work now...but...

it is only working when I set myTZConnection.Protocol to "postgresql-7", even if I am using PostgreSQL 8.2.

I've tryed with myTZConnection.Protocol = "postgresql" and myTZConnection.Protocol = "postgresql-8". And it really only works with "postgresql-7" protocol.

Is it a bug or is it normal?

Thanks!

Daniel Weinmann

Post by **mdaems** » 14.11.2006, 14:58

What did you change to make it work? So we can maybe find out why it doesn't work in postgresql-8. Problem looks Postgres-related.

Mark

danielweinmann · Post by **danielweinmann** » 14.11.2006, 15:36

The only thing I did was changing myTZConnection.Protocol from "postgresql" to "postgresql-7". I also tryed to change it to "postgresql-8", but it didn't work.

I think it is PostgreSQL related, indeed. But I believe it is a PostgreSQL X Zeos 6.6.0beta issue, cause with older versions of Zeos (5.3.4) it was working fine...

...thanks a lot.

Daniel Weinmann

Post by **mdaems** » 22.11.2006, 09:49

Hi Daniel,
This proves it's a postgresql-8 driver error (postgresql defaults to postgresql-8 )
Probably we'll have to wait for a developerusing Postgres-8 to fix this. (I'm a mysql-addict

) I'll do a quick diff to see if I can find it, but don't count on it.

Mark

cnliou · Post by **cnliou** » 12.12.2006, 17:00

danielweinmann wrote:Content of "mycolumn" stored in the database: "\\server\html\index.html" -> myQuery.FieldByName('mycolumn').AsString returns "\serverhtmlindex.html"

I just tried "/branches/testing" revision 188 but did not see this problem.

I used postgresql-8 and saved string "C:\\a\b\c.txt" in varchar column and successfully retrieved the same string from it.

String "\\a\b\c.txt" is good, too.

Regards,
CN

fduenas · Post by **fduenas** » 27.12.2006, 03:37

Hi danielweinmann:

What version of zeoslib are you using?
Always try to use latest version from here.

Currently it is 6.6 beta

Zeoslib Portal

Backward slash (\) problem

Backward slash (\) problem

Re: [bug_report] Backward slash (\) problem