RE: [PHP-DB] Is ODBC now the Native interface for MS-SQL7/2000 ?

2002-02-04 Thread Oliver Cronk
ue to lack of staff with Linux knowledge). Thanks for the info and the work around Oliver -Original Message- From: Brian Bruns [mailto:[EMAIL PROTECTED]] Sent: 03 February 2002 22:53 To: [EMAIL PROTECTED] Cc: Php-Db ML Subject: Re: [PHP-DB] Is ODBC now the Native interface for MS

Re: [PHP-DB] Is ODBC now the Native interface for MS-SQL7/2000 ?

2002-02-03 Thread Brian Bruns
Technically, it is not the dblib interface that limits you to 255 character varchars. TDS (tabular datastream, the on the wire protocol) version 4.2 (the version used upto SQL Server 6.5) is limited to a single byte size field and thus 255 characters (0 represents NULL). The problem is that

[PHP-DB] Is ODBC now the Native interface for MS-SQL7/2000 ?

2002-02-03 Thread Oliver Cronk
After looking at the newsgroup microsoft.public.sqlserver.odbc I came across the follwing piece of information - anyone know if it is true? It would certainly explain a few things (why we can only get 255 chars out of varchars etc). Should I move my code over to ODBC? I have tried but the