Fields of product does not support unicode for label

Hi guys,

I put a name for a label in Vietnamese but it does not support because it is stored in database in VARCHAR so can anyone help me how to store it in NVARCHAR? Thanks so much.

I have changed dbtype of _title field in table sf_meta_fields of databse to NVARCHAR but it always back VARCHAR every changes. Can anyone help me?

Hello,

The column data type defined by default in the database can`t be changed, it will always revert back to the original data type. This is because the database in sitefinity is managed by ORM (sitefinity uses OpenAccess ORM) the ORM will always revert the default values of the table type

The DB type of a field can`t be changed, if the case in which this field is used is in a module built with the module builder (Administration->Module builder) add new field to the module in order to change its DB type. If the field which Db type is to be changed is one of the built in fields in sitefinity, this change can`t be done.

Please let me know which field in which module you want to change and if possible I will offer a workaround.

Regards,
Stanislav Velikov
Telerik

Thank you Stanislav Velikov.

I just using built in Ecommerce module.       

I add a field in [Product Types/Product fields ] with Type=[ShortText] and Label ="Tiếng Việt". When I add a new product that field displays correctly ("Tiếng Việt") in BackEnd but in FrontEnd it display "Ti?ng Vi?t" because it is stored in database with dbtype=VARCHAR. Please help me resolve this case.

Thank you so much.

Please help me

Hi,

To avoid getting the question marks on the name edit the template of the product list widget where the custom field must be shown and enter:

Thank you so much