Home » Forums » Ubercart » Bug Reports

Incorrect collation in table uc_file_products - prevents contrib File Downloads Retro from working

Submitted by strikedo on Mon, 02/25/2008 - 19:45
strikedo
Posts: 15
 Joined: 02/06/2008

Hi,

the fields 'model' and 'description' in table uc_file_products are set to collation utf8_unicode_ci.

In order for the File Downloads Retro contrib to work, the collations in the table uc_file_products must match the collations in uc_orders and uc_order_products, which are both set to utf8_general_ci

Seems like most of the UC tables are set to utf8_general_ci, so...

1) Is there a particular reason why uc_file_products is set to utf8_unicode_ci?
2) Will changing the collation to utf8_general_ci break anything (I've already changed the collations to get the contrib to work, and haven't come across any problems yet...)?
3) If there's no particular reason it should be unicode, can it be changed to general for future releases?

Thanks!
permalink #1 Mon, 02/25/2008 - 20:04
TR
Posts: 931
 Joined: 11/05/2007
Bug FinderFAQ ModeratorGetting busy with the Ubercode.

A similar issue was posted here: http://www.ubercart.org/forum/bug_reports/2896/differences_collation

Although your report is a more serious error, it results from the same problem mentioned in that issue - i.e. inconsistent collations across Ubercart tables.

--

<tr>.