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

[Franz Holzinger]

On 04/01/12 14:37, Lorenz Ulrich wrote:

> Did you also read the lines that some lines needs to be commented out if
> the umlauts are already displayed correctly in phpMyAdmin?

Argh, I did not take notice of this. I have now commented out the 
following lines 108-123 of the script and the conversion of the umlauts 
has been successfull.


- Franz


/*	
$sql = 'ALTER TABLE `' . $table . '` MODIFY COLUMN `' . $column['Field'] 
. '` ' . $column['Type'] . ' ' . $column['Null'];
	// only use default part if it's not a blob/text
if (strpos($column['Type'], 'blob') === FALSE) {
	$sql .= ' DEFAULT ' . $column['Default'];
}
$sql .= ' ' . $column['Extra'] . ';';
if (DEBUG) {
	echo $sql . "\n";
} else {
	if (!SIMULATE) {
		$db_res = mysql_query($sql, $db);
		if (!is_resource($db_res) && mysql_errno($db) != 0) {
			echo 'Could not execute query!: ' . mysql_error($db) . "\n" . $sql;
		}
	}
}*/

> Am 04.01.2012 13:22, schrieb Franz Holzinger:
>> Unfortunately the script did not convert the umlauts, but cut the text
>> off at the position where the first umlaut is found.
>> E.g.:
>> Datenschutzerklärung ==> Datenschutzerkl
>>
>>
>> - Franz