Re: psqlODBC text length with no records

On 05/14/2014 09:03 AM, Barry Bell wrote:
> It has to be the Driver/Postgres because VFP does not determin the datatype
> (The driver does).

That does not preclude the possibility that it changes a data type to
meet its view of the world given that data type handling varies greatly
from on data system to another.

>
> With the B0=254(Max Varchar) in the connection string of the ODBC driver is suppose convert
> The "text" in postgres to varchar is the length is less then 254.
> The issue here is the length is 0 or null, this setting is ignored and returns "text".
>
> Can you provider anymore information on driver setting B0 (Max Varchar)

From here:

http://psqlodbc.projects.pgfoundry.org/docs/config.html

Max Varchar The maximum precision of the Varchar and BPChar(char[x])
types. The default is 254 which actually means 255 because of the null
terminator. Note, if you set this value higher than 254, Access will not
let you index on varchar columns!

From here:

Varchar can be used the same way Character can: you can index on it
(the index keys are padded with spaces to the length of the field,
because index keys must be a fixed length), it accepts null values, and
Varchar fields have a limit of 254 characters in a table or cursor.

If it where me I would set B0 = 253 to see what happens.

>
>
> Barry Bell

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com