[rt-users] Change text in tickts using database

[Juanjo]

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, 'ú', 'ú')


Regards.

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>