freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: Sybase DBD::Sybase (was RE: Re[2]: [freetds] freetds & MSSQL 2000)
- 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
-
Sybase DBD::Sybase (was RE: Re[2]: [freetds] freetds & MSSQL 2000),
ZIGLIO Frediano, 08/06/2003
-
Re: Sybase DBD::Sybase (was RE: Re[2]: [freetds] freetds & MSSQL 2000),
Michael Peppler, 08/06/2003
- Re: Sybase DBD::Sybase (was RE: Re[2]: [freetds] freetds & MSSQL 2000), James K. Lowden, 08/07/2003
-
Re: Sybase DBD::Sybase (was RE: Re[2]: [freetds] freetds & MSSQL 2000),
Michael Peppler, 08/06/2003
Archive powered by MHonArc 2.6.24.