php-windows Digest 12 Mar 2003 22:45:44 -0000 Issue 1631
Topics (messages 18981 through 18984):
Problem when quering a view in MSSQL 2000: 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)
18981 by: Richard Gelderman
18983 by: Frank M. Kromann
Re: Outputing text with an image
18982 by: Anthony Ritter
Installing PHP with Apache on Win ME
18984 by: Nick Scott
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Hi there,
The following problem occurs when using a query who triggers its information
from a view in MSSQL 2000.
The errormessage that is returned:
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)
And yes, i'm using Unicode datafield. Strangly I can insert records in a
view without any errormessage.
I'm using IIS 5 on Windows 2000 Server and PHP 4.3.1.....very normal
configuration.
If anyone has a sollution for this problem I would be very pleased.
Thanks for reading this....
--- End Message ---
--- Begin Message ---
The MSSQL Extension for PHP is build with an old version of Microsoft's
DBLIB. This library does not support unicode, and it never will !!!
Use ODBC for now, and in a later version of PHP you can use a version of
the MSSQL extension build with FreeTDS. This will enable unicode. This is
now available on *nix systems but not on Win32 (I'm working on it).
- Frank
> Hi there,
>
> The following problem occurs when using a query who triggers its
information
> from a view in MSSQL 2000.
>
> The errormessage that is returned:
> 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)
>
> And yes, i'm using Unicode datafield. Strangly I can insert records in
a
> view without any errormessage.
> I'm using IIS 5 on Windows 2000 Server and PHP 4.3.1.....very normal
> configuration.
>
> If anyone has a sollution for this problem I would be very pleased.
>
>
> Thanks for reading this....
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Many thanks Warren.
TR
--- End Message ---
--- Begin Message ---
I have gone through the steps and when I open a php page it wants to
download the page.
What do I need to do?
--- End Message ---
