Title: Serailized Php Array does not accept wpdb datasource
Last modified: April 21, 2022

---

# Serailized Php Array does not accept wpdb datasource

 *  Resolved [wprmayne](https://wordpress.org/support/users/wprmayne/)
 * (@wprmayne)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/serailized-php-array-does-not-accept-wpdb-datasource/)
 * The standard wpdb datasource return string array, also for Id. When your serialize
   the array the value of the ID is indetify as string. (s:1:”1″) even it’s a integer.
   
   In this case to plugin does not see any record and it’s impossible to save the
   table.
 * Why you does not accept string as Id?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [wprmayne](https://wordpress.org/support/users/wprmayne/)
 * (@wprmayne)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/serailized-php-array-does-not-accept-wpdb-datasource/#post-15582406)
 * I realy don’t know why it does not work. I try the example from the site and 
   it work correctly. The output was copied to a other php programm and echo. In
   this case the same output is not accepted.
    What’s wrong? the output. `a:10:{
   i:0;a:2:{s:2:"Id";i:484;s:5:"Title";s:16:"Privé : import";}i:1;a:2:{s:2:"Id";
   i:473;s:5:"Title";s:5:"CLUBS";}i:2;a:2:{s:2:"Id";i:468;s:5:"Title";s:6:"NATURE";}
   i:3;a:2:{s:2:"Id";i:464;s:5:"Title";s:6:"CHASSE";}i:4;a:2:{s:2:"Id";i:462;s:5:"
   Title";s:7:"AGILITY";}i:5;a:2:{s:2:"Id";i:368;s:5:"Title";s:20:"INSTITUTIONS 
   CANINES";}i:6;a:2:{s:2:"Id";i:298;s:5:"Title";s:10:"Les tiques";}i:7;a:2:{s:2:"
   Id";i:286;s:5:"Title";s:8:"Conseils";}i:8;a:2:{s:2:"Id";i:283;s:5:"Title";s:40:"
   Éducation à la propreté chez le chien";}i:9;a:2:{s:2:"Id";i:240;s:5:"Title";s:
   12:"Lu pour vous";}}`
 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/serailized-php-array-does-not-accept-wpdb-datasource/#post-15595397)
 * Hello there.
 * Sorry for the late response.
 * The issue is caused by the encoding. You’ve got special (language) characters
   in the array, so they’re not being counted properly (É, à, é).
 * Those characters are not supported by serialized PHP arrays, so you would need
   to change them to E, a, e. Alternately, you would need to adjust the charset 
   to iso-8859-1, but we haven’t done this before, so we can’t say exactly how you
   can approach this.
 * Our developers will be looking at possible solutions in the future, but since
   they aren’t being recognized in online unserializers (like [https://www.unserialize.com/](https://www.unserialize.com/)),
   we can’t promise anything.
 * Kind regards.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Serailized Php Array does not accept wpdb datasource’ is closed to new
replies.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

## Tags

 * [serialize](https://wordpress.org/support/topic-tag/serialize/)
 * [wpdb](https://wordpress.org/support/topic-tag/wpdb/)

 * 2 replies
 * 2 participants
 * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * Last activity: [4 years, 1 month ago](https://wordpress.org/support/topic/serailized-php-array-does-not-accept-wpdb-datasource/#post-15595397)
 * Status: resolved