Fckeditor inserts special characters into mysql and is truncated. how can this problem be solved?
Source: Internet
Author: User
Fckeditor inserts special characters into mysql and is truncated. Fckeditor2.6 + mysql5.0.51b + php5.2.6 webpage GB2312, mysql is also GB2312, other conditions are normal, but when a special character is encountered in the Fckeditor file, text after special characters is truncated. for example, the year, month, and day automatically entered in the word are inserted into the Fckeditor on October 31, Year 12, and special characters in mysql are truncated.
Fckeditor2.6 + mysql5.0.51b + php5.2.6
The webpage GB2312 and mysql is also GB2312,
In other cases, it is normal that only the text after the special characters is truncated when the word document is pasted in Fckeditor. for example, the year, month, and day automatically entered in word are counted as March 15, year 12, and only two, and later in. If the text or chart is left behind, it is also truncated.
How can this problem be solved? You have a hard time.
------ Solution --------------------
It is not truncated in fckeditor. It is truncated when the database is imported. Then you can modify the program.
------ Solution --------------------
Is there a problem with the database field length?
------ Solution --------------------
Discussion
Is there a problem with the database field length?
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service