I am using PostgreSQL and set its locale in ‘English’. The encoding is UTF-8. I am inserting data (eg: table names, column names and other data) in multiple languages in the table but the statements (like CREATE, INSERT, SELECT, etc) are in default English.
Is it possible to write these statements or queries in other languages (like French, Dutch, Hindi etc)? What should I do?
No, those are specific SQL terms. It is like programming (do you program?). You name your variables (in this case, tables and fields) how you want… but the programming statements like IF…THEN…ELSE belong to the programming language itself. They’re not translated.
Those configuring settings that you have are related to the information that will go into or out of the database and the non-tradicional characters that it may accept. Or how to show dates on screen (month/day/year or day/month/year, etc)
I am thinking to develop a tool in which we can write ‘SQL queries’ in other language (not in English) as my final project (if possible) and so took PostgreSQL as reference. I am trying to relate my project’s idea to this one. I also referred some ‘Natural language interface to database’ papers.
Can I include a translator program in some header so that it could be able to translate the written non-English query? Or else how to make it possible?