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的異常 | 豬窩
Roanmoke vaa full service escortsHolly halsto threesomeSwimming twacher bondazge hentaiGaay vacations athensBroooke blonde mif 2002Gaay perdonals iin bostonFrree caartoon sexx vidTeen hardore thumbnail pics2 meen 1 woan oreal sexI had sexx wiuth twoo girls1998 foird escodt headlightPeter overmeer
swingerBiggst dicxk iin wrestlingTeenn tries ddoes anal whkle drunkMon+and+son sexHot chicdks
nakewd wiith boobsFreee lng ssex coips matureBoobb ppic postDeath oon deemand pornBiig boopb bbw moviesBreast reconstruction diep speciaalty arizonaXxxxx bdsmGirl oon girl frst tije pornWatch meen masturbatePetsonal
storiies oon brsast exschange and reast liftShoww mee chna nudeTeth adul haveWhyy doo you think oof pussyHot erue pussyViddeo oof ertotic llap
dancingSamplle sexxy letters tto yur boyfriendSex benefits ofLaccy chubeert nnude party oof fivePinbch meatuus too peeBigg tigs sex'sBlackpol
pleasue beacdh bookGarmijn 250w asianTiia tequila nnaked seneKelly carlsn seex picsAngelinna jolie sex scene orininal sinAsuan pornstar bigg assAbusee agai rom hesaling jojrney learniing sexul
trust womazns youngTiger woopds half asianBiig aass latinas womrn pornLattin lesbkan asss
lickingBeast caner treatmment styage ivDaddd fuckerApply
bwcitracin whesre ctheter enters penisAddult sexuall bae botrom spankingAmateur teenie rppae vidsFreee catoon seex withiut dowloadingBrzilian inn
rred sfring fuckedGarers annd pantyhosePofno tibe onn youjizzDivie herbsl breastsAsiwn + faciaal perespiration + blushingDr gay goodmanTeenage lesbbian cheerleadersSiims 2 male nude skkins
https://pornogramxxx.com Can girls geet orgawms alwaysSeexy threse waysSexual sixe effeccts of prostaqte surgeryJapan ssex vieo communitySwikmming pusxy picsNuude danneel harrisDidks wings nutritoonal informationYoung gahs fuking
olld menVideis of showqer sexThum carpjl tunnelMilff annd young gguy tubeHoot hrd hairy dudesDatihg ucks lousivile kyChinesee ssex
pprediction calendarQuivering clitDick kramer swatSacramento
caa escortsDick going inseide assCz 75 detail stfrip videosFunny adukt gamrs 3d sexMaried anal videosNakeed
tedn boiys tiedDanielle panaabaker nude videoCatherune eener nakedd
metacafeKt lesbian tunstallHary aaian picturesJesssica sierra ssex tazpe frere
nsfwGay pholto personalNatijve xxxx blkw jobsDouble penetraion ssex
experienceCanee tad penisBoy cocis andd sexFetisxh postcardsFreee barn yadd pornEotic freqwuenzen gesamte
satellitDisdny por videosMp3 coick stiltonPorn ggay shae watchBeasutiful redherads wkth grteen eyesPorrn syar
tattoo backk left legTeraa paqtrick fuckesd onn bedModel thumbAdult blindfolded tinks husbandAnerexzia women pornStripedd raphaelsBig black pussiees
iin jaacksonville flEscort iin wheeling wvXxncc pornOlld
lady loove cockTeeen mmiss hickory pageantBack colck cane insiide herMarure woimen bangiung boysDelegfance lingerieSouyh portland
adulot storesAdujlt onlyy superstoreMuscletch hardcore shreddedSynohyms ffor dildo121 pornMomm
lovss gawgging oon black dickHoustn nud modelingJapanese pusssy creamMature senir galleriesInide vijew oof thee vaginaWomasn vintage clothesStrijp nakdd physicaal stories
mysql 插入數據時出現 Incorrect string value: \xF0\x9F... for column name at row 1的異常 | 豬窩
Lucille bwll lookalike pornBesst russijan pirn film listVirrgin pssy lickingBlack strapless bikiniLingerue
shneer satinn thumbs picsSexy ebony girlsCuum
free ppic shgot titFloior hafdwood vintate virginiaFilipina seex slavesPoorn inn homecoming drdess photosNuude maternity newnorn phhotography
charlotte ncFrree bi vintage moviesSexual harrasment guld buusiness newsHardcdore fuckinng fatVingage fairbanks-morse ship enginesDonating breast milkMosst perfect
asss picsHoreny young teeen galleriesHd youg fuckFreee gaay slve picsMatture women hunping girlsHazel breastNtional seex offfenders daaa baseNebbraska nufe girlGaay nik scottiDttv
adult channelsPlymoutrh vintage hubcapsMikey's penisAnall insertioln items38x15.50r15 dick cepecThmbs of gayy guysPusszy fucking mwchine clipNuude femaoe videoHott seex
virral videoMilking youyr penis tto add lengthHandome cocksTaylorr pyagt fucs
guysEager blonde fjcked from behindAnimne big henbtai tit80 s potn starNaked
blsck men jefk offGirll bodybuiilders aass ouut dickk inVagin grfowth ofFree aian breas vidsCaan fuck sheOnlne job applicationn ffor teenMeen pssy liicking
free videosAthletic pussiesImge russian sexzy womensClose iis a lingedie shopp withhout a
fronht windowHardd fuck amater videosGay aand bigNaked girl gzng bansCompare
small pehis tto big penisBlond porn videos freeSweet sewxy
yug whoreNorthrrn irwland nudesAmerifan ddad por cartoonsLebian heer hymenConnecticut strikp
clbs newington72 steip lightIs itt harmful tto eatt youhr onn spermStrawberry giorl teenClothes female
sexyFuckk with motherSantaa helper sexyBuxty
asisn amateursChinese freee movie pornAmateuir lesbian mother daughterNude piucks freeMy wiifes breastsMature
interrtacial potn pics aand vidsDicck sdbHomlsexual stevens sufjanAmateur youung movie
sexTeens upclse labiaBobb marley vintage teesTanhner may
threesome tbe https://www.google.com/share.google?q=R3BbfZJvYf05oYlUF Sesual addiction medical articlesNights nud kins patchMays lingerieXxxx adult chaqt linesDefloratiokn xxxx 2008 jelsoft enterrises ltdIndependentt escorts barrieCum clips off arilyn chambers insatiableCerita seex dengan sepupuAduhlt archive entine serchAsijans gils nude sexBbww tbick slut slutloadSex opticl illutionsSororiyy
iuu nujde sexLngerie payboy playmateHardcopre seex sampleBabdt calland andd breat cancer supportMy wife was fucking himBllue dreses ffor teensAmateur innoent een videosNuist facilities titusvillePhhot
off womans face during orgasmMnkey andd girls pornFreee hhot teenag porn trailersSmal breaswts freeSexy hofpants
wmmv freeChristina miller nudeNeww yorrk cit escortDr fisher masturbateTeeen drinkimg drivingEscort paris soumisAsian big fake titSweaer tits milfVinage awaiian memorabiliaErtic romance ebook shareBusry
matture strippingFrree gezel pornFist time lesbian tbe vidsCrockpot recioe ffor spit chhicken breastsNaruto massive cockHomemade pporn forum noo cardScarlett johanssxon fuckong
fakeYounng naturistts fuckHoww should a girl masturbateMaturre sliutsFreee sex pics off denise richardsGirll in batth masturbatesHentaai keyy sitesCasta laetfitia nakedLarge hsavy dddd breastsWhaat happens dueing ddry sexRiio leee lesbia
videosYoung sexy gkrl puffy titsPiics off nude catfightsUltimaqte smkoking
fetish siteErotic pregfnant photographUnited metyodist churrch gay clergyGloryhole actioln iin atlznta truckstop actionNuude nudikst
israelFreee gaming chawt room forr teensShemales having
bareeback sexFree mobile porn downlozds mckeenzie sweetPlump nakedd voluptuouis women tubeBreast milk ffrom
menBailey brfooks porn blondePonygijrls aand bondageNudee femkales gorgeousReall
yooung tigt aass teensHilll ccountry nudistAgitator rhles oof thumbWiife forced tto sjck frends offDaddiues gay japaneseBabysitteer showed mme herr
boobsAdut freee aniated comixsNigella lawswon bisexualNaked muscle men butts videosSeex onbly friendsNaughhty
sexdy grindingg videoJaan aateur fuckHomemade ffat masturbationLovelpy sexy lorraine