MSSQL - varchar(255) limit on SELECT

[akrohn]

As pointed out in ticket#46 the varchar-limit of 255 still exists on windows platforms ( http://www.qcodo.com/forums/topic.php/2327/)  and was verified yesterday by me on qcubed 1.0 stable, windows xp, sql server 2005, php 5.2.4.

Data is inserted correctly but when selecting/showing it, it's truncated at 255 characters.

The suggested fix "SELECT CAST(MyVarCharField AS TEXT) FROM MyTable" works. (http://www.php.net/manual/en/function.mssql-field-length.php).

We are working on a fix to implement this into codegeneration for the MSSQL driver.

[alex94040]

This has been opened 5 months ago, but there's not been a fix... This looks like very much of a fringe issue (you can change the table definition to be TEXT instead of varchar if you care to store longer stuff), so unless we hear from an interested party soon, we'll close this bug as "won't fix".

[akrohn]

This is fixed in the new SQL Server 2005/8 database adapter (see #327).

[alex94040]

Closing as won't fix. This has been addressed in the new MSSQL driver.