From: Byron Nikolaidis <byronn@insightdist.com>
To: Sam@OConnor.net
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] ODBC Driver v06-40-0005
Date: Fri, 09 Apr 1999 18:46:00 -0400
Message-ID: <370E8328.12C47676@insightdist.com> (raw)
References: <370D697E.55AB30F4@insightdist.com>
<370E3EAA.4E43ED87@netspace.net.au>
Sam O'Connor wrote:
> Hi,
> I think I found another problem.
> When selecting type text from tclodbc using pgodbc and postgres I was
> loosing
> one character off the start of the string for every newline in
> contained.
> When copy_and_conver_field processes selected text fields it converts cr
> to cr/lf. (why?)
>
Actually, its LF to CR/LF when going from the database to odbc. When going the
other way (odbc->database), it converts CR/LF to LF. The reason is for
Microsoft from what I remember. It might have even been in the odbc spec (I
can't quite remember). It probably shouldn't do it if its being run on Unix
though?
> When data_left is set how ever it uses the original length.
>
> I changed this:
> stmt->bindings[stmt->current_col].data_left = strlen(value);
> To this:
> stmt->bindings[stmt->current_col].data_left = strlen(ptr);
>
> Now it works!
>
Good Job, you found a bug alright! It should be strlen(ptr). When I tested
it, I didn't have newlines so it worked ok.
I'll put it in for the next release.
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, Sam@OConnor.net
Subject: Re: [INTERFACES] ODBC Driver v06-40-0005
In-Reply-To: <370E8328.12C47676@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox