mysql 插入數據時出現 Incorrect string value: '\xF0\x9F...' for column 'name' at row 1的異常
最近在用 Excel 檔匯入資料時,顯示 Error , 轉成 Csv 再匯入就正常, 查網,原來是有些 Utf8 圖型或造字用到 4碼(含)以上,而 Mysql 的 Utf8 內定3碼,解決方法網上是將內定 Utf8 3碼改成 character-set-server=utf8mb4 4碼,資料表也要更改(https://blog.csdn.net/m0_37983376/article/details/79224862)有修改方法,可是我改後無效,不知少了什麼,後來想,那些造字沒有顯示對網頁來說沒有那麼重要,所以想到一個取巧的方式,將這些字丟掉不存在就可以了,方法是,在 php 程式,將 utf8 轉成 big5 ,那些字就會用 "?" 代替,再將它轉回 Utf8 給網頁用,再樣那些字就給轉不見了, Csv 不用轉,因為它本來就是 big5,程式自動轉成 Utf8 ,指令如下:
if($type != "csv") //不是csv檔,$str 轉big5再轉回Utf-8,排除 utf8 4碼以上字及造字,mysql utf8 內定三碼
{
$str5 = mb_convert_encoding($str, "big5" , "UTF-8");
$str = mb_convert_encoding($str5, "UTF-8", "big5");
}
迴響
mysql 插入數據時出現 Incorrect string value: \xF0\x9F... for column name at row 1的異常 | 豬窩
Verry nice post. I just stuymbled upon your weblog annd wiswhed to say that I have reaally enjoyed surfjng around your blog posts.
In any case I will bbe subscribing to your
feed and I hope yyou write agaiin soon!
mysql 插入數據時出現 Incorrect string value: \xF0\x9F... for column name at row 1的異常 | 豬窩
Youu really makle it seem sso easy with your preesentation buut I find this topic tto be really someting which I think I would
never understand. It seems too complicated and very brod ffor me.
I'm looking fotward foor your next post, I wijll tryy to geet the haqng of it!
mysql 插入數據時出現 Incorrect string value: \xF0\x9F... for column name at row 1的異常 | 豬窩
We absolutely love yourr blog and fund almoswt all oof your post's tto be precisely wbat I'm lookingg for.
Dooes oone ofer guestt writerrs tto wrkte content foor yourself?
I wouldn't mjnd publishing a pist orr elaborating on a few of thhe subjects you write about here.
Again, awesome blog!
mysql 插入數據時出現 Incorrect string value: \xF0\x9F... for column name at row 1的異常 | 豬窩
Wow, wonderful blig layout! Howw long havce yyou been blogging for?
yoou made blogging look easy. Thhe ovewrall look of
yokur web sijte is great, let alone thhe content!
mysql 插入數據時出現 Incorrect string value: \xF0\x9F... for column name at row 1的異常 | 豬窩
Excellent good from you, man. I have understand you stuff
previous too andd you're just extremely wonderful.
I eally like what yyou havee acquired here, certaiinly like what you are stating aand tthe wway iin whjch youu sayy it.
You makke it enjioyable annd yyou still caee for too
keep it smart. I ccan not wait to read much more from you.
Thiss iis really a tremndous wweb site.