TYPO3 RTE:保存数学/希腊符号不起作用 [英] TYPO3 RTE: Saving mathematical/greek symbols doesn't work

问题描述

我需要在RTE中以及稍后在前端中显示一些数学/希腊符号.通过复制/粘贴或插入字符"选项插入它们的效果很好，但是一旦我保存了文本，插入的符号get就会被问号替换，T3会引发以下错误:

I need to display some mathematical/greek symbols in the RTE and later in the frontend. Inserting them via copy/paste or the "Insert characters" option works great, but as soon as I save the text, the inserted symbol get's replaced with a question mark and T3 throws following error:

1:表"tt_content"中记录56的这些字段未正确保存:正文！由于数据库的类型转换，值可能已更改.

1: These fields of record 56 in table "tt_content" have not been saved correctly: bodytext! The values might have changed due to type casting of the database.

我认为T3或我的数据库的字符集有问题，但是我不知道从哪里开始寻找.

I think there is an issue with the character set of T3 or my DB, but I don't know where to start looking.

推荐答案

在我的7.6.8上进行了测试，它似乎可以正常工作.当我登录我的mysql并运行此查询时:

Tested on my 7.6.8 and it seems to work OK. When I login to my mysql and run this query:

SELECT default_character_set_name FROM information_schema.SCHEMATA
    WHERE schema_name = "7_6_local_typo3_org";

(7_6_local_typo3_org是数据库名称)，它返回:

(7_6_local_typo3_org is database name) it returns:

+----------------------------+
| default_character_set_name |
+----------------------------+
| utf8                       |
+----------------------------+
1 row in set (0.00 sec)

以及排序规则:

SELECT default_collation_name FROM information_schema.SCHEMATA
    WHERE schema_name = "7_6_local_typo3_org";
+------------------------+
| default_collation_name |
+------------------------+
| utf8_general_ci        |
+------------------------+
1 row in set (0.00 sec)

然后我的my.cnf(mysql配置文件)中也有

Then also I have in my my.cnf (mysql config file):

character-set-server = utf8
collation-server = utf8_general_ci

这篇关于TYPO3 RTE:保存数学/希腊符号不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！