Skip to Content.
Sympa Menu

freetds - Re: Sybase DBD::Sybase (was RE: Re[2]: [freetds] freetds & MSSQL 2000)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT bluewin.ch>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: Sybase DBD::Sybase (was RE: Re[2]: [freetds] freetds & MSSQL 2000)
  • Date: Wed, 06 Aug 2003 18:22:41 +0200

On Wed, 2003-08-06 at 18:03, ZIGLIO Frediano wrote:
> > >
> > > I've tried it, but it isn't working.
> > > $dbh_mssql =
> > >
> > DBI->connect("dbi:Sybase:server=MSSQL2000:database=$dbname",$msuser,$m
> > > spasswd);
> >
> > I believe the DBD::Sybase docs state that the
> > DBD::Sybase-specific connection parameters (i.e. the items
> > that follow "Sybase" in the DSN) should be separated by a
> > semi-colon (;) instead of a colon (:).
> >
> > I realize that the difference is slight, and that choice may
> > have been a mistake. Maybe I should allow both in a future
> > version of DBD::Sybase.

>
> I know you are DBD::Sybase author and you are a Sybase admin too, so I
> have 2 questions for you.
> 1- What features are useful for DBD::Sybase ? (I readed in your
> documentation placeholders support...)

placeholders are number 1, because DBI users tend to make use of them a
lot.
Other things are RPCs (ct_command(CS_RPC_CMD), ct_param()), options
(ct_option(CS_OPT_NUMROWS), for example).

> 2- What new features has Sybase 12/12.5 ? guid ? unicode ? blobs ? CAST
> functions ? Anything we do not support (like long password...)

Wide varchar/varbinary (up to 16k in length). guid exists in 12.5.0.3,
but it's really just a varchar() string).
12.5.1 (in beta right now) has DATE and TIME datatypes (both 4 bytes) -
support for that isn't really essential right now, although I will add
that to DBD::Sybase and Sybase::CTlib, and I'll probably patch sqsh as
well.
Sybase handles unicode, of course, but I've not really done very much
with it (and perl's unicode support has been flaky).

Michael






Archive powered by MHonArc 2.6.24.

Top of Page