How do I change Chinese names so they are spelt using Wade-Giles instead of Pinyin?

[TheRealMaestro]

Less than a week ago, I have received Civ V and I enjoy playing it;
it's even more fun than Civ IV was. I have a long list of changes that
I wish to make to the game, but I have no experience in modifying
Civ V. I have the Software Development Kit from the Steam library.

One of the modifications that I have made in Civ IV but wish to make
in Civ V is to change the names of the cities that China builds, so that
the cities' names will be by default using the tradiitional Wade-Giles
romanisation of Chinese; for example, the capital will be Peking, not
Beijing. I don't know how to change the list of cities that China builds,
though. How would I do so? Your guidance would be of great help.

(As an aside, are mods for vanilla Civ V typically compatible with either
official expansion pack? I will probably get both in the foreseeable future
but I currently only have vanilla.)

 

[Nutty]

A mod to do so is fairly easy.

If you prefer SQL:

UPDATE Language_en_US SET Text = "Peking"
	WHERE Tag = 'TXT_KEY_CITY_NAME_BEIJING';
UPDATE Language_en_US SET Text = "Ch'ao-chou"
	WHERE Tag = 'TXT_KEY_CITY_NAME_GUANGZHOU';
UPDATE Language_en_US SET Text = "Nan-ching"
	WHERE Tag = 'TXT_KEY_CITY_NAME_NANJING';
-- ...

Or XML:

<GameData>
	<Language_en_US>
		<Update>
			<Where Tag="TXT_KEY_CITY_NAME_BEIJING" />
			<Set Text="Peking" />
		</Update>
		<Update>
			<Where Tag="TXT_KEY_CITY_NAME_GUANGZHOU" />
			<Set Text="Ch'ao-chou" />
		</Update>
		<Update>
			<Where Tag="TXT_KEY_CITY_NAME_NANJING" />
			<Set Text="Nan-ching" />
		</Update>
		<!-- ... -->
	</Language_en_US>
</GameData>

EDIT: To get your new mod going quickly without messing with ModBuddy, you can use whoward69's My - Changes mod, and just add the code above to either SQL\MySqlChanges.sql or XML\MyUiTextStrings.xml (if the latter, note you only want one <GameData /> section).

As far as compatibility between expansions: sometimes yes, sometimes no. It's tough to say what's "typical" without knowing more about the kinds of mods you're interested in.