Re^2: Convert database into UTF-8

Encode has been working fine for me too, between ISO-8859-1 and UTF-8.

Wonderful module :-)

Comment on Re^2: Convert database into UTF-8

Replies are listed 'Best First'.
Re^3: Convert database into UTF-8 by salonmonk (Beadle) on Apr 20, 2005 at 11:04 UTC
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})) ?	[reply]
Re^4: Convert database into UTF-8 by cog (Parson) on Apr 20, 2005 at 11:13 UTC
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.	[reply] [d/l]