Thread: truncation of long text fields

truncation of long text fields

From
Werner Modenbach
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Maybe someone can help me here.

I have a database (postgreSQL 7.2 on SuSE 7.2) with a table containing text
fields with long entries (>30000 char).
Using the native driver in my application works fine (SuSE 8.0). Using odbc
cuts the text fields after about 8100 char.
In the docs I found some notes thar the bug has been solved in the latest
release. So I downloaded and installed it - unfortunately without success.

Any hints for me?

Thanks.

- - Werner -

- --
- --------------------------------------------------------------
    ALC Computertechnik GmbH
Kaiserstr. 100, D-52134 Herzogenrath, GERMANY
Fon +49 2407 95810
Fax +49 2407 958139
http://www.alc.de
- --------------------------------------------------------------
Werner Modenbach       modenbach@alc.de
- --------------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE9EuRc3dsyHy9PfoYRAiaNAKCFchP8JBCbw8mL798+CZMK2m54SACdE4YG
IeEXM9qyhzHpHM6qXYRJUrE=
=Cz/K
-----END PGP SIGNATURE-----


Re: truncation of long text fields

From
Hiroshi Inoue
Date:
Werner Modenbach wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Maybe someone can help me here.
>
> I have a database (postgreSQL 7.2 on SuSE 7.2) with a table
> containing text fields with long entries (>30000 char).
> Using the native driver in my application works fine (SuSE 8.0).
> Using odbc cuts the text fields after about 8100 char.
> In the docs I found some notes thar the bug has been solved
> in the latest release. So I downloaded and installed it -
> unfortunately without success.
>
> Any hints for me?

Did you increase *Max LongVarChar* size ?

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/