Skip to Content.
Sympa Menu

freetds - RE: ODBC troubles with nightly snapshot

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sam Denton <denton AT wantec.com>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: RE: ODBC troubles with nightly snapshot
  • Date: Mon, 24 Jun 2002 11:44:05 -0500


When used as a noun, DivX usually refers to a video stream using the DivX
encoder. See http://www.divx.com/ for more info, but suffice it to say that
the data could easily be gigabytes, i.e. SELECT videostream FROM movies
WHERE title LIKE "%Lord of the Rings%"

Sam Denton, WAN Technologies, Inc.
(314) 428-0888 / (800) 926-7771 Main Office


-----Original Message-----
From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
Sent: Monday, June 24, 2002 9:57 AM
To: TDS Development Group
Subject: [freetds] RE: ODBC troubles with nightly snapshot


> From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafoneomnitel.it]
> Sent: June 24, 2002 10:09 AM
> >
> > The UG syntax is wrong; the correct syntax is "set TEXTSIZE
> > 8000". It would
> > be part of your SQL query. The statement affects all queries
> > for the spid.
>
> I think a best solution should be use variable field for big
> one (ex: field
> >1K should be reallocated if needed). This should solve the
> missing TEXTSIZE
> problem.

This for sure: blindly attempting to allocate 4 GB and dumbly suffering the
consequences is not useful. ;)

You're saying we can allocate space for the actual data as needed, per field
per row. That's fine. It might be a little too clever, though; I imagine
it would be simpler (if less memory efficient) to allocate the same size for
every row. But I'm the sort who never writes "malloc" without having some
incense burning to keep away evil spirits.

I think we have to assert a column width before any rows are retrieved, to
support binding and to answer dbcollen() (and friends) correctly. If
dbcollen() returns 4 GB, client code is likely to segfault even if we don't.


> Also If I want to put DivX on a column I can.

What's "DivX"?

> Do you think this
> feature can be useful (I think it'll be a 0.7 feature...) ?

Yes. Next release, definitely, IMO; we want to see Bill's work and the new
ODBC stuff settle in first. I'd like to hear from Brian about what the
default column width ought to be, and how he'd like text fields to be
allocated.

Regards,

--jkl


---
You are currently subscribed to freetds as: [denton AT wantec.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')




Archive powered by MHonArc 2.6.24.

Top of Page