Recommend a Database...MYSQL..

[Navin Kumar]

Hi
My team has been assigned the work to manage the translation of Front
Office Products of our company. The goal is to translate all the
strings in different languages like French, Spanish, Italian etc. In
order to automate the update/delete/addition/retieval of strings, we
plan to use a database. Each strings will identified by unique ID and
we plan to keep the translations in the same database. Not more than
25 users will have access to the database.
Approximate number of strings are 5000. We are using Windows2000
platform.
Could you please suggest me the following:
1. Which database we should go for? MYSQL/MS-Access??
2. How is the compatibility of MYSQL with Windows?
3. About the database design, could you suggest me if it will be
better to build different table for different languages or store the
translations in the same table?

Your suggestions are valuable to us. Thanks in advance
Navin

[Aaron Miles]

MySQL for windows works great I would do something like the following\

create table transstrings (
id int(11) not null auto_increment,
langtype int(11) not null,
stringdata char(200).
primary key (id),
index index_langtype (langtype),
index index_string (stringdata))

you can even have the followin
create table langs (
id int(11) not null auto_increment,
lang char(200).
primary key (id),
index index_langtype (lang))

Too easy and will be heaps faster the MS access will ever be.

Thanks

Aaron

"Navin Kumar" <it******@yahoo.com> wrote in message
news:89*************************@posting.google.co m...

Hi
My team has been assigned the work to manage the translation of Front
Office Products of our company. The goal is to translate all the
strings in different languages like French, Spanish, Italian etc. In
order to automate the update/delete/addition/retieval of strings, we
plan to use a database. Each strings will identified by unique ID and
we plan to keep the translations in the same database. Not more than
25 users will have access to the database.
Approximate number of strings are 5000. We are using Windows2000
platform.
Could you please suggest me the following:
1. Which database we should go for? MYSQL/MS-Access??
2. How is the compatibility of MYSQL with Windows?
3. About the database design, could you suggest me if it will be
better to build different table for different languages or store the
translations in the same table?

Your suggestions are valuable to us. Thanks in advance
Navin

[Aaron Miles]

MySQL for windows works great I would do something like the following\

create table transstrings (
id int(11) not null auto_increment,
langtype int(11) not null,
stringdata char(200).
primary key (id),
index index_langtype (langtype),
index index_string (stringdata))

you can even have the followin
create table langs (
id int(11) not null auto_increment,
lang char(200).
primary key (id),
index index_langtype (lang))

Too easy and will be heaps faster the MS access will ever be.

Thanks

Aaron

"Navin Kumar" <it******@yahoo.com> wrote in message
news:89*************************@posting.google.co m...

Hi
My team has been assigned the work to manage the translation of Front
Office Products of our company. The goal is to translate all the
strings in different languages like French, Spanish, Italian etc. In
order to automate the update/delete/addition/retieval of strings, we
plan to use a database. Each strings will identified by unique ID and
we plan to keep the translations in the same database. Not more than
25 users will have access to the database.
Approximate number of strings are 5000. We are using Windows2000
platform.
Could you please suggest me the following:
1. Which database we should go for? MYSQL/MS-Access??
2. How is the compatibility of MYSQL with Windows?
3. About the database design, could you suggest me if it will be
better to build different table for different languages or store the
translations in the same table?

Your suggestions are valuable to us. Thanks in advance
Navin

[swdev1]

Sounds like a similar approach for the intl tool kit from Steven Black .
So much very like it, in fact - that I recommend you go that route .
see http://stevenblack.com/ and purchase his toolkit .
HAVE FUN ! mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
Free Satellite Receivers and installation ->
http://www.vmcsatellite.com/?aid=58456
mySql / VFP / MS-SQL
"Navin Kumar" <it******@yahoo.com> wrote in message
news:89*************************@posting.google.co m...

Hi
My team has been assigned the work to manage the translation of Front
Office Products of our company. The goal is to translate all the
strings in different languages like French, Spanish, Italian etc. In
order to automate the update/delete/addition/retieval of strings, we
plan to use a database. Each strings will identified by unique ID and
we plan to keep the translations in the same database. Not more than
25 users will have access to the database.
Approximate number of strings are 5000. We are using Windows2000
platform.
Could you please suggest me the following:
1. Which database we should go for? MYSQL/MS-Access??
2. How is the compatibility of MYSQL with Windows?
3. About the database design, could you suggest me if it will be
better to build different table for different languages or store the
translations in the same table?

Your suggestions are valuable to us. Thanks in advance
Navin

[swdev1]

Sounds like a similar approach for the intl tool kit from Steven Black .
So much very like it, in fact - that I recommend you go that route .
see http://stevenblack.com/ and purchase his toolkit .
HAVE FUN ! mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
Free Satellite Receivers and installation ->
http://www.vmcsatellite.com/?aid=58456
mySql / VFP / MS-SQL
"Navin Kumar" <it******@yahoo.com> wrote in message
news:89*************************@posting.google.co m...

Hi
My team has been assigned the work to manage the translation of Front
Office Products of our company. The goal is to translate all the
strings in different languages like French, Spanish, Italian etc. In
order to automate the update/delete/addition/retieval of strings, we
plan to use a database. Each strings will identified by unique ID and
we plan to keep the translations in the same database. Not more than
25 users will have access to the database.
Approximate number of strings are 5000. We are using Windows2000
platform.
Could you please suggest me the following:
1. Which database we should go for? MYSQL/MS-Access??
2. How is the compatibility of MYSQL with Windows?
3. About the database design, could you suggest me if it will be
better to build different table for different languages or store the
translations in the same table?

Your suggestions are valuable to us. Thanks in advance
Navin