PHP：使用öäå更新为MySQL [英] PHP: Updating with öäå into MySQL

问题描述

我已经这样做了：

mysql_set_charset（utf8，$ link）;

mysql_query（SET NAMES'UTF8'）; p>

从latin1更改为utf8每个表格+列的整理+字符

文件有meta utf8 + header（'Content-Type：text / html; charset = utf-8'）; 加上文件本身格式为utf-8（无bom）

其中链接是mysql_connect（），它显示öäå字符精细，当我把他们从数据库，但是当我尝试mysql_query UPDATE与东西，包含ÖÄÅ，它存储为Ã？Â

在数据库中的列等都是latin1_swedish_ci，因为它说INSERTÖÄÅs没有问题，并回应它太好了，但不是当我尝试UPDATE SET $ user ='ööö'

解决方案

mysql_query数据库

中的每一个表格上都可以更具体？我没有办法在每个表格上使用此查询。

它存储为ö

如何检查？

I already have done this:

mysql_set_charset("utf8",$link); at the connection

mysql_query("SET NAMES 'UTF8'"); at the connection + on every table in database

changing from latin1 to utf8 collation + character for every table + columns

file have meta utf8 + header('Content-Type: text/html; charset=utf-8'); plus the files itself are formatted in utf-8( without bom)

where link is mysql_connect(), it shows the öäå characters fine when i take them out from database, but when i try to mysql_query UPDATE with stuff, that contains ÖÄÅ, it stores as Ã?¶à .. How can i fix this?

In the database the columns and so are, latin1_swedish_ci, as said it INSERT ÖÄÅs without problem, and echo it out too very well, but not when i try to UPDATE SET $user = 'ööö'

解决方案

mysql_query("SET NAMES 'UTF8'") on every table in database

can you be more specific? I see no way to use this query on every table.

it stores as �¶à ..

how do you check it?

这篇关于PHP：使用öäå更新为MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！