[Koha] More encoding issues

Chadwick, John, DCA john.chadwick at state.nm.us
Sat Dec 13 12:26:02 NZDT 2008


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 at state.nm.us

http://www.nmstatelibrary.org

 



Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System. 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20081212/b8b91806/attachment.htm 


More information about the Koha mailing list