Re: TypeInfoCache

Daniel Migowski schrieb: <blockquote cite="mid:47693B10.3040804@ikoffice.de" type="cite">Gregory Stark schrieb: <br
/><blockquotetype="cite">"Daniel Migowski" <a class="moz-txt-link-rfc2396E"
href="mailto:dmigowski@ikoffice.de"><dmigowski@ikoffice.de></a>writes: <br />   <blockquote type="cite">Hello
deardevelopers, <br /><br /> I just updated the TypeInfoCache to return LONGVARCHAR for the PostgreSQL Type <br />
text.Currently VARCHAR(0) is returned, which seems not correct in my eyes, and <br /> confuses some major software
packetslike Chrystal Reports. <br />     </blockquote><br /> Why? <br /></blockquote> Because VARCHAR (in my
understanding)has some limit, like 256 or 50 or even 8192, whatever. LONGVARCHAR is unlimited as I understand and much
bettermatches what i understood what "text" is for. While looking at the JDBC specification "JSR-000221 JDBC 4.0 Final
ReleaseEvaluation", they didn't make a clear statement on this, but AFAIK varchar always carries a length with it.
"text"does not, so its a LONGVARCHAR. It doesn't matters, because all functions to get the data are equally defined for
bothdatatypes (spec page 199, table B-6). <br /><br /> At all, the driver returns a length of -1 for the "text" type,
sinceits no varchar type, and software using the metadata might expect to get something >0 for the length of a
VARCHAR,like defined in the SQL spec (don't know the page there, but the postgresql handbook says, varchar without a
parameteris a postgres extension). <br /><br /> With best regards, <br /> Daniel Migowski <br /></blockquote> Btw, a
varcharwithout length in PostgreSQL should be treated as LONGVARCHAR, too, but i didn't implement that for now. <br
/><br/> With best regards,<br /> Daniel Migowski<br /><div class="moz-signature">-- <br /><pre> |¯¯|¯¯|    <b>IKOffice
GmbH            Daniel Migowski</b>|  |  |/|                            Mail: <a
href="mailto:dmigowski@ikoffice.de">dmigowski@ikoffice.de</a>| | // |  Nordstr. 10               Tel.: +49 (441) 21 98
8952|  | \\ |  26135 Oldenburg           Fax.: +49 (441) 21 98 89 55|__|__|\|  <a
href="http://www.ikoffice.de">http://www.ikoffice.de</a>   Mob.: +49 (176) 22 31 20 76           Geschäftsführer: Ingo
Kuhlmann,Daniel Migowski           Amtsgericht Oldenburg, HRB 201467           Steuernummer: 64/211/01864</pre></div>