A strange situation adding entries to configuration table using different charset

[g.nencini]

I need to add some records to the TABLE `configuration`, ad since the 'configuration_id' field is auto_increment, I've written a sql patch like:

INSERT INTO configuration (configuration_id,configuration_title, configuration_key,
configuration_value, configuration_description, configuration_group_id,
sort_order, last_modified, date_added, use_function, set_function)

VALUES ('',
'Visualizza Nome Box Options 1',
'PRODUCT_ALL_LIST_BOX_OPTIONS_1',
'2302',
'Vuoi visualizzare il Nome del Box Options 1 ?<br /><br />0= off<br />1° carattere Sinistra o Destra<br />2° e 3° carattere Ordine Elencazione<br />4° carattere numero di interruzioni dopo<br />',
'23',
'6',
NULL,
now(),
NULL,
NULL);


The patch is accepted and works well (I see the new option in admin->configure->all listing).

The strange thing is that if I export the database with phpMyAdmin I don't see the new record and the configuration_key PRODUCT_ALL_LIST_BOX_OPTIONS_1 is nowhere present.

Note that I've also updated the TABLE `product_type_layout`, and the new record is present, and so it seems to happen only for the TABLE 'configuration', and I'd like to see the new records!!!

What can I do? - Thanks - Giovanni

[g.nencini]

ATTENTION: the problem is in phpMyAdmin that is not able "to export" the new records in the configuration table, and so also isn't able to import them.

Looking at the configuration table inside the phpMyAdmin the records are present but are not exported!

Need help from a guru that know well phpMyAdmin !!!!!!

This is important for my add-on that add entries in the configuration table.

Giovanni

[DrByte]

1° carattere Sinistra o Destra<br />2° e 3° carattere Ordine Elencazione<br />4° carattere

I'm just guessing that maybe your phpMyAdmin and/or browser are not happy with the ° symbols in those database records. If you remove those symbols, I'm guessing the export will work fine.

[g.nencini]

Thanks DrByte, but I'm afraid that is not here the problem:

1) - also the nex entry is not exported

('',
'Lunghezza del Nome in Box Options 1',
'MAX_DISPLAY_BOX_OPTIONS_1_NAME_LEN',
'15',
'Usato nel Box Options 1; lunghezza massima del nome opzione da visualizzare. I nomi pi&ugrave; lunghi saranno troncati.',
'3',
'8',
NULL,
now(),
NULL,
NULL);

2) - also the entries created by stock_by_attributes_4-7ajax and dynamic_drop_downs_for_stock_by_attributes are not exported.

Giovanni

[DrByte]

Something is wrong with your tools then. Or maybe you've got some language/translation problems in your browser? Or maybe you're looking at the wrong database.
I have no problem exporting all the entries.

[g.nencini]

Well, it seems really to depend in setting the characters of phpMyAdim, and trying to to export and import with various setting I've made a very big confusion!!!
The original (that don't woks well) was utf8_general_ci, and changing this, phpMyAdmin seem to try to create a new database....
Can you suggest me a good setting (for import and export)?
Thanks - Giovanni

[g.nencini]

Where I live there's a VERY slow connection, and exporting the database with none compression there arise errors, often not the same!
Exporting with .zip compression all is going well.

Thanks however - Giovanni