Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2003022

Re: [PHP] MS SQL Server problem From: Adam Voigt (adam <email protected>)
Date: 02/24/03

Let me guess, your using NTEXT datatypes in one or more columns on that
table right? It's not a big deal to work around this, just use:

mssql_query("SELECT CAST(field1 AS TEXT) AS field1 FROM table;");

Essentially you have to cast your NTEXT colums (or any which could have
more then 255 characters coming back), as TEXT's. I've never had any
problem's doing it like this.

On Mon, 2003-02-24 at 01:16, Mark Virtue wrote:

    This code works perfectly and returns all the data that I expect:
    
    mssql_pconnect($hostname, $username, $password) or die("blah blah");
    mssql_select_db($dbName) or die("blah blah");
    
    $result = mssql_query("select MyFieldName from MyTable");
    
    But if I change the last line to this:
    
    $result = mssql_query("select * from MyTable");
    
    I get the following warnings and no result is returned:
    
    Warning: mssql_query() [function.mssql-query]: message: Unicode data
    in a Unicode-only collation or ntext data cannot be sent to clients
    using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.
    (severity 16) in c:\test.php on line 24
    
    Warning: mssql_query() [function.mssql-query]: Query failed in
    c:\test.php on line 24
    
    I am using 4.3.0 on WinXP.
    
    Any thoughts?
    
    Mark. 

-- 
Adam Voigt (adam <email protected>)
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc