View Issue Details

IDProjectCategoryView StatusLast Update
0003419OXID eShop (all versions)4.07. Source code, Testpublic2012-12-10 13:44
Reporterboehme Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionunable to reproduce 
Product Version4.5.5 revision 40299 
Summary0003419: oxobject2attribute.oxvalue = char(255) <> oxobject2attribute.oxvalue_1 = varchar(255)
Descriptiondatatyp of oxobject2attribute.oxvalue is char(255) but should be varchar(255) for simple compability with multilanguage fields (oxobject2attribute.oxvalue_1 = varchar(255))
TagsNo tags attached.
ThemeBoth
BrowserAll
PHP Versionany
Database Versionany

Activities

dainius.bigelis

2011-12-29 14:25

reporter   ~0005562

Reminder sent to: boehme

Hi,

In default eShop installation all these fields are created as char(255) (including oxvalue, oxvalue_1, etc.). If user selects to install shop as UTF8, then all those fields are converted to varchar(255). So in any case all the fields should have the same type - char or varchar.
The strange thing is that on your shop these types differs for those fields. Could you please tell about more details how you setup the shop:
1. is it UTF8 or no?
2. do you updated shop from some previous versions?
3. do you have modules installed, which may affect any of those fields or maybe you made some customizations to the DB?
4. can you reproduce the same issue on the fresh installation of default eShop?