in reply to Convert database into UTF-8

I have used Encode on a recent project to convert between WinLatin1 and UTF8

Replies are listed 'Best First'.
Re^2: Convert database into UTF-8
by cog (Parson) on Apr 20, 2005 at 10:58 UTC
    Encode has been working fine for me too, between ISO-8859-1 and UTF-8.

    Wonderful module :-)

      But - I just think I'm misunderstanding the documents, or the fundementals of DBI. I'm not quite sure how one would go about using Encode. Do I - encode('utf8', decode('ENCODING', $database{column})) ?
        Probably. If not that, something similar.

        And then you have to update the database, with something like

        update table set column = encode('utf8', decode('ENCODING', $database{column}))

        At least I think so... although I'm not sure of how to do that with DBI without looking at the docs.