[
https://issues.apache.org/jira/browse/OFBIZ-5426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14747107#comment-14747107 ]
Ingo Wolfmayr commented on OFBIZ-5426:
--------------------------------------
The issue would be solved if the field-type-def of "email" would be set to varchar(256). The current size is defined as varchar(320) that follows the original version of RFC 3696 which has been revised:
https://www.rfc-editor.org/errata_search.php?rfc=3696> mysql: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
> ----------------------------------------------------------------------------------
>
> Key: OFBIZ-5426
> URL:
https://issues.apache.org/jira/browse/OFBIZ-5426> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: Trunk
> Reporter: Leon
>
> Due to revision 1529838, the length of data type "email" was increased from 254 to 320. But It makes the ofbiz failed to create tables such as "PRODUCT_PROMO_CODE_EMAIL" which includes an email fields as its primary key.
> The database is mysql, innodb engine and utf8 charset. The error msg:
> ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes.
> I suggest to revert change of r1529838.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
Locked
