Shulou(Shulou.com)06/01 Report--

Environmental Information:

Operating system: LNMP1.6

PHP version: 5.3.29 (NTS)

Dameng client version: DM_V7.6.0.161 client

PHP module: libphp53_dm.so

PHP configuration

Extension_dir = "/ usr/local/php/lib/php/extensions/"

Extension=libphp53_dm.so

[dm]

Whether persistent connections are allowed

Dm.allow_persistent = 1

The maximum number of persistent connections allowed. -1 means there is no limit.

Dm.max_persistent =-1

The maximum number of connections allowed (including persistent connections). -1 means there is no limit.

Dm.max_links =-1

; default address of the main library

Dm.default_host = 192.168.100.2

; default connection user name

Dm.default_user = SYSDBA

Default connection password.

Dm.default_pw = SYSDBA

Connection timed out, this parameter is not actually used, waiting for the server to support

Dm.connect_timeout = 10

For various variable length data types, the maximum number of bytes read per column. If it is set to 0 or less than 0, a null value is displayed when the variable length field is read

; dm.defaultlrl = 4096

Whether to read binary type data, if it is set to 0, then binary will be replaced by null value

Dm.defaultbinmode = 1

Whether to allow checking the validity of persistent connections. If set to ON, then when a persistent connection is reused, it will check whether the connection is still valid

Dm.check_persistent = ON

The port number of the connection

Dm.port = 5236

Phenomenon explanation

The following occurs when PHP uses DM's PDO module to read TEXT field data

1. Display normally when the data has 4113 characters

two。 When there are 4114-4116 data, only 4113 characters will be displayed.

3. When the data exceeds 4116, the character after 4113 will be abnormal, and the subsequent data does not match the original data.

Test process 1. Create a table

CREATE TABLE SYSDBA. TEXT_TEST (T_ID INT,T_TEXT TEXT)

two。 Insert test data

The total length of data in the test field is 4200 characters.

Insert into "SYSDBA". "TEXT_TEST" values (4200, 'liuyongjian,ylwenwen,ylcaiwf,ylchenj,ylliangn,ylhuangzh,yllinxu,ylsuls,ylhec,yzwenzx,yzdengl,ylhehq,ylligp,yljiangjy,liangjingmin,maiyixin,yllinlu,ylpub,ylliw,ylzhouxiong,ylchenz,ylzhailing,ylwangs,ylchenzs,yzlihs,wenwu,caoxiaoqun,ylchenxb,chenyan,ylhuangzf,ylliangyi,ylhuanghui,ylliyh,ylguanwz,ylwujian,ylbgs,ylsujm,ylyuandr,ylliny,yljiangys,ylchenx,ylchengq,ylyangz,ylsuw,ylyuh,ylchenyj,ylwangsq,ylyaozd,ylluob,ylzhonggx,ylhuangtj,ylhelj) Ylningyl,ylmingmt,ylyanggy,ylzhuyuchong,ylzhonggui,yllinyongyi,ylpengjq,ylsucx,ylchenyt,ylfangx,yllugs,yltanqq,yllill,ylpcj,ylliuqs,ylyangtl,ylpangbs,ylluos,yllvhh,ylliangj,ylliangf,ylouyzx,ylchendw,yljiangsd,ylzhengyb,yllixiaoli,yzlinys,blzhoudm,ylsuyu,xutr,ylhehuan,ylmasy,bblixyu,rxyangqj,ylyincong,ylqiupc,yllulijuan,ylhuangyy,ylhuangby,yldengcx,ylchentt,ylchenchi,ylchenyp,ylliangyu,ylchensh,ylchenm,ylhuangbc,yllib,ylchenmx,blganwq,ylzoulj,rxliun,luoxk,ylzhangxy,ylgey,yllimengKA0,yllianghy,yllihb,ylwuqiuling,ylliaohuiyan,ylweizr,ylliangkl,yltanz,ylluogs,ylchenfz,ylzhongx Ylpanbf,yljiangh,ylliyanz,ylzhangln,ylweiyx,ylchengy,ylweiyanran,ylchenglf,ylweilan,ylchenwj,ylpangz,ylcaiw,ylliangwq,yllinhq,bbchengj,bllvb,ylyangx,ylliqin,ylningting,yzliangxz,ylqiuzhan,ylchenww,ylchenhua,ylhuangh,ylpangly,ylchenxiaogang,bllim,ylluyn,ylzhousw,ylliuwy,ylhuanggs,ylliyz,ylleitm,ylzhangjg,yllust,ylhuanghq,ylluocs,ylheh,ylzhangnw,ylxumy,ylchenjs,yllianghui,ylzhangyz,ylzhongr,ylliangbi,ylsuxm,ylzhouhq,ylcaidy,ylyangqm,ylliyl,blzhongp,bbchenwn,ylyllijl,yllinjx,yllijy,ylchenchu,ylhuangsw,ylxuelf,ylyangzs,ylyaol,ylmoting,ylxieshuqiu,yltuhuan,ylliangp,ylhuangfy,yllixy Ylzhongbb,rxhuangjie,ylzhangwl,blqinhj,ylnixiangqin,ylhunagj,ylpangm,yllinzj,ylfengsq,ylliangyy,ylmohc,ylyedm,ylfancl,ylqinzy,ylzhangxg,ylhuangg,ylgaotm,ylchenyc,ylliangh,ylchenyu,bbpangan,ylhuangxm,ylzhouhb,ylyangyz,yllizf,ylylhuangjy,ylwenyy,yllinj,ylliangb,yljiangsl,ylwenfj,ylchenq,ylwuc,yllizq,ylliugb,ylsudb,yllinly,ylguangw,yllianghc,ylxuanzn,yllidz,ylylfjgyw,ylfjchz,ylfjqc,ylfjzzq,ylfjfyw,ylfjlyb,ylfjzy,yljiangmx,ylzhangheng,ylzhanglsh,ylch,ylzhangxh,ylwux,ylchenmk,ylxuzx,ylduf,ylchenyf,ylchendm,ylmoying,ylyanglan,ylqinhq,ylwenzs,ylluoj,ylcengyt,yljiangjl Ylpanghf,ylzhanghb,ylchenhj,ylzhoul,ylliangmd,yllink,yllimj,ylpangjc,ylzhoush,yllimh,yljianghb,yllaijq,ylhup,ylchengm,ylhuangxp,ylchenmj,lczhanyl,yzshayq,yzwuzj,yzhuangh,yzwuxuej,yzwenhx,yzchenp,yzluoxq,yzxujg,yzlvql,yzwuzl,qinxq,zhuling,yzganrj,yzdouyj,yzpenghuiq,yzhuangxw,yzweiql,yzzhoucm,yzchenqinghua,yztangmm,liuchun,yzlinfl,yzfuth,yzweiyeq,yzxiewt,yzyangyz,yzlaily,yzmocm,yzliangwein,yzhuangqiw,yzzengzhan,yzlijh,yzliangyy,yzlinjing,yzxuweilong,yztangj,yzcenzq,yzliss,yzxiew,yztangyun,yzlixx,yzxielf,yzyangbin,yzwens,yzlianghy,yzluoting,yzzhanghx,yzhuangy,yzchenyb Yzgucj,yzlin,yzfuyx,yzlix,yzchenjq,yzguojt,yzlinyunsi,yzmohaiw,yzchenyu1,yzwujie,yzluoquan,yzfengyul,yzxiaoboc,yzpanghui,yzxiaoyao,yzjiangyuand,yzliuguoy,yzluowei,yzliguiy,yzyangwenh,yzyinshaoy,yzchenwenj,yzwangdengw,yzfengliy,yzliaoyunh,yzpengqy,yzlvh,yzchenyu,yzlongk,yzwangj,yzweiyb,yzlipeizhen,yzzhangyiy,yzzhoujm,yzchenbolin,yzcdm,yzhuyi,yzliangjiemin,yzliumeiyan,yzwenxj,yzliangl,yzzhouxt,yzyangyl,yzliuym,yzzhujj,yzhuangyan,yzliangdj,yzlilm,yzhuangyany,yzpangminj,yzliaojuan,yzzhangxiongl,yzlihl,yzliangxl,yzchenhongjian,yzhuanglj,yzliyifan,yzmoujm,yzsuni,yzyanjiaj,yzyangsunwei,yzyzliujh,yzsunxh,yzhuangll,yzchenxm,yzliangjf Yzqinwh,yzlingmeim,yzchenl,yzliyongl,yzwuzhengh,yzliw,xytanggf,yzningfs,yzzhongqh,yzchenz,yzliangwd,yzliyj,yztanxf,yzcenggw,yzzhongmei,yzchenqd,yzyangx,yzhuangw,yzliangcg,yzzhongjh,yzchenrenp,yzzhoumengy,yztenghongl,yzzhulk,yztangwl,yztianzm,yzluoy,yzzhongj,yzchenglq,yzwucy,yzyuanl,yzchenj,yzgaosy,yzzhaos,yzyangsq,cheny,yzhuangjq,yzlik,yzliyq,yzhexiaod,yzkangshiz,yzmogx,yzmoshan,yzluol,yzjianglinghua,yzliangdanfeng,yzliangyw,yzsujing,yztangweiKA1,yzwangx,yzwengm,wenyinglin,yzyangzj,yzzhouhaiheng,yzhuangjc,yzliangb,yzzhouc,yzwentt,yzzhangzhih,yzliwenw,yztangyong,yzbaozh,yzheh,yzheyy,yzlvc,yzlvyuf Yzluoyex,yzzhengyy,yzsudl,yzhuangs,yzchena,yzxuang,yzwenyant,yzliangshuang,yzliubeijiang,yzyutong,yzyangcl,yzlic,yzkuangxs,yzliangw,yfjouid,efer,yvedfeindfs,sdfweffvwer,fwef,wef,wef,wef,we,f,wf,fwe,fw,efwe,f,wf,wef,w')

Commit

3.PHP query script

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.