php关联数组中的值字符串是否有限制?
Is there a limit on a value string in php Associative array?
我有一个查询,它以数组元素的CSV格式返回GROUP_CONCAT的值.当我直接运行查询时,我看到所有值都被返回.当我在PHP中打印数组时,字符串将被截断.
I have a query that returns value of GROUP_CONCAT as CSV for an array element. When I run the query directly, I see all values being returned. When I print the array in PHP, the string is truncated.
不确定如何解决? 有什么想法吗?
Not sure how get around it? Any ideas?
更多信息: 我只是var_dump从查询中得到的结果.这里是. 它显示为1024.看起来有限制.什么事?
More info: I just var_dump the results I got from query. Here it is. It shows 1024. Looks like there is a limit. What is it?
array(5) { ["FIELD_ID"]=> string(3) "232" ["answers"]=> string(1024) "48,50,52,54,56,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192," ["ANSWER_TYPE"]=> string(2) "SS" ["FIELD_TYPE"]=> string(2) "DA" ["main_field_name"]=> string(0) "" }更多信息: 即使将变量group_concat_max_len设置为5000,问题仍然存在.还有其他想法吗? PDO有任何问题吗?
More Info: The issue still exists even after setting the variable group_concat_max_len to 5000. Any other ideas? Any issues with PDO?
重启MySQL后,它可以工作了.谢谢!
After restarting MySQL, it works. Thanks!
推荐答案您可能需要阅读最大连接数的长度此处.
You might need to read up on the length of the max concat here.
Command-Line Format --group_concat_max_len=# Option-File Format group_concat_max_len Option Sets Variable Yes, group_concat_max_len Variable Name group_concat_max_len Variable Scope Global, Session Dynamic Variable Yes -- Permitted Values Platform Bit Size 32 Type numeric Default 1024 Range 4 .. 4294967295 -- Permitted Values Platform Bit Size 64 Type numeric Default 1024 Range 4 .. 18446744073709547520我发现返回给您的字符串的长度为1024,这很可笑-恰好是mysql中的默认最大长度.巧合吗?
I find it rather amusing that the string that is returned to you is 1024 in length - which just happens to be the default max length in mysql. Coincedence?
更多推荐
数组PHP中值的最大大小
发布评论