More encoding issues

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

More encoding issues

Chadwick, John, DCA

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

[hidden email]

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.



_______________________________________________
Koha-devel mailing list
[hidden email]
http://lists.koha.org/mailman/listinfo/koha-devel