Hello everybody,

Was just wondering if some people here have worked with multiple languages and if so, what would the consider important when building the database structure, as well as site structure with UltraDev. If had some idea's myself but sharing them is always a good thing. Some things to do are when creating a table for example called Products, with a record calling StyleName i would call it StyleName_E for English and StyleName_F for French and so on, so just making duplicates within the same tables instead of having two tables for two languages. If someone had different approches please share this with us all.

Look forward to hear all your input !

Dave Joosten

Beaulieu Canada

Edited by - djoosten on 06/15/2001 23:06:08

So i guess nobody ever did a site in more then 1 language .. hmm interesting

Dave Joosten

For site I'm making I have different approach. Site needs to be on three languages but it's not neccessary for each record to be in all languages. Some record may contain only one, the other all languages... Also, there wasn't fields that could be used in all languages.
As a solution, I simply made one field 'language' in witch administrator can choose language in witch data has been entered.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hello everybody,

Was just wondering if some people here have worked with multiple languages and if so, what would the consider important when building the database structure, as well as site structure with UltraDev. If had some idea's myself but sharing them is always a good thing. Some things to do are when creating a table for example called Products, with a record calling StyleName i would call it StyleName_E for English and StyleName_F for French and so on, so just making duplicates within the same tables instead of having two tables for two languages. If someone had different approches please share this with us all.

Look forward to hear all your input !

Dave Joosten

Beaulieu Canada

Edited by - djoosten on 06/15/2001 23:06:08
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Hi Djoosten
I just creat more column for mydatabase, ID_Lang, and value E for English, F for Franch, with SQL, it's meaning 1 more statement ID_Lang = E
Hope this help,
TheAnh.UDesign
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hello everybody,

Was just wondering if some people here have worked with multiple languages and if so, what would the consider important when building the database structure, as well as site structure with UltraDev. If had some idea's myself but sharing them is always a good thing. Some things to do are when creating a table for example called Products, with a record calling StyleName i would call it StyleName_E for English and StyleName_F for French and so on, so just making duplicates within the same tables instead of having two tables for two languages. If someone had different approches please share this with us all.

Look forward to hear all your input !

Dave Joosten

Beaulieu Canada

Edited by - djoosten on 06/15/2001 23:06:08
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Thanks for sharing that with us, this sure will help !



<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi Djoosten
I just creat more column for mydatabase, ID_Lang, and value E for English, F for Franch, with SQL, it's meaning 1 more statement ID_Lang = E
Hope this help,
TheAnh.UDesign
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hello everybody,

Was just wondering if some people here have worked with multiple languages and if so, what would the consider important when building the database structure, as well as site structure with UltraDev. If had some idea's myself but sharing them is always a good thing. Some things to do are when creating a table for example called Products, with a record calling StyleName i would call it StyleName_E for English and StyleName_F for French and so on, so just making duplicates within the same tables instead of having two tables for two languages. If someone had different approches please share this with us all.

Look forward to hear all your input !

Dave Joosten

Beaulieu Canada

Edited by - djoosten on 06/15/2001 23:06:08
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Dave Joosten