<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Quick question concerning the following wiki page on
encoding:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><a href="http://wiki.koha.org/doku.php?id=encodingscratchpad">http://wiki.koha.org/doku.php?id=encodingscratchpad</a>.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Some of the information in the wiki seems to be more
applicable to MySQL 4.1 instead of 5.x<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>There is no abstract in the table biblioitems.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<pre><font size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'>-- Convert the database default encoding to UTF-8 and default collate to utf8<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> ALTER DATABASE kohawipofinal DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> -- change the table encoding type (varchar -> binary -> varchar ) for MARC Data<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table marc_subfield_table modify subfieldvalue BINARY(255);<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table marc_subfield_table modify subfieldvalue VARCHAR(255) CHARACTER SET utf8;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> -- change the table encoding type (text -> blob -> text ) for Koha Tables<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify title BLOB;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify title TEXT CHARACTER SET utf8;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify author BLOB;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify author TEXT CHARACTER SET utf8;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify unititle BLOB;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify unititle TEXT CHARACTER SET utf8;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify notes BLOB;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify notes TEXT CHARACTER SET utf8;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify seriestitle BLOB;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify seriestitle TEXT CHARACTER SET utf8;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify abstract BLOB;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblio modify abstract TEXT CHARACTER SET utf8;<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span lang=EN style='font-size:10.0pt'> alter table biblioitems modify abstract BLOB;<o:p></o:p></span></font></pre>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN
style='font-size:12.0pt'> alter table biblioitems modify abstract TEXT
CHARACTER SET utf8;</span></font><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>That should do it for now.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>John<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>+----------------------------------------------------------------------------+</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>John Chadwick, Ed.D. Information Technology Manager</span></font><o:p></o:p></p>
<p class=MsoNormal><st1:place w:st="on"><st1:PlaceName w:st="on"><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>New Mexico</span></font></st1:PlaceName><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> <st1:PlaceType
w:st="on">State</st1:PlaceType></span></font></st1:place><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'> Library</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>1209 Camino Carlos Rey</span></font><o:p></o:p></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>Santa Fe</span></font></st1:City><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>, <st1:State
w:st="on">NM</st1:State> <st1:PostalCode w:st="on">87507</st1:PostalCode></span></font></st1:place><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Phone: 505-476-9740 Cell: 505-629-8116 Fax:
505-476-9761</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><a href="mailto:john.chadwick@state.nm.us">john.chadwick@state.nm.us</a></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><a href="http://www.nmstatelibrary.org">http://www.nmstatelibrary.org</a></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<DIV> </DIV><br><br>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. <br><br><br></body>
</html>