Dual language CMS

[optik]

I've been asked to make a CMS that for site that has Chinese/English versions.

As far as I know all that would need doing is I would have two databases using different character sets and then I would select the correct database in PHP appropriately.

Is there anything else that needs to be considered I've only worked with PHP/SQL in English before.

I guess things like regex's and data sanitisation are also an issue?

[penders]

Or one database in UTF8?

[optik]

In PHPmyadmin I'm only offered regional versions of UTF8 ie utf8_danish_ci

unless utf8_unicode_ci or utf8_bin_ci are universal?

[coopster]

utf8_unicode_ci [dev.mysql.com]
This FAQ may be helpful as well:
MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets [dev.mysql.com]

[optik]

that's great thanks