| From: | Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | ODBC driver settings for BLOBs |
| Date: | 2003-03-21 16:36:10 |
| Message-ID: | 3E7B3F7A.5040109@web.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
While inserting BLOBs into the database, I found that there are
dependencies on MaxVarcharSize, MaxLongVarcharSize and
UnknownAsLongVarchar ODBC settions. I need to set MaxVarcharSize or
MaxLongVarcharSize, dependent on UnknownAsLongVarchar, lower than the
smallest BLOB to be written to a lo column. In my case, the smallest
BLOB that will ever be written has 4 bytes, so 3 is the correct value
for me.
I went into the ODBC source, but couldn't determine if this would have
some other unwanted effects.
I now use MaxLongVarcharSize=3, MaxVarcharSize=254 (to keep Access
happy) and UnknownAsLongVarchar and hope the best.
I wonder if it really makes sense to deal with BLOBs different depending
on their size....
Regards,
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2003-03-21 16:48:20 | Re: using domain types with ODBC, esp. lo |
| Previous Message | Tom Lane | 2003-03-21 16:31:52 | Re: using domain types with ODBC, esp. lo |