WebEngine icon indicating copy to clipboard operation
WebEngine copied to clipboard

[ODBC SQL Server Driver][SQL Server]The data types varchar(max) and text are incompatible in the equal to operator.

Open SmilySeal opened this issue 2 years ago • 2 comments

Hi! Im getting this error when installing CMS 1.2.5 with ODBC connection: https://prnt.sc/UkHsGooWiRie

With pdo_sql im not getting this error, but I want to know why it happens with ODBC.

XAMPP ver: 8.1

SmilySeal avatar Nov 08 '23 03:11 SmilySeal

Same error here on localhost, have you solved it?

kosicki123 avatar Mar 08 '24 01:03 kosicki123

You have a query that is parsing to many character or the varchar request another value than it gets. i have solved it with my CMS but that is talking to mysql instead of MSSql because Mysql using less resources than MSSQL.

https://discord.com/channels/634429509231443978/1229504838619107338

drop the install_step_4.php here than i will take a look at it.

pretendor avatar Apr 17 '24 21:04 pretendor

Please use the PHP SQLSRV drivers for Windows provided by Microsoft https://learn.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server?view=sql-server-ver16

lautaroangelico avatar Feb 20 '25 00:02 lautaroangelico