[Koha-bugs] [Bug 1230] On editing marc entry: Publisher fields(tag 260) NOT stored as utf8 in mysql

[bugzilla-daemon]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1230





------- Comment #15 from address@hidden  2006-12-14 22:07 -------
The problem came down to answering the question:
During modification, why the data for
the table biblio has the expected data
but the data for table biblioitem has junk ?

So, comparing sub OLDmodbiblio & sub OLDmodbibitem
in Biblio.pm, found differences in how the 
record is getting updated.

In OLDmodbiblio its:
$dbh->prepare("Update biblio set title = ?,... ;
$sth->execute( $biblio->{'title'},... ;

In OLDmodbibitem its:
$biblioitem->{'itemtype'} = $dbh->quote( $biblioitem->{'itemtype'}... ;
$query = "Update biblioitems set itemtype = $biblioitem->{'itemtype'},... ;
$dbh->do($query);

I made changes to OLDmodbibitem to 
be similar to that of OLDmodbiblio. ie,
$dbh->prepare("Update biblioitems set itemtype = ?, ... ;
$sth->execute( $biblioitem->{'itemtype'},... ;

And that fixes the bug !!

So, the issue seems to with the $dbh->quote thingy.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.