Ticket #236 (closed defect: wontfix)
MSSQL - varchar(255) limit on SELECT
|Reported by:||akrohn||Owned by:|
|Priority:||important||Milestone:||1.0.2 Legacy Maintenance|
|Component:||Database adapter||Version:||1.0.0 Stable|
|Keywords:||MSSQL, LIMIT, varchar||Cc:|
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.