Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 13th, 2007, 12:04 AM
Authorized User
 
Join Date: Jul 2007
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multilingual Tables

Ok I will explain it from start.

I am working on a completely multilingual website.

Now at this point I am working on Database end.

As this is a multilingual website so I need the Language Table as show below.

--------------------------------

Language

--------------------------------

Id

RomanName

NativeName

Direction

IsVisible

--------------------------------


Next.

I have Book Table.

--------------------------------

Book

--------------------------------

Id

RomanName

NativeName

IsVisible

--------------------------------



Every thing is fine till here.



But I have a limited type of Books and each book is avalaible in different languages.



For Example I add a book translated in Arabic, Urdu and English.

These three books have different ID. But these are the translation of Same book.

And when I have this Book in Urdu By default. And need all the available languages for this book then problem occurs.



To resovle this issue I modify the Book Table and break it into 2 Tables.



--------------------------------

Book

--------------------------------

Id

RomanName

IsVisible

--------------------------------

--------------------------------

BookNative

--------------------------------

BookId

LanguageId

NativeName

--------------------------------


Then an ID will assign for the book and all available language editions have not the ID.

At this end the above mentioned goal will got.

But I explain it on another post

http://forums.asp.net/t/1145293.aspx

And they replied its not correct.

Then again I think it for some time.

And another solution will come in mind.

That make a single Table for Book

--------------------------------

Book

--------------------------------

Id

Name

IsVisible

BookGroupID

--------------------------------

And for the above mentioned goal make a separate BookGroup Table


--------------------------------

BookGroup

--------------------------------

Id

Name

IsVisible

--------------------------------

After this solution Book Table is alone.


Hope you will pick it.

And reply me with some great idea.


Waiting for your reply.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Multilingual PHP js_newbie Beginning PHP 0 April 15th, 2007 02:07 AM
multilingual support mikedeepak Classic ASP Professional 0 July 11th, 2006 01:42 AM
Multilingual database Tachyophan Access VBA 3 January 10th, 2005 10:49 PM
Multilingual website happygv Classic ASP Basics 5 April 12th, 2004 03:44 AM
Multilingual and XML sanilkumar XML 1 June 15th, 2003 10:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.