Обсуждение: BUG #4354: Text Type converted to Memo

Поиск
Список
Период
Сортировка

BUG #4354: Text Type converted to Memo

От
"Abuzar"
Дата:
The following bug has been logged online:

Bug reference:      4354
Logged by:          Abuzar
Email address:      Abuzer755@hotmail.com
PostgreSQL version: 8.3.1
Operating system:   Windows xp SP2
Description:        Text Type converted to Memo
Details:

I used text, character varying type in my base,then i look it on form in
Delphi so i so that these types are shown on form like memo.what is
happening with it?
Please answer

Re: BUG #4354: Text Type converted to Memo

От
Bill Moran
Дата:
In response to "Abuzar" <Abuzer755@hotmail.com>:
>
> The following bug has been logged online:
>
> Bug reference:      4354
> Logged by:          Abuzar
> Email address:      Abuzer755@hotmail.com
> PostgreSQL version: 8.3.1
> Operating system:   Windows xp SP2
> Description:        Text Type converted to Memo
> Details:
>
> I used text, character varying type in my base,then i look it on form in
> Delphi so i so that these types are shown on form like memo.what is
> happening with it?
> Please answer

I remember seeing something similar with FoxPro some time back.

If it's the same issue, then it stems from the fact that Delphi doesn't
have the exact same data types as PostgreSQL, and thus it must do some
mapping to get as close as possible.  Memo is a pretty close match for
TEXT (at least it was in Fox).

This isn't a bug in PostgreSQL.  I don't believe it's a bug at all, it's
just an interoperability quirk.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

Re: BUG #4354: Text Type converted to Memo

От
David Fetter
Дата:
On Thu, Aug 14, 2008 at 12:31:34PM +0000, Abuzar wrote:
>
> The following bug has been logged online:
>
> Bug reference:      4354
> Logged by:          Abuzar
> Email address:      Abuzer755@hotmail.com
> PostgreSQL version: 8.3.1
> Operating system:   Windows xp SP2
> Description:        Text Type converted to Memo
> Details:
>
> I used text, character varying type in my base,then i look it on
> form in Delphi so i so that these types are shown on form like
> memo.what is happening with it?

If this is a bug, it is on the Delphi side, but I don't think it is.

Delphi's memo type corresponds (roughly) to PostgreSQL's TEXT/VARCHAR
one, so it's your expectations that were off.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate