[Wolves] SQL problem

[Chris Procter]

I'm a bit confused, are you trying to hold two copies of the same info, one
in english and one in welsh? If so could you use two fields in the table e.g
english_text and welsh_text and then pick which column you want on the fly
(dependant on some variable set by the front end)
i.e. "SELECT " & language & "_text FROM table" 
with language = "welsh"

Or have I missed the point?

chris


-----Original Message-----
From: Simon Burke [mailto:its_simon_burke at hotmail.com]
Sent: 17 March 2004 09:53
To: Wolverhampton Linux User Group
Subject: [Wolves] SQL problem


Hi,
I've been assigned the task of making a db on SQL server 2000. Does anyone
know how I can make the actual data viewable in several languages, (ie
english/welsh)?? I thought of linking databases for each language for some
of the vaules that get repeated a lot, but im not sure on the rest.

Thanks
Simon


_______________________________________________
Wolves LUG mailing list
Homepage: http://www.wolveslug.org.uk/
Mailing list: Wolves at mailman.lug.org.uk
Mailing list home: http://mailman.lug.org.uk/mailman/listinfo/wolves


**********************************************************************
Any opinions expressed in this email are those of the individual
and not necessarily those of Fox Online.
This email and any files transmitted with it, including replies and
forwarded copies (which may contain alterations) subsequently transmitted
from Fox Online, are confidential and solely for the use
of the intended recipient.
If you have received this email in error please notify Fox Online by
telephone on +44 (0)121 693 1424.
**********************************************************************