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

[bugzilla-daemon at daddy.katipo.co.nz]

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


rhariram at gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jmf at kados.org




------- Comment #14 from rhariram at gmail.com  2006-12-10 02:04 -------
I added the following code to *MAIN* section of addbiblio.pl
(just after the declarations)
<code>
        open (OUT,">/tmp/ookk.$$");
        print OUT `date` ;

        my $pubname ;
        my @mytags = $input->param('tag');
        my @mysubfields = $input->param('subfield');
        my @myvalues = $input->param('field_value');
        my $i;
        for($i=0;$i<$#mytags;$i++) {
                if ($mytags[$i] eq '260' and $mysubfields[$i] eq 'b') {
                        $pubname = $myvalues[$i] ;
                }
        }
        print OUT "Pubname: " . $pubname . "\n" ;
        close OUT;
</code>

On the browser I do the following:
 * Retrieve a record from Catalogue
 * click on "Edit Biblio"
 * update the existing biblio record
 * Click on "Save Bibliographic record and go to items"

The Output of the /tmp/ookk.* file:
<output>
Sat Dec  9 18:22:38 IST 2006
Pubname: ஆரூரன1்
</output>
(This is the expected output)
However the same field in 
mysql's biblioitems table
changes to junk

Are they two different variables or
is it an issue with db commit ?




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