The database is a MsSQL 2000 database. If I make a query in the Enterprise Manager the result is like 1800 characters for the result that I only get 256 for in my model :-(
On Jun 11, 3:49 pm, John Andersen <[email protected]> wrote: > Additional info is that the MyIsam varchar in MySQL 5.0.3 works with > larger length, so that may also be an issue with your database. What > version are you using? > Enjoy, > John > > On Jun 11, 4:44 pm, John Andersen <[email protected]> wrote: > > > > > What database engine are you using? As far as I know, the MyIsam > > engine only allows varchar(256), so that could be the reason. InnoDb > > allows more! > > > I have varchar(2000) columns in my tables, no issue with them and I am > > using InnoDb. > > Enjoy, > > John > > > On Jun 11, 3:22 pm, Jonas <[email protected]> wrote: > > > > Hello, > > > > I am trying to make a query with a line like this: > > > > $this->find('all', array('conditions' => $conditions, 'fields' => > > > $columns, 'order' => $order, 'limit' => $limit)); > > > > everything works fine except that my text column, which is > > > VARCHAR(2000) in the database only returns 256 characters in the > > > resulting array. 256 seems very suspect, is there some limit on how > > > big the result can be? If I want all the data, how do I proceed? > > > > Regards, > > > Jonas Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
