Database Table definition:
CREATE TABLE IF NOT EXISTS telugu2english (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY ,
telugu varchar(512) NOT NULL,
Update on 19th Sept.: Change telugu column collation to utf8_general_ci. The default latin1_swedish_ci collation cannot handle Telugu characters. Also cannot have telugu column as UNIQUE key as the length is too much (for utf8_general_ci collation).
We need 100 records in this table for showing the app. around and getting feedback and feel of interest in the app. from potential users.
Data can be added using phpmyadmin interface – don’t need app. to do that for first working prototype version.
In this working prototype version v1.0, App. needs to be one page only doing the following:
a) Showing Telugu (in Telugu script) and English (in Latin (English) script) – 2 column table.
b) English entry in two column table should be a hyperlink which when clicked plays the audio.
c) If audio file is not found then, if possible, we should use TTS – worst case, do nothing.
d) The page should show 10 entries and have pagination (10 pages for 100 rows).