Comments (3)
Effectively the locale is usually 5 chars length, but in few cases it can be more longer :
For example :
serbian (rs_CS, sr_CS, sr_RS, sr_Latn_CS, sr_Latn_CS, sr_Latn_BA, en_US)
srpski (sr_Cyrl_CS, sr_Cyrl_BA, sr_RS, sr_CS)
The according RFC (http://www.faqs.org/rfcs/rfc1766.html) describes language tag as follow :
The language tag is composed of 1 or more parts: A primary language tag and a (possibly empty) series of subtags. The syntax of this tag in RFC-822 EBNF is: Language-Tag = Primary-tag *( "-" Subtag ) Primary-tag = 1*8ALPHA Subtag = 1*8ALPHA
So I suggest to increase the field size to 20 chars, which is a good compromise. Lower values would be a not necessary restriction.
I don't think there is a real interest in using a very small size for this field. An sql index would be enough in term of optimization.
BR
from pim-community-dev.
Hi,
It totally makes sense, ok for 20 chars and for add some indexes on these columns.
We'll change it in following days (just after the update to platform beta-1) in pim_catalog_locale, pim_catalog_product_value and pim_catalog_attribute_option_value (and in oro/platform FlexibleEntityBundle).
Thank you,
from pim-community-dev.
Thanks again for the feedback ! Fixed and merged on master (think about composer.phar install to update oro/platform if you want to test).
from pim-community-dev.
Related Issues (20)
- Manual installation of Akeneo PIM Community Edition (CE) v. 7.0 on Ubuntu fails HOT 1
- cannot install apps from the store - Internal Server Error 500 HOT 3
- Opening the CREATE GROUP page reports Error 500, Impossible to access an attribute ("indexPath") on a string variable ("New Group") HOT 1
- API connect with api-php-client not working, return error 422 HOT 1
- Can't bulk delete products HOT 2
- EACCES Permission denied Make command HOT 2
- No alive nodes found in your cluster HOT 3
- Impossible to register an export to SFTP - The route "pimee_job_automation_get_storage_connection_check" does not exist. HOT 1
- Post /api/rest/v1/products not creating product (returns 200)
- Database save on server and load after restart Docker container HOT 2
- Install these repo without docker HOT 1
- image import in demo product HOT 2
- Error when editing a product bases on a family with 0 required attributes
- How create a connector for the exchange of data between the PIM and another publication management system HOT 1
- Support arm64 platforms for Akaneo container images
- Identity Server connector HOT 2
- Maintenance on akeneo/api-php-client repository HOT 2
- An internal server error is generated instead of the required field intruction if a product model is created without adding model code.
- Categories Tree Empty
- Inconsistent result from rest api api/rest/v1/products HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pim-community-dev.