Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB Multilingual Support

Status
Not open for further replies.

mohdshadab

Programmer
Feb 22, 2006
13
IN
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top