mohdshadab
Programmer
This is more of a generic question.
While creating a multilingual website which allows for data to be entered in multiple languages, there is an issue if this data in different languages starts to go into fields which have a primary/unique constraint then its integrity will be compromised.
The DB is UTF8 compliant.There are lot of multiligual websites out there that might face similar problems.Whats the workaround for this.
- Create another record for different language entry and link it to primary record which is in English.So lot of multilingual records for one main record.
- Make columns language specific and control it trough front end making constrained columns with same language.Though with this it becomes a user usability issue in that user has to keep switching his keyboard language support.
Any inputs would be extremely valuable.
While creating a multilingual website which allows for data to be entered in multiple languages, there is an issue if this data in different languages starts to go into fields which have a primary/unique constraint then its integrity will be compromised.
The DB is UTF8 compliant.There are lot of multiligual websites out there that might face similar problems.Whats the workaround for this.
- Create another record for different language entry and link it to primary record which is in English.So lot of multilingual records for one main record.
- Make columns language specific and control it trough front end making constrained columns with same language.Though with this it becomes a user usability issue in that user has to keep switching his keyboard language support.
Any inputs would be extremely valuable.