[rt-users] Change text in tickts using database

Juanjo juanjillo at gmail.com
Fri Oct 19 04:41:48 EDT 2012

I need edit to change some characterset. I migrate from mysql to
postgresql. And some local character (spaniard character) text are now
showhing proper.

I wan´t to mantain the Actually encondig and Collate. To make that, i think
that is enought to only change a string like ú to my spaniard character.

Run this sctipt on the rtdb database using pgAdmin 3.

update attachments set content = replace(content, 'ú', 'ú')


2012/10/19 Tim Cutts <tjrc at sanger.ac.uk>

> On 19 Oct 2012, at 08:00, Juanjo <juanjillo at gmail.com> wrote:
> > Thanks.
> >
> > But i don´t see the email content, only see the headers.
> >
> > I´m looking to change the content of the messages.
> >
> > I see in the attachments tab, a column called content, but says (trough
> phpMyAdmin) Binary Not Edit!!
> You certainly can edit them with the mysql command line client, but I
> wouldn't advise it.  Why do you need to edit them anyway?
> Tim
> --
>  The Wellcome Trust Sanger Institute is operated by Genome Research
>  Limited, a charity registered in England with number 1021457 and a
>  company registered in England with number 2742969, whose registered
>  office is 215 Euston Road, London, NW1 2BE.

Un saludo.
Juanjo Corral
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121019/20432a09/attachment.htm>

More information about the rt-users mailing list