On Wed, Feb 11, 2009 at 8:51 AM, Steven Bristol <[email protected]> wrote: > > I changed the > > > def cast_to_string(clause) > "CAST(#{clause} AS CHAR)" > end > > to > > > def cast_to_string(clause) > "CAST(#{clause} AS CHAR(20))" > end > > > in the mysql adapter. > > It did fix the problem. Is this the proper fix or is there a better > way to do it? > > > steve
Alright, so obviously that truncated the title field down to 20. When I run this "SELECT cast(title as char), cast(business_id as char) FROM `expenses` WHERE 1" in dev or prod the business_id column is not truncated to three so I am wondering if I am hitting some sort of max row length issue in mysql? Does anyone have any ideas? cheers, steve --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" 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/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
