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

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

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





------- Comment #9 from rhariram at gmail.com  2006-10-24 08:55 -------
Sorry. overlooked the 'SHOW FULL COLUMNS' command in your doc.

For table biblioitems' all column's collation values look OK. (see below)
Coming to think of it, if collation were wrong in the first place,
the new record itself would have corrupted value for fields in biblioitems.
In this case the data in biblioitems gets corrupted only after editing an
existing record.

The database,server,client,connection all of them are on utf8.
So, altering collation or encoding is'nt necessary.

mysql> SHOW FULL COLUMNS FROM  biblioitems;
+------------------+--------------+-----------------+------+-----+-------------------+-------+---------------------------------+---------+
| Field 	   | Type	  | Collation	    | Null | Key | Default     
     | Extra | Privileges		       | Comment |
+------------------+--------------+-----------------+------+-----+-------------------+-------+---------------------------------+---------+
| biblioitemnumber | int(11)	  | NULL	    |	   | PRI | 0	       
     |	     | select,insert,update,references |	 |
| biblionumber	   | int(11)	  | NULL	    |	   | MUL | 0	       
     |	     | select,insert,update,references |	 |
| volume	   | text	  | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| number	   | text	  | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| classification   | varchar(25)  | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| itemtype	   | varchar(4)   | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| isbn		   | varchar(14)  | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| issn		   | varchar(9)   | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| dewey 	   | varchar(30)  | utf8_unicode_ci | YES  |	 |	       
     |	     | select,insert,update,references |	 |
| subclass	   | varchar(3)   | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| publicationyear  | smallint(6)  | NULL	    | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| publishercode    | varchar(255) | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| volumedate	   | date	  | NULL	    | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| volumeddesc	   | varchar(255) | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| timestamp	   | timestamp	  | NULL	    | YES  |	 |
CURRENT_TIMESTAMP |	  | select,insert,update,references |	      |
| illus 	   | varchar(255) | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| pages 	   | varchar(255) | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| notes 	   | text	  | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| size		   | varchar(255) | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| place 	   | varchar(255) | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| lccn		   | varchar(25)  | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| marc		   | text	  | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
| url		   | varchar(255) | utf8_unicode_ci | YES  |	 | NULL        
     |	     | select,insert,update,references |	 |
+------------------+--------------+-----------------+------+-----+-------------------+-------+---------------------------------+---------+
23 rows in set (0.00 sec)




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