Mysql入库汉字被截断问题
比如我在文本框输入“公园约会你懂的，”或者“我要上传媒大学”，那么最近写入数据库的是“公园约会”或者“我要上”，已经检查数据库正路字段,都是 utf8_general_ci。
补充说明：将内容输入到Title中，可以完整入库，不会被截断
我在本地用APMServ5.2.6假设环境测试没有这种问题，
本地环境
PHP版本： 5.2.6
MySQL版本： 5.1.28-rc-community
操作系统 Windows NT R780 6.1 build 7600
服务器环境： 出现被截断问题
PHP版本： 5.3.6
MySQL版本： 5.0.96-log
操作系统 Windows NT P3NW8SH241 6.0 build 6002 (Windows Server 2008 Standard Edition Service Pack 2) i586
补充：
经过测试，将body字段的整理改成gb2312_chinese_ci或者Gbk 就不会出现截断的问题，前台会显示，但显示的是“?? 媒 ?? 懂得 ”，请大家帮忙指点迷津
回复讨论(解决方案)
1.长度
2.编码
适当的调整字段长度
操作数据 先SET NAMES "XXXX";
神奇的编码~！！
楼上的方法应该能解决乱码问题~！！！！
神奇的编码~！！
楼上的方法应该能解决乱码问题~！！！！
set names "gb2312" 我经常这么干~！！！但很烦的说。。有木有啥一劳永逸的办法？？
引用 2 楼 virus1992 的回复:神奇的编码~！！
楼上的方法应该能解决乱码问题~！！！！
set names "gb2312" 我经常这么干~！！！但很烦的说。。有木有啥一劳永逸的办法？？
数据库创建的时候，就设成统一的字符集。页面是UTF-8，数据库默认字体和数据表字段字体都为UTF8；页面是GB2312的，数据库设成GBK。
你在服务器上用 phpmyadmin 插入同样的数据，也会被截断吗？
如果会，那么是 mysql 的版本问题
如果不会，那么就是你的程序问题
你在服务器上用 phpmyadmin 插入同样的数据，也会被截断吗？
如果会，那么是 mysql 的版本问题
如果不会，那么就是你的程序问题
phpmyadmin 插入不会截断，本地测试没有问题，但是服务器上会出问题，因此我觉得应该是程序的问题，目前还没有找到
1.长度
2.编码
适当的调整字段长度
操作数据 先SET NAMES "XXXX";
phpmyadmin 直接插入不会被截断，这里说的截断是指出现个别汉字会被截断
编码问题先解决吧～
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1655
14
1414
52
1307
25
1254
29
1228
24
Explain JSON Web Tokens (JWT) and their use case in PHP APIs.
Apr 05, 2025 am 12:04 AM
JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,
How does session hijacking work and how can you mitigate it in PHP?
Apr 06, 2025 am 12:02 AM
Session hijacking can be achieved through the following steps: 1. Obtain the session ID, 2. Use the session ID, 3. Keep the session active. The methods to prevent session hijacking in PHP include: 1. Use the session_regenerate_id() function to regenerate the session ID, 2. Store session data through the database, 3. Ensure that all session data is transmitted through HTTPS.
How do you handle exceptions effectively in PHP (try, catch, finally, throw)?
Apr 05, 2025 am 12:03 AM
In PHP, exception handling is achieved through the try, catch, finally, and throw keywords. 1) The try block surrounds the code that may throw exceptions; 2) The catch block handles exceptions; 3) Finally block ensures that the code is always executed; 4) throw is used to manually throw exceptions. These mechanisms help improve the robustness and maintainability of your code.
Explain different error types in PHP (Notice, Warning, Fatal Error, Parse Error).
Apr 08, 2025 am 12:03 AM
There are four main error types in PHP: 1.Notice: the slightest, will not interrupt the program, such as accessing undefined variables; 2. Warning: serious than Notice, will not terminate the program, such as containing no files; 3. FatalError: the most serious, will terminate the program, such as calling no function; 4. ParseError: syntax error, will prevent the program from being executed, such as forgetting to add the end tag.
What is the difference between include, require, include_once, require_once?
Apr 05, 2025 am 12:07 AM
In PHP, the difference between include, require, include_once, require_once is: 1) include generates a warning and continues to execute, 2) require generates a fatal error and stops execution, 3) include_once and require_once prevent repeated inclusions. The choice of these functions depends on the importance of the file and whether it is necessary to prevent duplicate inclusion. Rational use can improve the readability and maintainability of the code.
PHP and Python: Comparing Two Popular Programming Languages
Apr 14, 2025 am 12:13 AM
PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.
PHP: A Key Language for Web Development
Apr 13, 2025 am 12:08 AM
PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7
What are HTTP request methods (GET, POST, PUT, DELETE, etc.) and when should each be used?
Apr 09, 2025 am 12:09 AM
HTTP request methods include GET, POST, PUT and DELETE, which are used to obtain, submit, update and delete resources respectively. 1. The GET method is used to obtain resources and is suitable for read operations. 2. The POST method is used to submit data and is often used to create new resources. 3. The PUT method is used to update resources and is suitable for complete updates. 4. The DELETE method is used to delete resources and is suitable for deletion operations.
