Does anyone know if CakePHP officially supports nvarchar fields in MSSQL databases?
I'm using MS SQL Server 2005 with CakePHP 1.2.2.8120 Stable on windows and get the following errors from Cake when trying to view a page that contains text from an nvarchar(max) field: Warning (2): 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) [CORE\cake\libs\model\datasources\dbo \dbo_mssql.php, line 173] Warning (2): mssql_query() [function.mssql-query]: Query failed [CORE \cake\libs\model\datasources\dbo\dbo_mssql.php, line 173] Warning (512): SQL Error: 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. [CORE\cake\libs\model\datasources \dbo_source.php, line 525] I've done some digging around and found this ticket: https://trac.cakephp.org/ticket/4287 Which affects ntext fields with the same error. I've tried the supplied patch though didn't have any luck. Any ideas on how I can get this working? Unfortunately I'm stuck using MS SQL on Windows and really need unicode fields. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
