php中写入中文到mysql乱码问题_MySQL
在写我的日记本程序的时候发现一个问题，当把文本提交到mysql时，发现数据库中的文本全部乱码了，但是读取的时候又完全正常。。。因为准备把typecho里面写的日记内容转出来在导入数据库的时候读取出来就全部是问号。google后找到解决办法。记录下
首先在create table的时候就应该指定charset为utf8（如果用phpmyadmin可以选择utf8-general-ci或者是gbk编码），but。。。如果仅仅这样做了还是会跟我一样发现写入到数据库的时候是一堆乱码-_-||。我就是在这里饶了很久，明明把编码设置对了的为何还是一堆拉丁符号呢！！！
经过一番探索，发现只需要在php中读取和写入的时候设置字符集才行。面向对象的方法就用mysqli::set_charset();面向过程的话就用mysqli_set_charset(),参数设置为utf8或者gbk，测试，正常:)
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
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
Google Pixel 9 and Pixel 9 Pro rumoured to gain Creative Assistant AI upon release
Jun 22, 2024 am 10:50 AM
Currently, four new Pixel smartphones are anticipated to land this autumn. To recap, the series is rumoured to feature thePixel 9 and Pixel 9 Pro at launch. However, the Pixel 9 Pro will be a rival to the iPhone 16 Pro rather than a Pixel 8 Pro (curr
Google AI announces Gemini 1.5 Pro and Gemma 2 for developers
Jul 01, 2024 am 07:22 AM
Google AI has started to provide developers with access to extended context windows and cost-saving features, starting with the Gemini 1.5 Pro large language model (LLM). Previously available through a waitlist, the full 2 million token context windo
Google app beta APK teardown reveals new extensions coming to Gemini AI assistant
Jul 30, 2024 pm 01:06 PM
Google's AI assistant, Gemini, is set to become even more capable, if the APK teardown of the latest update (v15.29.34.29 beta) is to be considered. The tech behemoth's new AI assistant could reportedly get several new extensions. These extensions wi
Google Tensor G4 of Pixel 9 Pro XL lags behind Tensor G2 in Genshin Impact
Aug 24, 2024 am 06:43 AM
Google recently responded to the performance concerns about the Tensor G4 of the Pixel 9 line. The company said that the SoC wasn't designed to beat benchmarks. Instead, the team focused on making it perform well in the areas where Google wants the c
Google Pixel 9 Pro XL gets tested with desktop mode
Aug 29, 2024 pm 01:09 PM
Google has introduced DisplayPort Alternate Mode with the Pixel 8 series, and it's present on the newly launched Pixel 9 lineup. While it's mainly there to let you mirror the smartphone display with a connected screen, you can also use it for desktop
Google Pixel 9 smartphones will not launch with Android 15 despite seven-year update commitment
Aug 01, 2024 pm 02:56 PM
The Pixel 9 series is almost here, having been scheduled for an August 13 release. Based on recent rumours, the Pixel 9, Pixel 9 Pro and Pixel 9 Pro XL will mirror the Pixel 8 and Pixel 8 Pro (curr. $749 on Amazon) by starting with 128 GB of storage.
New Google Pixel desktop mode showcased in fresh video as possible Motorola Ready For and Samsung DeX alternative
Aug 08, 2024 pm 03:05 PM
A few months have passed since Android Authority demonstrated a new Android desktop mode that Google had hidden away within Android 14 QPR3 Beta 2.1. Arriving hot on the heels of Google adding DisplayPort Alt Mode support for the Pixel 8 and Pixel 8
Google opens AI Test Kitchen & Imagen 3 to most users
Sep 12, 2024 pm 12:17 PM
Google's AI Test Kitchen, which includes a suite of AI design tools for users to play with, has now opened up to users in well over 100 countries worldwide. This move marks the first time that many around the world will be able to use Imagen 3, Googl
