Add Additional Languages (Database Update)

To add or change the language of a WEC TYPO3 website is a complex task and should only be attempted by a website administrator who has experience working with MySQL databases and TypoScript.

This How To presumes that you have an existing site that is NOT brand new. If you are working from a fresh install of the WEC Starter Package, you may skip this How To and go directly to the Add Additional Languages (Localization) How To.

1. To add additional translations to your website, you will need access to the following tools:
   
   1. A MySql client, such as phpMyAdmin.
   2. A database client, such as MySQL Database Wizard.
2. Begin by logging into your server's database using a MySQL client. This example uses phpMyAdmin.
3. Select your TYPO3 database and then click on the Export tab.
4. Leave all of the options at their default settings.
5. Scroll down the page and put a checkmark in the Save as file box. Do not change the name of the database, but make note of it so that you'll remmeber it and then click on the Go button.
6. Save the file to your local computer.
7. NOTE: Your site will be offline until you have completed the database changes when you complete the next step:
   
   Using a database client (such as MySQL Database Wizard), delete the existing TYPO3 database.
8. Next, using WordPad or another text editor, open the saved database.
9. Type the command
10. USE 'your_database_name'; somewhere before the command CREATE TABLE.
11. Do a global search and replace for CHARACTER SET latin1 and replace it with CHARACTER SET utf8.
12. Do another global search and replace for CHARSET=latin1 and replace it with CHARSET=utf8.
13. Do a third global search and replace for COLLATE latin1_sweedish_ci and replace it with COLLATE utr8_general_ci.
14. When you're done, save the database using the same name as the original database.
15. Using a database client (such as MySQL Database Wizard), create a new database with the same name as the one in your saved file.
16. Create a database user, password, and give them permission to use the database (all privileges) - you will save time if the user name and password are identical with the ones in the original database.
17. Login and connect to the database using phpMyAdmin
18. On the home page, click the Import link and select the updated database file on your computer. Click the Go button.
19. If you have not changed the database name, user name, or password from the original database, your TYPO3 website should be up and running again.
20. This completes the updating of the Database so that you can create additional language options on your TYPO3 website. To complete the process, continue with the Add Additional Languages (Localization) How To.