Multi Language Application

Hey Guyz,

Long time no see :wave:

I have been handed over a task to convert an application we have written in Delphi 7 so it can input data into THAI Language (and more in future).

First step I have taken is to make the database with all the tables using NVARCHAR & NCHAR & NTEXT so it can store the unicode characters. I have also converted all the stored procedures to use NVARCHAR & NCHAR & NTEXT.

Now the next big step is to do something with the program so users can enter THAI characters. Good thing is the customer has agreed to keep the labels as they are but just the input is required in their language. e.g. Customer entry form, the labels would say Customer Code and Customer Name in english. But the Text box would take THAI input. Anyone has any idea how this can be done without having to have 2 different EXEs for 2 different language..!

I have see THAI ppl using their laptop where when they type something normally it just gets typed in as THAI rather than english. Is that a matter of simply changing the Keyboard layout..?

Hope this all makes sense :D

Cheers :)

It's a matter of changing fonts, changing the keyboard driver, changing the language version of Windows running on the computer ... there are a number of ways to do what you need. I'd just get the program running and not worry about what keycode was drawn as what character on the screen.

OK I have got the alternative fonts installed and set the current keyboard layout set to THAI.

Now it's a matter of changing a control's character set so it can take UNICODE characters. How do I know which Windows Message is passed via OS when keyboard language changes..?

It should just be a matter of using a font which accepts unicode characters. And ensuring that the database can handle unicode characters, which in your case, has been done.

You should now get debugging and watch the flow of the inputted characters into the database.