Hi there

Trying out Silver Stripe, see if it fits our requirements for the next project.

Tried to install it today, but I get error message from database just on the second screen of installation

[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)

POST /recruitment/install.php

Tried to google the problem, but no feasible solutions so far. Some people did recommend changing the datatypes in DB columns, some changing SQL queries. None are suitable for fresh installation of the CMS. I might think we need to tune in database encoding (set as what?)

I wonder if something wrong with our server setup or database setup:
Windows 2003
IIS 6.0
MSSQL Server 2005
PHP 5.2 build 3790
MSSQL library version 7.0
Database collation is Latin1_General_CI_AS

Any idea/pointer where I should dig?
I'll appreciate any help!

Thanks

p.s. Please don't suggest updating to IIS 7 or MSSQL 2008 - we are stuck with this versions, as our other major system does not work with higher versions of this servers. However, we can update php and libraries.

lol, I see something wrong with your server setup. Try changing to:

Ubuntu Linux 8.04 lts
Apache
MySQL
PHP 5.26
Database collation is utf8

SS is gonna work much better that way... and so will everything else ;)

funny, haha

Try using the SQL Server Driver for PHP provided by Microsoft.