Has anyone had any experience with converting and/or storing different charsets with mysql or a database that does not support unicode?

I am just wondering what the best way to store it is. One way it to conver to unicode and store, but since mysql can't do unicode, will that break it?

So in that case is it better to store it encoded as something us and do the decoding on the way out of the database?