Modify

Opened 8 years ago

Closed 8 years ago

Last modified 8 years ago

#1299 closed Bug/Fehler (fixed)

DB Manager - Collation bei Export entfernen

Reported by: Ronald Parcinski Owned by: somebody
Priority: normal Milestone: modified-shop-2.0.4.0
Component: Admin Version: 2.0.3.0
Keywords: Cc:
Blocked By: Blocking:

Description

Bei unterschiedlichen COLLATE funktioniert das Entfernen nicht vollständig.

Beispiel

CREATE TABLE `products_description` (
  `products_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `products_name` varchar(255) COLLATE latin1_german1_ci NOT NULL,
  `products_description` text COLLATE latin1_german1_ci,
  `products_short_description` text COLLATE latin1_german1_ci,
  `products_keywords` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL,
  `products_meta_title` text COLLATE latin1_german1_ci NOT NULL,
  `products_meta_description` text COLLATE latin1_german1_ci NOT NULL,
  `products_meta_keywords` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `products_url` varchar(255) CHARACTER SET cp1250 COLLATE cp1250_croatian_ci DEFAULT NULL,
  `products_viewed` int(5) DEFAULT '0',
  `products_order_description` text COLLATE latin1_german1_ci,
  PRIMARY KEY (`products_id`,`language_id`),
  KEY `idx_products_name` (`products_name`)
) ENGINE=MyISAM AUTO_INCREMENT=1257 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci

Attachments (0)

Change History (2)

comment:1 by Ronald Parcinski, 8 years ago

Resolution: fixed
Status: newclosed

In 10962:

fix #1299

comment:2 by Ronald Parcinski, 8 years ago

In 10965:

fix #1299

Modify Ticket

Action
as closed The owner will remain somebody.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.