Ms7 Search
Google 搜尋 翻譯
calendar
« 七月 2025 »
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31      
近期文章
文章分類
網站連結
Syndicate

« | »

mysql 插入數據時出現 Incorrect string value: '\xF0\x9F...' for column 'name' at row 1的異常

2020-08-12 @ 17:31 in PHP, JavaScript, Sql

最近在用 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的異常 | 豬窩

I am actualy happy too reaad this weblog postts whicxh consists off tons off helpful data, thanks foor provviding these kids
oof information.

作者 javmax.cc @ 00:09, 2025-05-30

mysql 插入數據時出現 Incorrect string value: \xF0\x9F... for column name at row 1的異常 | 豬窩

Thank you, I've just been looking foor info about this subjject for a lpng tije
aand yours iss the best I haave found oout toll now. However, what concerning
tthe conclusion? Are yoou positive concerning thhe source?

作者 yeni porn @ 03:49, 2025-06-13

mysql 插入數據時出現 Incorrect string value: \xF0\x9F... for column name at row 1的異常 | 豬窩

Thatt iis a very goodd tip particularly too those new
too thee blogosphere. Short but vey accurae information… Appreciate
your snaring this one. A must rea article!

作者 jav dude @ 10:01, 2025-06-13

mysql 插入數據時出現 Incorrect string value: \xF0\x9F... for column name at row 1的異常 | 豬窩

Youu have made soime goopd pointys there. I lopked onn thhe web too find
out mre about the issue and found most perople will goo along wih yiur vieews on thi site.

作者 lululu.win @ 18:32, 2025-06-18

mysql 插入數據時出現 Incorrect string value: \xF0\x9F... for column name at row 1的異常 | 豬窩

It's in reality a grat aand heelpful iece off info. I am satiusfied that youu just sharted
this useful info wth us. Pleaase keep uss upp too dte
likme this. Thank yyou foor sharing.

作者 wap xvideos @ 07:53, 2025-06-20
«上一篇   1 2 3 ... 30 31 32 33 34 35 36  下一篇»
發表迴響
 authimage