wenn ich das alles richtig sehe, dann sind die Daten, die ich importiere windows 1252 codiert und beim Eintragen in meinen utf 8 shop kommt das Problem.
Die Routine, die die Daten bei mir in die DB legt schaut so aus:
// Einfügen
xtDBquery("INSERT INTO `" . TABLE_PRODUCTS . "` (`products_ean`, `products_quantity`, `products_shippingtime`, `products_model`, `group_permission_0`, `group_permission_1`, `group_permission_2`, `group_permission_3`, `products_sort`, `products_image`, `products_price`, `products_discount_allowed`, `products_date_added`, `products_last_modified`, `products_date_available`, `products_weight`, `products_status`, `products_tax_class_id`, `product_template`, `options_template`, `manufacturers_id`, `products_ordered`, `products_fsk18`, `products_vpe`, `products_vpe_status`, `products_vpe_value`, `products_startpage`, `products_startpage_sort`) VALUES
('".$ean."', '".$book_quan."', 1, '" . xtc_db_input($book_model) . "', 0, 0, 0, 0, 0, NULL, '" . $book_Plu * 0.93 . "', '0.00', NOW(), NOW(), NULL, '0.00', '1', '" . $book_tax . "', 'libriproduct_info_v1.html', 'product_options_dropdown.html', 0, 0, 0, 0, 0, '0.0000', 0, 0)");
$book_db_id = xtc_db_insert_id();
xtDBquery("INSERT INTO `" . TABLE_PRODUCTS_DESCRIPTION . "` (`products_id`, `language_id`, `products_name`, `products_short_description`, `products_description`, `products_keywords`, `products_meta_title`, `products_meta_description`, `products_meta_keywords`, `products_url`, `products_viewed`) VALUES
(" . $book_db_id . ", 2, '" . xtc_db_input($book_title) . "', '" . xtc_db_input($book_beschreibung) . "', '" . xtc_db_input($book_beschreibung_short) . "', '" . xtc_db_input($book_title) . "', '', '', '', '', 0)");
xtDBquery("INSERT INTO `" . TABLE_PRODUCTS_TO_CATEGORIES . "` (`products_id`, `categories_id`) VALUES
(" . $book_db_id . "," . $categorieID . ")");
}
else
{
xtDBquery("UPDATE `" . TABLE_PRODUCTS . "` SET `products_ean` = '" . $ean . "' , `products_price` = '" . $book_Plu * 0.93 . "' , `products_tax_class_id` = 2, `products_quantity` = '".$book_quan."' WHERE `products_id` = '" . $book_db_id . "'");
xtDBquery("UPDATE `" . TABLE_PRODUCTS_DESCRIPTION . "` SET `products_name` = '" . xtc_db_input($book_title) . "', `products_short_description` = '" . xtc_db_input($book_beschreibung) . "', `products_description`='" . xtc_db_input($book_beschreibung_short) . "' WHERE `products_id` = '" . $book_db_id . "'");
Meiner Meinung müsste dort oder kurz davor eine Umwandlung in UTF 8 eingetragen werden?
Danke für Hilfe!