I have a functioning website which provides online surveys. My client has requested that we generate a survey for chinese customers.
I currently have a translation table, and depending on what language the user selects, I use the table to look up the code and language to get the text. On the table are only european languages which obvioulsy all mainly use the same character set. My problem is that simple chinese is obviously a different character set and double-byte. I would like to use the same table structure (textid, languageid, languagetext), however if that is not possible then perhaps an extra column for double-byte characters.
I need someone to generate a simple piece of asp which I will then adapt to include in my current application to enable the display of simple chinese characters.
For this, I need the following:
mssql 2005 database with a table containing a unique id (int), language code (text), language text (ntext?) i.e.
1,'chinese','whatever the chinese is for hello world'
a vb/asp page which has a dropdown for either english or chinese.
when english is selected, I need new vb/asp script to open database, select text depending on what language has been selected, and display it on a new page
No further entries are required in the database other than those above, obviously translations would be required for chinese equivalent to show that it works.
I would also like vb asp/script to load new chinese phrases onto the table, for this I would need fields for id, language, chinese text, and then sql to load it.
This project really has a budget of $50 - $200. Please consider that when bidding.