Question

我有一个行文——附有表格条款。

I want to convert the title, and content field to utf8 now - all data looks like this: ×¤×•×¨×˜×œ ×¨×¢×œ × ×¤×ª×— ×¨×©×ž×™×ª! I want it to become normal hebrew characters.

增编

Answer 1

你可以从这一数据库中抽取我的原木。随后下载了“Notepad++”、露天倾销文档、将其转换为“UTF8”,然后通过档案把所有编码替换到包括第一家“SET 不结盟运动”运营商在内的utf-8。

如果您通过phpMyAdmin(在缺省的情况下)进行倾销,则使用输出档案,编码ISO-8859-1而不是UTF-8,因为你可以默认。

Answer 2

在双重编码后,MySQL的以下功能将恢复正确的直观8:

CONVERT(CAST(CONVERT(field USING latin1) AS BINARY) USING utf8)

可以通过一份最新资料加以利用,纠正以下领域:

UPDATE tablename SET field = CONVERT(CAST(CONVERT(field USING latin1) AS BINARY) USING utf8);

Answer 3

if you need to convert the whole database , you can back it as databaseback.sql file then form your command line iconv -f latain -t utf-8 < databaseback.sql > databaseback.utf8.sql

you can use the http://www.php.net/manual/en/function.iconv.php
to convert each row in php in case you don t have command line access

最后,不要忘记改变在“Sandmyadmin”的每一个领域之间的串通,那么,你可以轻易地将“utf8”退回。

<>>>>

如果您没有被承认为,这意味着你没有<条码>。安装

much more easier solution is : Migrating MySQL Data to Unicode

http://daveyshafik.com/archives/166-migration-mysql-data-to-unicode.html>

Answer 4

您可以撰写少量的、与转换成正文的文稿。 See http://www.php.net/manual/en/Function.mb-detect-encoding.php and

http://www.php.net/manual/en/Function.mb-detect-encoding.php#102510"rel=“nofollow”http://www.php.net/manual/en/Function.mb-detect-encoding.php#102510

在假体编码中,这种说法是荒谬的。类似:

str = getDataAsString()
if(!isUTF8(str)) {
  str = convert2UTF8(str)
}
saveStr2DB()

Answer 5

审判

ALTER TABLE `tablename` CHANGE `field_name` `field_name` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL

友情链接