Re: [GENERAL] Advice on structure /sequence / trigger

2005-07-02 Thread Greg Stark
David Pratt <[EMAIL PROTECTED]> writes: > Hi Greg. Sorry for getting back to you so late on this. I think your idea on > the design is spot on since it will give me referential integrity with my > other > and the multi-language will just be a simple two field table with id and > multi-dimensiona

Re: [GENERAL] Advice on structure /sequence / trigger

2005-06-30 Thread David Pratt
Hi Greg. Sorry for getting back to you so late on this. I think your idea on the design is spot on since it will give me referential integrity with my other and the multi-language will just be a simple two field table with id and multi-dimensional array of language codes to string. Super idea

Re: [GENERAL] Advice on structure /sequence / trigger

2005-06-16 Thread Greg Stark
David Pratt <[EMAIL PROTECTED]> writes: > I just want to get this right because it will be an important part of what I > am > preparing. Sorry for the really long message but I don't know if it would > make > any sense if I did not fully explain what i am wanting to do. I am not french > so ex

[GENERAL] Advice on structure /sequence / trigger

2005-06-16 Thread David Pratt
I am interested in having some internationalization capability to an application. i18 will take care of the interface but not the data. To internationalize the data, I am wanting to put the internationalized text strings in a multi_language table like this: CREATE TABLE multi_language (