Quick question concerning the following wiki page on encoding:

 

http://wiki.koha.org/doku.php?id=encodingscratchpad.

 

Some of the information in the wiki seems to be more applicable to MySQL 4.1 instead of 5.x

 

Also, some of the suggested changes to modify tables seem to refer to tables that are not in Koha 3.0.1. Specifically, there is no table called marc_subfield_table. There is a marc_subfield_structure.

 

There is no abstract in the table biblioitems.

 

-- Convert the database default encoding to UTF-8 and default collate to utf8

 ALTER DATABASE kohawipofinal DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

 -- change the table encoding type (varchar -> binary -> varchar ) for MARC Data

 alter table marc_subfield_table modify subfieldvalue BINARY(255);

 alter table marc_subfield_table modify subfieldvalue VARCHAR(255) CHARACTER SET utf8;

 -- change the table encoding type (text -> blob -> text ) for Koha Tables

 alter table biblio modify title BLOB;

 alter table biblio modify title TEXT CHARACTER SET utf8;

 alter table biblio modify author BLOB;

 alter table biblio modify author TEXT CHARACTER SET utf8;

 alter table biblio modify unititle BLOB;

 alter table biblio modify unititle TEXT CHARACTER SET utf8;

 alter table biblio modify notes BLOB;

 alter table biblio modify notes TEXT CHARACTER SET utf8;

 alter table biblio modify seriestitle BLOB;

 alter table biblio modify seriestitle TEXT CHARACTER SET utf8;

 alter table biblio modify abstract BLOB;

 alter table biblio modify abstract TEXT CHARACTER SET utf8;

 alter table biblioitems modify abstract BLOB;

 alter table biblioitems modify abstract TEXT CHARACTER SET utf8;

 

That should do it for now.

 

John

 

+----------------------------------------------------------------------------+

John Chadwick, Ed.D. Information Technology Manager

New Mexico State Library

1209 Camino Carlos Rey

Santa Fe, NM 87507

Phone: 505-476-9740  Cell: 505-629-8116 Fax: 505-476-9761

john.chadwick@state.nm.us

http://www.nmstatelibrary.org