Text-Varchar Truncation via ODBC

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

Text-Varchar Truncation via ODBC

От:
Peter Staudt <Peter.Staudt@Vishay.com>
Дата:
Hi Jeff,

> 
> Hello,
> I am using a variety of programs to attach to a PostGreSQL 
> database via ODBC, including MS Access 2000 and MS DTS 7.0.
> 
> Any column in my PostGreSQL database with a datatype of TEXT of 
> VARCHAR(n) is limiting/truncating INSERTed or UPDATEd data to 
> ~255 characters.
...
Hmmm, maybe this one is not of much use for you,
but I thought the 255 characters are a M$ Access limitation and
you have to use "memo" type fields if you need more than 255.

CU,
Peter

Text-Varchar Truncation via ODBC

От:
JPTrue@aol.com
Дата:
Hello,
I am using a variety of programs to attach to a PostGreSQL database via ODBC, including MS Access 2000 and MS DTS 7.0.

Any column in my PostGreSQL database with a datatype of TEXT of VARCHAR(n) is limiting/truncating INSERTed or UPDATEd data to ~255 characters.
I have tested and tried all variations of TEXT and VARCHAR(n) in my PostGreSQL database. 
In addition, I have tried modifying all settings in the ODBC driver ( I am using version 7.02.00.02).

Any ideas, hints, or solutions would be greatly appreciated.

Thanks,
Jeff

Re: Text-Varchar Truncation via ODBC

От:
Hiroshi Inoue <Inoue@tpf.co.jp>
Дата:
JPTrue@aol.com wrote:
> 
> Hello,
> I am using a variety of programs to attach to a PostGreSQL 
> database via ODBC, including MS Access 2000 and MS DTS 7.0.
> 
> Any column in my PostGreSQL database with a datatype of TEXT
> of VARCHAR(n) is limiting/truncating INSERTed or UPDATEd data
> to ~255 characters.
> I have tested and tried all variations of TEXT and VARCHAR(n)
> in my PostGreSQL database.
> In addition, I have tried modifying all settings in the ODBC
> driver ( I am using version 7.02.00.02).

Did you try to turn on *Text As LongVarchar* option ?

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