数据库中的数据本身就存在乱码,如某条记录 1941 | 1 | 0 | 11 | 255 | 255 | 0 | 2011-08-15 11:01:51 | 0 | 0 | A 莽?郝该ε铰ッヅ?懊?嘎??仿? 但我不能去更改数据库的数据,后台我用php去查数据库,将获得的数据转为json string,这样前端解析包含乱码的json string就报错 用json验证工具也通不过 Parse error on line 16:
... "dpi": "A 莽?郝该ε铰ッヅ?懊?嘎??仿?",
----------------------^
Expecting 'STRING', 'NUMBER', 'NULL', 'TRUE', 'FALSE', '{', '['
其它数据库没有乱码的都是正常的! 我现在的问题是我从后台传过来的包含乱码的json string会造成前端js报错,这样就影响用户使用,有什么办法可以让乱继续显示而js 不报错?
回复讨论(解决方案)
你的编码是gb2312的?
用了ajax?
1、你在数据库里看也是乱码吗?如果不是,那是什么?
2、是否仅回避掉报错就可以了
你的编码是gb2312的?
用了ajax?
html页面时用utf8 用的jquery ajax 数据库是mysql charset=latin1 php我已经用相关函数转码了 转出来的和数据库是一致的
即命令行下用 set charset latin1; 然后再select是一致
1、你在数据库里看也是乱码吗?如果不是,那是什么?
2、是否仅回避掉报错就可以了
数据库中存在乱码,是别人插入时产生的 不是转码的问题 就是取出来本身乱码的数据 用json传到前台js解析时报错,而我的意思就是要让乱码可以显示,只要与数据库一致就行
1、你在数据库里看也是乱码吗?如果不是,那是什么?
2、是否仅回避掉报错就可以了
{
"id": 1936,
"name": "220kV母线保护IRCS915AB",
"ft": 11,
"dpit": 4,
"dpi": "$?韫?",
"time": "2011-08-17 09:16:04",
"info": "3_20110817091604.txt"
}
js解析到dpi时就会报非法字符错误
你贴出读出数据的 bas64 编码
做法是
读取有乱码的记录,比如读到变量 $s 中
然后 echo base64_encode($s);
贴出结果
你贴出读出数据的 bas64 编码
做法是
读取有乱码的记录,比如读到变量 $s 中
然后 echo base64_encode($s);
贴出结果
使用了base64_encode(mb_convert_encoding($string, 'utf-8', 'gbk'))后:
JAMF56KeCwjpn6s/YQ0FCAE=
我只要 base64_encode($string) 的结果
你转码了,就把现场破坏了
我只要 base64_encode($string) 的结果
你转码了,就把现场破坏了
不好意思,刚才那个是我自己在mysql类中自动处理的
这个没有转码JAOyBbROCwjouay/YQ0FCAE=
我只要 base64_encode($string) 的结果
你转码了,就把现场破坏了
搞定 json字符串里包含非法字符 转义一下就行了 谢了!
我只要 base64_encode($string) 的结果
你转码了,就把现场破坏了
搞定 json字符串里包含非法字符 转义一下就行了 谢了!
如何转义的

Laravel simplifies handling temporary session data using its intuitive flash methods. This is perfect for displaying brief messages, alerts, or notifications within your application. Data persists only for the subsequent request by default: $request-

The PHP Client URL (cURL) extension is a powerful tool for developers, enabling seamless interaction with remote servers and REST APIs. By leveraging libcurl, a well-respected multi-protocol file transfer library, PHP cURL facilitates efficient execution of various network protocols, including HTTP, HTTPS, and FTP. This extension offers granular control over HTTP requests, supports multiple concurrent operations, and provides built-in security features.

Laravel provides concise HTTP response simulation syntax, simplifying HTTP interaction testing. This approach significantly reduces code redundancy while making your test simulation more intuitive. The basic implementation provides a variety of response type shortcuts: use Illuminate\Support\Facades\Http; Http::fake([ 'google.com' => 'Hello World', 'github.com' => ['foo' => 'bar'], 'forge.laravel.com' =>

Do you want to provide real-time, instant solutions to your customers' most pressing problems? Live chat lets you have real-time conversations with customers and resolve their problems instantly. It allows you to provide faster service to your custom

Laravel's service container and service providers are fundamental to its architecture. This article explores service containers, details service provider creation, registration, and demonstrates practical usage with examples. We'll begin with an ove

PHP logging is essential for monitoring and debugging web applications, as well as capturing critical events, errors, and runtime behavior. It provides valuable insights into system performance, helps identify issues, and supports faster troubleshoot

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

The article discusses adding custom functionality to frameworks, focusing on understanding architecture, identifying extension points, and best practices for integration and debugging.


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

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SublimeText3 Chinese version
Chinese version, very easy to use

SublimeText3 English version
Recommended: Win version, supports code prompts!

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

Dreamweaver CS6
Visual web development tools

WebStorm Mac version
Useful JavaScript development tools