xoror@infuse.org wrote:
>
> On Thu, 11 Oct 2001, Hiroshi Inoue wrote:
>
> > xoror@infuse.org wrote:
> > >
> > > hi,
> > >
> > > I've just starting to use postgresql. Currently i'm migrating a mysql
> > > application to postgres. However i've encountered some strange things.
> > >
> > > I'm using c++ builder 5.0. I use ADO + ODBC to access postgresql (7.1.3
> > > cygwin). i've read the faq and uncheck some options concerning to varchar
> > > and stuff. but I still have problems with text type. If one of my colomn
> > > is a text type, and when i try to edit it with a data-aware component, i
> > > get this error : expecting memo, actual string.
> > >
> > > now that's weird since that column is defined as a text type. it should be
> > > regcognise as memo. is this a bug ? (or known flaw?)
> >
> > Are you checking Text as LongVarChar option ?
> > If you are checking it, *text* would be treated as *memo*,
> > otherwise *text* would be treated as *text*.
>
> I've read the FAQ and i unchecked Text as LongVarChar.
>
> i've checked the option and everything works now. THANKS !!!
> i suggest you'd better change the FAQ.
>
> the FAQ is wrong in this case.
>
> Data Type Options:
> Uncheck Text as LongVarchar
Changed to *Check Text as LongVarChar*
Thanks.
> > > the second weird thing is that i can enable logging but the driver
> > > produces nog logfile :(
> >
> > Which option are you enabling ?
> >
>
> i enabled c:\psqlodbc.log and mylog thing. but to no avail.
There are 2 modes for setting the driver option.
Are you checking *per DSN* option ?
regards,
Hiroshi Inoue
