MyDump output issue
Posted: Fri 24 Apr 2009 01:20
I am experiencing issues using the myDump component in that it produces the following output:
-- Dumping data for table `e100`
--
LOCK TABLES `e100` WRITE;
/*!40000 ALTER TABLE `e100` DISABLE KEYS */;
INSERT INTO `e100` VALUES
(23066, '1', NULL, 1, 0, NULL, 'PADLOCK', '', 'Abus 72/40 padlock', 'A\0B\0U\0S\0 \07\02\0/\04\00\0 \0P\0A\0D\0L\0O\0C\0K\0,\0 \0K\0E\0Y\0E\0D\0 \0A\0L\0I\0K\0E\0,\0 \0C\0O\0L\0O\0U\0R\0 \0R\0E\0D\0 \0E\0N\0G\0R\0A\0V\0E\0D\0 \0W\0I\0T\0H\0 \0I\0D\0 \0N\0U\0M\0B\0E\0R\0S\0 \0A\0N\0D\0 \0L\0E\0T\0T\0E\0R\0S\0 \0\"\0M\01\0\"\0 \0T\0H\0R\0U\0 \0\"\0M\02\00\0\"\0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'N', 0, 0, NULL, 1, 'A\0b\0u\0s\0 \07\02\0/\04\00\0 \0p\0a\0d\0l\0o\0c\0k\0,\0 \0K\0e\0y\0e\0d\0 \0a\0l\0i\0k\0e\0,\0 \0c\0o\0l\0o\0u\0r\0 \0r\0e\0d\0 \0e\0n\0g\0r\0a\0v\0e\0d\0 \0w\0i\0t\0h\0 \0I\0D\0 \0n\0u\0m\0b\0e\0r\0s\0 \0a\0n\0d\0 \0l\0e\0t\0t\0e\0r\0s\0 \0\"\0M\01\0\"\0 \0t\0h\0r\0u\0 \0\"\0M\02\00\0\"\0', 0, 0, 0, NULL, 0, 'TRUENERG', 'OK', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, 0),
(23067, '2', NULL, 1, 0, NULL, 'PADLOCK', '', 'Abus 72/40 padlock', 'A\0B\0U\0S\0 \07\02\0/\04\00\0 \0P\0A\0D\0L\0O\0C\0K\0,\0 \0K\0E\0Y\0E\0D\0 \0A\0L\0I\0K\0E\0,\0 \0C\0O\0L\0O\0U\0R\0 \0R\0E\0D\0 \0E\0N\0G\0R\0A\0V\0E\0D\0 \0W\0I\0T\0H\0 \0I\0D\0 \0N\0U\0M\0B\0E\0R\0S\0 \0A\0N\0D\0 \0L\0E\0T\0T\0E\0R\0S\0 \0\"\0N\01\0\"\0 \0T\0H\0R\0U\0 \0\"\0N\02\00\0\"\0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'N', 0, 0, NULL, 1, 'A\0b\0u\0s\0 \07\02\0/\04\00\0 \0p\0a\0d\0l\0o\0c\0k\0,\0 \0K\0e\0y\0e\0d\0 \0a\0l\0i\0k\0e\0,\0 \0c\0o\0l\0o\0u\0r\0 \0r\0e\0d\0 \0e\0n\0g\0r\0a\0v\0e\0d\0 \0w\0i\0t\0h\0 \0I\0D\0 \0n\0u\0m\0b\0e\0r\0s\0 \0a\0n\0d\0 \0l\0e\0t\0t\0e\0r\0s\0 \0\"\0N\01\0\"\0 \0t\0h\0r\0u\0 \0\"\0N\02\00\0\"\0', 0, 0, 0, NULL, 0, 'TRUENERG', 'OK', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, 0),
(23068, '3', NULL, 1, 0, NULL, 'PADLOCK', '', 'Abus 72/40 padlock', 'A\0B\0U\0S\0 \07\02\0/\04\00\0 \0P\0A\0D\0L\0O\0C\0K\0,\0 \0K\0E\0Y\0E\0D\0 \0A\0L\0I\0K\0E\0,\0 \0C\0O\0L\0O\0U\0R\0 \0R\0E\0D\0 \0E\0N\0G\0R\0A\0V\0E\0D\0 \0W\0I\0T\0H\0 \0I\0D\0 \0N\0U\0M\0B\0E\0R\0S\0 \0A\0N\0D\0 \0L\0E\0T\0T\0E\0R\0S\0 \0\"\0O\01\0\"\0 \0T\0H\0R\0U\0 \0\"\0O\04\00\0\"\0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'N', 0, 0, NULL, 1, 'A\0b\0u\0s\0 \07\02\0/\04\00\0 \0p\0a\0d\0l\0o\0c\0k\0,\0 \0K\0e\0y\0e\0d\0 \0a\0l\0i\0k\0e\0,\0 \0c\0o\0l\0o\0u\0r\0 \0r\0e\0d\0 \0e\0n\0g\0r\0a\0v\0e\0d\0 \0w\0i\0t\0h\0 \0I\0D\0 \0n\0u\0m\0b\0e\0r\0s\0 \0a\0n\0d\0 \0l\0e\0t\0t\0e\0r\0s\0 \0\"\0O\01\0\"\0 \0t\0h\0r\0u\0 \0\"\0O\04\00\0\"\0', 0, 0, 0, NULL, 0, 'TRUENERG', 'OK', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, 0),
when it should appear as below which is produced by mySQLDump and other similar utilities:
-- Dumping data for table "e100"
--
/*!40000 ALTER TABLE "e100" DISABLE KEYS */;
INSERT INTO "e100" ("id_item","id_Source","id_site","id_eas","id_eid","id_enc","ds_enc","ds_designtype","ds_src_name","ds_src_desc","ds_part_name","ds_src_part","ds_src_manuf","ds_src_furn_items","ds_src_application","ds_unit","ds_uclass1","st_word_count","st_alpha_only","st_ext_method","st_audit","st_src_part","st_ext_part","cd_con_factor","ds_Source","id_batch","id_status","id_newitem","ds_dupedesc","id_replacedby","id_client","st_item","st_xfer","id_inc","id_nsc","id_unspsc","ds_rotable","ds_snctrl",
"ds_pkqtyi","ds_pkqtyo","ds_notes","dt_added","ds_price","ds_item_Status","ds_item_type","ds_acc_class","dt_extracted","st_sample","st_inc","st_nsc") VALUES
(23066,'1',NULL,1,0,NULL,'PADLOCK','','Abus 72/40 padlock','ABUS 72/40 PADLOCK, KEYED ALIKE, COLOUR RED ENGRAVED WITH ID NUMBERS AND LETTERS \"M1\" THRU \"M20\"',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'N',0,0,NULL,1,'Abus 72/40 padlock, Keyed alike, colour red engraved with ID numbers and letters \"M1\" thru \"M20\"',0,0,0,NULL,0,'TRUENERG','OK',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0),
(23067,'2',NULL,1,0,NULL,'PADLOCK','','Abus 72/40 padlock','ABUS 72/40 PADLOCK, KEYED ALIKE, COLOUR RED ENGRAVED WITH ID NUMBERS AND LETTERS \"N1\" THRU \"N20\"',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'N',0,0,NULL,1,'Abus 72/40 padlock, Keyed alike, colour red engraved with ID numbers and letters \"N1\" thru \"N20\"',0,0,0,NULL,0,'TRUENERG','OK',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0),
(23068,'3',NULL,1,0,NULL,'PADLOCK','','Abus 72/40 padlock','ABUS 72/40 PADLOCK, KEYED ALIKE, COLOUR RED ENGRAVED WITH ID NUMBERS AND LETTERS \"O1\" THRU \"O40\"',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'N',0,0,NULL,1,'Abus 72/40 padlock, Keyed alike, colour red engraved with ID numbers and letters \"O1\" thru \"O40\"',0,0,0,NULL,0,'TRUENERG','OK',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0),
The problem is that restoring the data via the myDump component produces an incorrect result in that only the first character of the 10th field is loaded.
The field in question has a datatype of VARCHAR(10000). Any suggestions on why this issue exists.
Dennis
-- Dumping data for table `e100`
--
LOCK TABLES `e100` WRITE;
/*!40000 ALTER TABLE `e100` DISABLE KEYS */;
INSERT INTO `e100` VALUES
(23066, '1', NULL, 1, 0, NULL, 'PADLOCK', '', 'Abus 72/40 padlock', 'A\0B\0U\0S\0 \07\02\0/\04\00\0 \0P\0A\0D\0L\0O\0C\0K\0,\0 \0K\0E\0Y\0E\0D\0 \0A\0L\0I\0K\0E\0,\0 \0C\0O\0L\0O\0U\0R\0 \0R\0E\0D\0 \0E\0N\0G\0R\0A\0V\0E\0D\0 \0W\0I\0T\0H\0 \0I\0D\0 \0N\0U\0M\0B\0E\0R\0S\0 \0A\0N\0D\0 \0L\0E\0T\0T\0E\0R\0S\0 \0\"\0M\01\0\"\0 \0T\0H\0R\0U\0 \0\"\0M\02\00\0\"\0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'N', 0, 0, NULL, 1, 'A\0b\0u\0s\0 \07\02\0/\04\00\0 \0p\0a\0d\0l\0o\0c\0k\0,\0 \0K\0e\0y\0e\0d\0 \0a\0l\0i\0k\0e\0,\0 \0c\0o\0l\0o\0u\0r\0 \0r\0e\0d\0 \0e\0n\0g\0r\0a\0v\0e\0d\0 \0w\0i\0t\0h\0 \0I\0D\0 \0n\0u\0m\0b\0e\0r\0s\0 \0a\0n\0d\0 \0l\0e\0t\0t\0e\0r\0s\0 \0\"\0M\01\0\"\0 \0t\0h\0r\0u\0 \0\"\0M\02\00\0\"\0', 0, 0, 0, NULL, 0, 'TRUENERG', 'OK', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, 0),
(23067, '2', NULL, 1, 0, NULL, 'PADLOCK', '', 'Abus 72/40 padlock', 'A\0B\0U\0S\0 \07\02\0/\04\00\0 \0P\0A\0D\0L\0O\0C\0K\0,\0 \0K\0E\0Y\0E\0D\0 \0A\0L\0I\0K\0E\0,\0 \0C\0O\0L\0O\0U\0R\0 \0R\0E\0D\0 \0E\0N\0G\0R\0A\0V\0E\0D\0 \0W\0I\0T\0H\0 \0I\0D\0 \0N\0U\0M\0B\0E\0R\0S\0 \0A\0N\0D\0 \0L\0E\0T\0T\0E\0R\0S\0 \0\"\0N\01\0\"\0 \0T\0H\0R\0U\0 \0\"\0N\02\00\0\"\0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'N', 0, 0, NULL, 1, 'A\0b\0u\0s\0 \07\02\0/\04\00\0 \0p\0a\0d\0l\0o\0c\0k\0,\0 \0K\0e\0y\0e\0d\0 \0a\0l\0i\0k\0e\0,\0 \0c\0o\0l\0o\0u\0r\0 \0r\0e\0d\0 \0e\0n\0g\0r\0a\0v\0e\0d\0 \0w\0i\0t\0h\0 \0I\0D\0 \0n\0u\0m\0b\0e\0r\0s\0 \0a\0n\0d\0 \0l\0e\0t\0t\0e\0r\0s\0 \0\"\0N\01\0\"\0 \0t\0h\0r\0u\0 \0\"\0N\02\00\0\"\0', 0, 0, 0, NULL, 0, 'TRUENERG', 'OK', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, 0),
(23068, '3', NULL, 1, 0, NULL, 'PADLOCK', '', 'Abus 72/40 padlock', 'A\0B\0U\0S\0 \07\02\0/\04\00\0 \0P\0A\0D\0L\0O\0C\0K\0,\0 \0K\0E\0Y\0E\0D\0 \0A\0L\0I\0K\0E\0,\0 \0C\0O\0L\0O\0U\0R\0 \0R\0E\0D\0 \0E\0N\0G\0R\0A\0V\0E\0D\0 \0W\0I\0T\0H\0 \0I\0D\0 \0N\0U\0M\0B\0E\0R\0S\0 \0A\0N\0D\0 \0L\0E\0T\0T\0E\0R\0S\0 \0\"\0O\01\0\"\0 \0T\0H\0R\0U\0 \0\"\0O\04\00\0\"\0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'N', 0, 0, NULL, 1, 'A\0b\0u\0s\0 \07\02\0/\04\00\0 \0p\0a\0d\0l\0o\0c\0k\0,\0 \0K\0e\0y\0e\0d\0 \0a\0l\0i\0k\0e\0,\0 \0c\0o\0l\0o\0u\0r\0 \0r\0e\0d\0 \0e\0n\0g\0r\0a\0v\0e\0d\0 \0w\0i\0t\0h\0 \0I\0D\0 \0n\0u\0m\0b\0e\0r\0s\0 \0a\0n\0d\0 \0l\0e\0t\0t\0e\0r\0s\0 \0\"\0O\01\0\"\0 \0t\0h\0r\0u\0 \0\"\0O\04\00\0\"\0', 0, 0, 0, NULL, 0, 'TRUENERG', 'OK', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, 0),
when it should appear as below which is produced by mySQLDump and other similar utilities:
-- Dumping data for table "e100"
--
/*!40000 ALTER TABLE "e100" DISABLE KEYS */;
INSERT INTO "e100" ("id_item","id_Source","id_site","id_eas","id_eid","id_enc","ds_enc","ds_designtype","ds_src_name","ds_src_desc","ds_part_name","ds_src_part","ds_src_manuf","ds_src_furn_items","ds_src_application","ds_unit","ds_uclass1","st_word_count","st_alpha_only","st_ext_method","st_audit","st_src_part","st_ext_part","cd_con_factor","ds_Source","id_batch","id_status","id_newitem","ds_dupedesc","id_replacedby","id_client","st_item","st_xfer","id_inc","id_nsc","id_unspsc","ds_rotable","ds_snctrl",
"ds_pkqtyi","ds_pkqtyo","ds_notes","dt_added","ds_price","ds_item_Status","ds_item_type","ds_acc_class","dt_extracted","st_sample","st_inc","st_nsc") VALUES
(23066,'1',NULL,1,0,NULL,'PADLOCK','','Abus 72/40 padlock','ABUS 72/40 PADLOCK, KEYED ALIKE, COLOUR RED ENGRAVED WITH ID NUMBERS AND LETTERS \"M1\" THRU \"M20\"',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'N',0,0,NULL,1,'Abus 72/40 padlock, Keyed alike, colour red engraved with ID numbers and letters \"M1\" thru \"M20\"',0,0,0,NULL,0,'TRUENERG','OK',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0),
(23067,'2',NULL,1,0,NULL,'PADLOCK','','Abus 72/40 padlock','ABUS 72/40 PADLOCK, KEYED ALIKE, COLOUR RED ENGRAVED WITH ID NUMBERS AND LETTERS \"N1\" THRU \"N20\"',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'N',0,0,NULL,1,'Abus 72/40 padlock, Keyed alike, colour red engraved with ID numbers and letters \"N1\" thru \"N20\"',0,0,0,NULL,0,'TRUENERG','OK',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0),
(23068,'3',NULL,1,0,NULL,'PADLOCK','','Abus 72/40 padlock','ABUS 72/40 PADLOCK, KEYED ALIKE, COLOUR RED ENGRAVED WITH ID NUMBERS AND LETTERS \"O1\" THRU \"O40\"',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'N',0,0,NULL,1,'Abus 72/40 padlock, Keyed alike, colour red engraved with ID numbers and letters \"O1\" thru \"O40\"',0,0,0,NULL,0,'TRUENERG','OK',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,0),
The problem is that restoring the data via the myDump component produces an incorrect result in that only the first character of the 10th field is loaded.
The field in question has a datatype of VARCHAR(10000). Any suggestions on why this issue exists.
Dennis