dtnat7146
dtnat7146
2015-03-01 18:59

PHPMYADMIN导出截断MYSQL数据库的文本字段

已采纳

In MYSQL table, there is a Text field which contains the below contents.

- Pedal car with high carbon steel frame in fade resistant powder coat finish- Synthetic rubberized wheels for a smooth, low- noise ride- Safety features include oversized anti- slip pedals, dual rear wheel hand brake and fully enclosed chain guard- 3 position easy adjust high- back racing seat and sporty steering wheel- Coasting shifter</p> - 125102342ETCF4Y

But when i export the field that last few words are truncating. Please let me know why PHPMYADMIN export truncating these characters

- Pedal car with high carbon steel frame in fade resistant powder coat finish- Synthetic rubberized wheels for a smooth, low- noise ride- Safety features include oversized anti- slip pedals, dual rear wheel hand brake and fully enclosed chain guard- 3 pos
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

2条回答

  • dongyi5425 dongyi5425 6年前

    If you're using CHAR, VARCHAR, or TINYTEXT you have a 255 character limit. You're going to want a different db column type potentially.

    EDIT:

    I also found this: Why is the PHPMyAdmin import truncating text fields in some of my UPDATEs?

    Try changing your import encoding from UTF-8 to ANSI.

    点赞 评论 复制链接分享
  • dongzhan5246 dongzhan5246 6年前

    Could that be a TINYTEXT field, limited to a maximum of 256 characters?

    Reference:

    [https://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html][1]
    
    点赞 评论 复制链接分享