UTF-8 repair TYPO3 - TYPO3 Snipplr Social Repository

Revision: 47032

at May 30, 2011 22:48 by Rito

Updated Code

1. mysqldump -u root -p mydatabase > dump.sql
2. cp dump.sql dump.sql.bak
3. vi dump.sql
4. :1,$:s/ DEFAULT CHARSET=latin1/ DEFAULT CHARSET=utf8/g
5. :wq
6. mysql -u root -e "DROP DATABASE mydatabase"
7. mysql -u root -e "CREATE DATABASE mydatabase CHARACTER SET utf8"
8. mysql -u root -p mydatabase < dump.sql

## In TYPO3 installTool:
[setDBinit] -> SET NAMES utf8
[UTF8filesystem] -> true
[forceCharset] -> utf-8

## typoscript:
page.metaCharset = utf-8
page.additionalHeaders = Content-Type:text/html;charset=utf-8

Revision: 47031

at May 30, 2011 22:46 by Rito

Initial Code

1. mysqldump -u root -p mydatabase > dump.sql
2. cp dump.sql dump.sql.bak
3. vi dump.sql
4. :1,$:s/ DEFAULT CHARSET=latin1/ DEFAULT CHARSET=utf8/g
5. :wq
6. mysql -u root -e "DROP DATABASE mydatabase"
7. mysql -u root -e "CREATE DATABASE mydatabase CHARACTER SET utf8"
8. mysql -u root -p mydatabase < dump.sql

In TYPO3 installTool:
[setDBinit] -> SET NAMES utf8
[UTF8filesystem] -> true
[forceCharset] -> utf-8

Initial URL

Initial Description

progress of converting a latin db into utf8

Initial Title

UTF-8 repair TYPO3

Initial Tags

sql

Initial Language

TYPO3

Choose a language for easy browsing: