[rt-users] Change text in tickts using database

[Kevin Falcone]

On Fri, Oct 19, 2012 at 10:41:48AM +0200, Juanjo wrote:
>    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 u to my spaniard character.
> 
>    Run this sctipt on the rtdb database using pgAdmin 3.
> 
>    update attachments set content = replace(content, 'u', '*')

If you do run this, please make sure if you report any bugs in the
future to mention that you did a conversion from mysql to pg and then
massaged the data by hand.  It'll help us know that much of the data
shouldn't be trusted.

If I were you, I'd be trying to make the mysql -> pg conversion part
work without needing the massage afterwards.  That just seems fraught
with peril.

-kevin

>    2012/10/19 Tim Cutts <[1]tjrc at sanger.ac.uk>
> 
>      On 19 Oct 2012, at 08:00, Juanjo <[2]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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121019/e7a30038/attachment.sig>