Data Truncation Errors - Mailing list pgsql-odbc

From Marc Zandvliet
Subject Data Truncation Errors
Date
Msg-id EJEPKBPLBLLPHCMAGNCPKEJFCAAA.marc@auroraworks.com
Whole thread Raw
List pgsql-odbc
Hello,

My application is experiencing "random" errors. At least I haven't found any
rhyme or reason for the errors.

I'm accessing a 7.1 database through ASP pages. On one table if I try to
insert strings that contain newline chars (ie. press return during text
input) I get truncated data errors. However on another table, the data is
accepted without any problem and subsequently displays (newlines removed).

I should indicate that the fields in question are both varchar (does it
matter?)

Is this even an odbc problem? I don't seem to have any problem using
pgAccess or pgsql. I'm quite concerned because I won't be the only person
entering data.

Hope someone can provide some insight and/or point me in the right
direction.

thanks,

Marc


pgsql-odbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error handling in ODBC
Next
From: Hiroshi Inoue
Date:
Subject: Re: Data Truncation Errors