-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Joe,
Joe Yuen wrote:
> I'm currently using a
> resource file and that all work great except for some select boxes
> the data comes from the database where the data is in English. I was
> wondering how other people handle this situation?
You'll need your tables to accommodate other languages. I usually do
something like this:
CREATE TABLE foo
(
id INTEGER NOT NULL, -- the PK
...
)
;
CREATE TABLE foo_text
(
foo_id INTEGER NOT NULL, -- PK(1)
language CHAR(2) NOT NULL, -- PK(2)
country CHAR(2) NULL, -- PK(3)
-- text fields go here, and are localized
)
;
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGXeCB9CaO5/Lv0PARAmWsAKCsAHjVQmfnK8WxWkW65zRcoiZsSwCfaWFg
xZUX4rFBrn5MdvZjNrqYYbw=
=YWFU
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
