4873 Posts in 7242 Topics by 1471 members
|Go to End|
12 June 2010 at 4:29am
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)
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:
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!
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.
16 June 2010 at 3:01am
lol, I see something wrong with your server setup. Try changing to:
Ubuntu Linux 8.04 lts
Database collation is utf8
SS is gonna work much better that way... and so will everything else ;)
16 June 2010 at 3:33am
|Go to Top|