<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [rt-users] character encoding issues after updating</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Thanks heaps! I read the README and UPGRADING instructions but somehow missed UPGRADING.mysql. Sorry for bothering you! Keep up the good work! -- Jac<BR>
<BR>
-----Original Message-----<BR>
From: Jesse Vincent [<A HREF="mailto:jesse@bestpractical.com">mailto:jesse@bestpractical.com</A>]<BR>
Sent: Mon 10/20/2008 3:46 PM<BR>
To: Jac Gubbels GUBBELS<BR>
Cc: rt-users@lists.bestpractical.com<BR>
Subject: Re: [rt-users] character encoding issues after updating<BR>
<BR>
On Sun 19.Oct'08 at 21:23:27 +0300, Jac Gubbels GUBBELS wrote:<BR>
> Hi,<BR>
><BR>
> After having successfully implemented version 3.6.4 in our organization, I<BR>
> have started an attempt at updating the installation to 3.8.1. It seems to<BR>
> be successful, however I have one show stopping issue. When I look at the<BR>
> tickets the Turkish characters we use have become corrupted. Here is what<BR>
> I do in terms of upgrading the database:<BR>
<BR>
There's an upgrade script one needs to run, documented in the UPGRADING<BR>
file. It's badly named (etc/schema.mysql-4.0-4.1.pl), but you need it.<BR>
<BR>
><BR>
> * I copy the database to a new one using phpmyadmin (I can run the new<BR>
> version now! even without the db update, but with the character issues)<BR>
> * I run the update script over the copy (from the temporary directory that<BR>
> holds the 'upgrade' directory)<BR>
> * I am using the copy for the new installation as I have to keep the<BR>
> original database in one piece, it is live...<BR>
><BR>
> When I look at the fields in the database I see no differences between the<BR>
> two ('fotokopi(C500) sarı ve mavi toner bitik!' remains 'fotokopi(C500)<BR>
> sarı ve mavi toner bitik!' - apparently we need blue and yellow toner<BR>
> for a printer ;-), so that makes me think something changed somewhere<BR>
> else. 3.6.4 shows this ticket as it should, with a dotless i, 3.8.1 gives<BR>
> 'ı'<BR>
><BR>
> When I play with the character encoding using my browser I am not able to<BR>
> get things to show up right.<BR>
><BR>
> Any suggestions would be great.<BR>
><BR>
> -- Jac<BR>
> Istanbul, Turkey<BR>
<BR>
> _______________________________________________<BR>
> <A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR>
><BR>
> Community help: <A HREF="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>
> Commercial support: sales@bestpractical.com<BR>
><BR>
><BR>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<BR>
> Buy a copy at <A HREF="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR>
<BR>
--<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>