Re: [JDBC] Re: Unterminated quoted string error.

2001-09-03 Thread Bruce Momjian
I heard it was fixed too but looking around, I found nothing. I added it tonight to the types section. > Thomas, > > You are correct about the poor documentation for bytea. I hear this is > fixed in 7.2 docs, but haven't verified. I learned about it myself by > looking at the internal pg_*

Re: [JDBC] Re: Unterminated quoted string error.

2001-09-03 Thread Bruce Momjian
I have added a description to the CVS and it will appear in 7.2. It is in the development docs now. > Hi Barry, > > I looked in the postgresql documentation and couldn't find any mention > of a "bytea" type. Well actually, I found .. > > $ grep -i bytea * > bki-commands.html:>bytea catalog-pg

Re: [JDBC] Re: Unterminated quoted string error.

2001-08-29 Thread Barry Lind
Thomas, You are correct about the poor documentation for bytea. I hear this is fixed in 7.2 docs, but haven't verified. I learned about it myself by looking at the internal pg_* tables and seeing how they used it. I'm glad to hear that you have a workaround for your original issue. thanks,

Re: [JDBC] Re: Unterminated quoted string error.

2001-08-29 Thread Thomas O'Dowd
Hi Barry, I looked in the postgresql documentation and couldn't find any mention of a "bytea" type. Well actually, I found .. $ grep -i bytea * bki-commands.html:>byteabyteabytea(bytea *) Thomas, > > The text datatypes in postgres (i.e. char, varchar, text) do not support > storing null charac

Re: [JDBC] Re: Unterminated quoted string error.

2001-08-28 Thread Barry Lind
Thomas, The text datatypes in postgres (i.e. char, varchar, text) do not support storing null characters. If your data contains nulls then you need to use the binary datatype bytea. Unfortunately the JDBC drivers do not currently support the bytea datatype. thanks, --Barry Thomas O'Dowd wr

Re: [JDBC] Re: Unterminated quoted string error.

2001-08-28 Thread Thomas O'Dowd
I found problem. My string has a null character in the middle of it. I noticed from the Connection.java code that the null character idicates end of query so I guess that is what is happening. I'll strip out my null strings in the mean time as they are not needed before sending them to the driver

[JDBC] Re: Unterminated quoted string error.

2001-08-28 Thread Thomas O'Dowd
Thanks Barry, I turned on debugging in postgresql. I found that the query is being truncated and is not fully making it to the backend, therefore I'm getting the Unterminated string error. I'll have a look into why and report back if I find anything. Cheers, Tom. On Tue, Aug 28, 2001 at 12:56

[JDBC] Re: Unterminated quoted string error.

2001-08-28 Thread Barry Lind
Thomas, If you turn on debug messages on the server to print out the SQL statements it receives you should be able to get the exact string that the server is receiving from the client and failing on. That might help you find the problem. thanks, --Barry Thomas O'Dowd wrote: > Hi all, > > I