[TYPO3-dev] how to set the charset correctly to UTF-8

[Franz Holzinger]

Hello Jigal,

On 04/01/12 10:14, Jigal van Hemert wrote:

> On 4-1-2012 9:43, Franz Holzinger wrote:
>> Now I have found out that there is also a collation for each table field.
>> The database and the tables all are set to utf8_general_ci,
>> but the table fields have different collations:
>> latin1_german1_ci
>>
>> How can I use phpMyAdmin to set all collations of all table fields to
>> utf8_general_ci in one step? It would be hard to do this manually.
>
> http://wiki.typo3.org/UTF-8_support#Convert_an_already_existing_database_to_UTF-8
>
> Of course make a backup first in case things get worse.

thank you for this PHP script.
I have put it into fileadmin. Then I executed it successfully (see the 
output on the bottom).
However nothing did change.

The table tt_content has still the collation set to 'latin1_german1_ci' 
on the field level. The collation of tt_content is 'utf8_general_ci'.


	Field 	Type 	Collation 	Attributes 	Null 	Default 	Extra 	Action
	uid 	int(11) 			No 		auto_increment 	Browse distinct values 	Change 
Drop 	Primary 	Unique 	Index 	
	pid 	int(11) 			No 	0 		Browse distinct values 	Change 	Drop 	Primary 
Unique 	Index 	
	CType 	varchar(30) 	latin1_german1_ci 		No 			Browse distinct values 
Change 	Drop 	Primary 	Unique 	Index
	header 	varchar(255) 	latin1_german1_ci 		Yes 			Browse distinct 
values 	Change 	Drop 	Primary 	Unique 	Index 		header_position 
varchar(6) 	latin1_german1_ci 		No 			Browse distinct values 	Change 
Drop 	Primary 	Unique 	Index 	Fulltext
	bodytext 	mediumtext 	latin1_german1_ci 		No 			Browse distinct 
values 	Change 	Drop 	Primary 	Unique 	Index
	image 	text 	latin1_german1_ci 		Yes 	NULL 		Browse distinct values 
Change 	Drop 	Primary 	Unique 	Index



- Franz


----------------

backend_layout: ..... OK
be_groups: ............... OK
be_sessions: .... OK
be_users: .............. OK
cache_extensions: ........... OK
cache_hash: .. OK
cache_imagesizes: ... OK
cache_md5params: .. OK
cache_pages: . OK
cache_pagesection: OK
cache_treelist: .. OK
cache_typo3temp_log: ... OK
cachingframework_cache_hash: . OK
cachingframework_cache_hash_tags: .. OK
cachingframework_cache_pages: . OK
cachingframework_cache_pages_tags: .. OK
cachingframework_cache_pagesection: . OK
cachingframework_cache_pagesection_tags: .. OK
fe_groups: ..... OK
fe_groups_language_overlay: . OK
fe_session_data: . OK
fe_sessions: ... OK
fe_users: .............................. OK
index_config: ............ OK
index_debug: . OK
index_fulltext: . OK
index_grlist: . OK
index_phash: ...... OK
index_rel: OK
index_section: OK
index_stat_search: ... OK
index_stat_word: . OK
index_words: . OK
pages: ................ OK
pages_language_overlay: ........... OK
static_countries: .......... OK
static_country_zones: ...... OK
static_currencies: ........... OK
static_languages: ....... OK
static_markets: ..... OK
static_taxes: ....... OK
static_template: ...... OK
static_territories: .. OK
static_tsconfig_help: .... OK
sys_be_shortcuts: ... OK
sys_domain: .. OK
sys_filemounts: .. OK
sys_history: .... OK
sys_language: .. OK
sys_lockedrecords: .. OK
sys_log: ..... OK
sys_news: .. OK
sys_note: .... OK
sys_preview: .. OK
sys_products_accounts: ... OK
sys_products_cards: ... OK
sys_products_fe_users_mm_visited_products: OK
sys_products_orders: ....................... OK
sys_products_orders_mm_tt_products: . OK
sys_products_visited_products: OK
sys_refindex: ........ OK
sys_refindex_rel: OK
sys_refindex_res: . OK
sys_refindex_words: . OK
sys_registry: .. OK
sys_template: ............ OK
sys_ter: .... OK
sys_workspace: ....... OK
tt_content: ........................... OK
tt_products: ......................... OK
tt_products_accessory_products_products_mm: OK
tt_products_articles: .................. OK
tt_products_articles_language: ..... OK
tt_products_cache: . OK
tt_products_cache_tags: .. OK
tt_products_cat: ..... OK
tt_products_cat_language: ..... OK
tt_products_emails: .... OK
tt_products_gifts: ...... OK
tt_products_gifts_articles_mm: OK
tt_products_graduated_price: ... OK
tt_products_language: ......... OK
tt_products_mm_graduated_price: .. OK
tt_products_products_dam_mm: OK
tt_products_products_mm_articles: . OK
tt_products_products_mm_damcat: . OK
tt_products_products_note_pages_mm: OK
tt_products_related_products_products_mm: OK
tt_products_texts: ..... OK
tt_products_texts_language: ... OK
tx_feuserloginsystem_loginlog: .. OK
tx_feuserloginsystem_userstatistics: OK
tx_impexp_presets: . OK
tx_mbiproductscategories_mm: . OK
tx_rtehtmlarea_acronym: .. OK
tx_scheduler_task: ... OK
tx_staticinfotables_hotlist: .. OK
DATABASE: OK
finished converting tables