CN LIOU wrote:
> Thank you very much! Hiroshi,
> > > psqlODBC 7.02.0002 + PostgreSql 7.2.1 + Borland BDE +Windows95.
> > >
> > > Thus, I am trying to use TEXT column instead - and fail, too:
> > >
> > > create table MyTable (c1 integer,c2 text);
> > > --Then fill up value2 with string value using Delphi.
> > > INSERT INTO MyTable VALUES(:value1,:value2)
> > >
> > > The INSERT results in Access Violation from IDODBC32.DLL.
> > > Please note that value2 is about 55 kbytes in size and contains
> > > some low values, '\0' in terms of C. Can this be the problem
> > > confusing pgsqlODBC?
> > Yes.
> I have then also removed low values from the string but AV remains. I have set the pgsqlODBC switches according to the instructions in:
> Can '\r' or '\n' be a problem?
Maybe. Please turn off *LF <-> CR/LF conversion* DSN
> What are the allowed/disallowed characters in LongVarChar
> (to be sent to postgreSQL TEXT data type column)?
AFAIK there's no inhibited character other than '\0'.
However there may be another problem. If you are in a
multibyte environment the client encoding would be
converted to the server's one.
In response to
pgsql-odbc by date
|Next:||From: Keith Gray||Date: 2002-09-26 00:54:13|
|Subject: Re: Timestamp Error|
|Previous:||From: Nardos Tessema||Date: 2002-09-25 13:26:13|
|Subject: unixodbc and postgresql|