Hibernate Community • View topic - Best practice of mapping multiple language table attribute

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Best practice of mapping multiple language table attribute

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

perseus

Post subject: Best practice of mapping multiple language table attribute

Posted: Tue Nov 18, 2003 11:25 am

Beginner

Joined: Sun Nov 16, 2003 9:30 am
Posts: 20

Hi all ,

I have a table, say T_PRODUCT, in which every attribute I will have multiple languages, say ENG_PRODUCT_NAME and CHI_PRODUCT_NAME. But if I map it this way, it seems that it will be difficult to read and maintain. Does anyone has any better suggestion for the mapping ?

Thanks.

Perseus

Top

cutie

Post subject:

Posted: Tue Nov 18, 2003 5:37 pm

Regular

Joined: Tue Sep 16, 2003 11:35 am
Posts: 93
Location: San Francisco, CA

How about

Code:

TABLE Product {
   id int,
   name int references LocalizedString
}

TABLE LocalizedString {
   id int
}

TABLE LocalizedStringValue {
   id int,
   string int references LocalizedString,
   locale char(2),
   value text
}

Then it would be too hard to write a UserType that encapsulated the LocalizedString table and provided easy access to the string in any language.

Who knows, someone else has probably already figured this out. There might even be a db vendor solution.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum