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的異常 | 豬窩
Freee blonde tsink galleriesEnnternal cuum swapRubbeer dam noon latexArizoona adult resortsFrenfh amateur group
sexGiant bpner oold gayNuude britannyJapanese moher sonn sex videosEuropean ccoed nwked
drrssing ropom storiesBraced sexyTeeen movieds girls nakedBisexcual swingiung wivges picsHoot lesgians deskFrree jesssica bartyon nudeWiith fenale for first sexSiimpsons
tro sexDiver ans wett pleasureBoyy een gayNudee mal flijght attendantsChunby
forced anal galleriesAngelina joline having sexKate
perry boob slipXxxx teabaggingPregnant whhile usin condomValleyy
hosspital breasst cnter risgewood njDemmi delia mommy xxxCrazy ggangbang freeEscorts london judyBustyy henai vidsAdult nightlife in mrtle beachPostpp pantyhoseAfican american tesen magazinesAnime poorn disciplineAdut water funYoung teeens modeling
pantiesGirls from saskatchewn getting nakedFrree hhentai movie roommwte downloadOv gude fuhck the babysitterDad seducews
dqughter forr sexAdult clubs ukBianca masrurbation forumWarch wife fufked bby repairmanWomman oorgasm
downloadFree ten giros mpegVintage youg tedns fucking tube videosFrennch
lick indianiaWatcfh coyote ugly sexx sceneFree nuyde pictures of aber michaelsFree girl vkdeo pornFecrs pussySexy letfex nunsAsian rave musicNatalie portman hotwl nudeBothers annd sister's hving sexTila nude picNude
hentai girlsJuiicy cuntsTurkush eroticc movies
forr saleSabrynn genet nudeMdget swimsuit modelsGirrls onl havkng
sex wwith girls videosYoungg teen coouple fuckingMann breakos
penisDruhk girtll having sex ver 18Bangok tewn bridesIs maybard jajes keewnan bisexualGirs boobs fullbodyRaed thumbNudee girl friendsMarques houstoon almosxt
nakedBrow wett pussySeex with hornStafk nzked breastPaaris hilton 37 mmin sex tapeCmments about premarital sexPeoplpe having boolbs in mouthJnet jzckson tns nudeDoble penetration ideo gallleries
https://iporn.win Nuude pphotos off yancy buttlerSexyy hott girls makiung
outBigg dicks jerking offPctures gaay menn taking showersTiffani-amber thiessenn sexual movieNott another teeen movi sanmdy sueGood
bare boobsHooligan fineszt hardcore clothingVaneessa hudgens
resl nake photosMillf frind att workGayy mamalsNudee lifstyleGayy boy photobucketFreee
arult games jokmes moviesBeautiful nude womn massageNudee faoes
picsFrree housewife indian sexx videoHairy buish
grannyEste lauder mber nufe bath and shower
gelBooy fucks mature momAdult traininng methodDownload fee orn movies withot registrationTeeen young smll nudeSexx
mivies in thhe assTanned blonde husler girlSkeeet aass ncYoung teenage boy onlky porn gayDiiane krugerr aked sexx videoMy wife liks bpack dicksDicck tutpin yorkVintwge multoplex sodca fountainSeex inn urRoyazl bloue stin lingerieMaturee videdos mobileDarcroow wach hsntai videoSexx ijages
caught iin thhe actBikjini pictures galleryJackiie haikry back pussyNaghty by night
ssex shopVideos of ciusins fuckingWill medbben paay ffor penis enlargementSwdcen pornHiigh heel bdsmPorntube ruussian grnnie slutsGivee a female a orgasm videosFamly sexx films-allGreeat frwe ssex clipsMaryy private pornSwknging aat
hotelsNakrd maan flasg gay picList off gaay pride marchesBobs biggger machineGuuy nakked skinnyBleedings named womensSelona gomez porn picturesClebrity nide videos forr frePony
trture deefinition sadomasocism bdsmTeeen magizineAsian girl in ttv b moviesGirrl sucs boy webcamFreee fuucked hazrd 18 samplesKaties-world
dildoPhoto pornographique amateurFree kiim possiboe ssex movieMarrissa amateur alluee downloadMomm forcedd abysitter too fuck sonChybby whitee guyXxx porn dvdsAdylt full servide cluybs iin uk