Tag's problem,Is caused by the Storage Engine of Mysql ?

when I used Chinese Character as a tag,It appears as garbled.
I find that the tag's data in mysql is error,for example:

#消息 中文标签

In DBname-notice-rendered,The correct format should be(just ignore "|")

#<|span class="tag"><|a href="http://mydomain.com/tag/%E6%B6%88%E6%81%AF" rel="tag">消息 中文标签|
In fact, it was wrong store as(just ignore "|")

#<|span class="tag"><|a href="http://mydomain.com/" rel="tag">|
So a lot of information lost when stored。

My DB is mysql 5.1.45,work with MyISAM, Apache 2.2.15, PHP 5.2.13.

My Storage Engine is MyISAM,not InnoDB.

Comments

  • @zensh in class/notice.php, the function of savetag uses a regular expression to match a tag. the current regular expression does not support Chinese characters.
  • @zensh myisam is no longer supported please switch to innodb.

    reply back here if you need some help.
  • @aric Thank you! I will try to switch to innodb
  • I have switched to innodb,but But the problem remains
  • @aric I have used InnoDB,when I used Chinese Character as a tag,It still appears as garbled.But “XXXX.status.net” support Chinese Character as a tag。
  • @zensh the installer and software set everything to innodb, not sure how you even had myisam working, what version is this?
  • @aric My website Environment:

    ubuntu-9.10-server 64

    PHP 5.2.13

    PHP extensions
    - Curl
    - XMLWriter
    - MySQL
    - GD2
    - mbstring
    - gettext
    - Mailparse
    - Memcache
    - Sphinx
    - gmp
    - fileinfo

    MySQL 5.1.37

    Apache 2.2.15

    Memcached 1.4.5

    Meteor

    Sphinx not installed.

    I have make statusnet as a new installation, but Problem persists
  • @aric now just "profile" and "notice" tables use Myisam engine,others all use InnoDB. And I have tried to switch "profile" and "notice" tables into InnoDB engine, the Problem persists.
  • @zensh you have to make sql dump of the data and a sql dump of the shema, fix the schema file to use only inndb and import the data back using the fixed schema... I know that doesn't sound fun, a reinstall would be quick and easy depending how important your data is.
  • u need pcre 5.2.8 and do some code hacks.
  • I also hacked some codes for chinese username
  • @smoothdvd, I would like to use chinese username.. could you tell me how to hack the code?
  • ....................
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Google Sign In with OpenID