Best MySQL collation and page character set for international site?

[petewilliams]

I'm developing a site that is aimed at people from all over the world, although admittedly most visitors will be English speakers.

My databases are currently encoded using the default latin1-swedish-ci, and my PHP pages use the iso-8859-1 character set, but I was wondering whether this is the most suitable?

I thought UTF-8 might be the answer but it turns out PHP5 can't handle that very well, so does anyone have any suggestions? I'm a bit of a newbie when it comes to collation so it's all a bit over my head at the moment!

Thanks,

Pete

[chazzy]

i would say to use latin1, based on what you're currently doing in PHP.

[petewilliams]

Thanks Chazzy, that's pretty much the conclusion I've come to. Is this likely to cause any problems with international characters? Also, should I stick with Swedish or change to one of the other options?

Pete

[mataji]

how i can make my sql database on my site