Re: Problem writing strings to database

[prev] [thread] [next] [Date index for 2004/12/23]

On Thu, Dec 23, 2004 at 01:10:28AM +0000, Tony Bowden wrote:
> On Wed, Dec 22, 2004 at 01:18:14PM -0800, cdbi@xxxxxxxxxx.xxx wrote:
> > I can consistantly reproduce the problem by removing all data from my
> > table.  My code then starts inserting data to the table, and the first
> > value is '0', the second is 'NOW_PLAYING' and then I get the error.  Its
> > as if Class::DBI sees that value is 0 the first time around, and assumes
> > it will always be a number.  (The column is varchar).  So can I somehow
> > force Class::DBI to treat my values as strings all the time?
> 
> That's a DBI issue, rather than a Class::DBI one. 

Or, more specifically, an bug with the database driver being used.
Check you're using the latest and, if you are, send an email to
dbi-users@xxxx.xxx about it (and CC the driver author).

Tim.

> AFAIK the only reliable way to get around that is to tell DBI that's
> going to be a VARCHAR column, which you can do using the undocumented
> column_type() method.  
> 
> Tony