PHP: SQL Syntax error on equivalent server -
our development , production servers identical, except capacity (ram, disk, , on): ms win server 2008 r2 ent/ms sql server 2005/apache2.2/php 5.213. in our dev machine following (summarized) sql works perfectly:
select somecol collate database_default localtable union select somecol collate database_default linkedserver.remotedb.dbo.table
note: linked server same 1 in both dev/prod servers.
in prod server gives following error:
[microsoft][sql server native client 10.0][sql server]incorrect syntax near 'database_default'.
if remove collate dabatase_default clauses, error (as expected):
[microsoft][sql server native client 10.0][sql server]cannot resolve collation conflict between "sql_latin1_general_cp1_ci_ai" , "sql_latin1_general_cp1_ci_as" in union operation.
if if point prod code dev database, works. on other hand, if point de dev code prod database, fails.
what on earth going on?
thank you.
i belive have diffrent default collations on servers , couse problem.
select somecol collate database_default localtable union select somecol collate sql_latin1_general_cp1_ci_as linkedserver.remotedb.dbo.table
please post collation on columns.
Comments
Post a Comment