Need Help

[csvenkata]

I want to store data in a table in both english and japanese language. When I qry this table, depending on the where condn. it should give the appropriate results.

The basic idea is to store both english and Japanese lang data in one table.

How can this be achieved?

TIA
venkata

[m1l]

Just have a language field, with something like 'J' for Japan and 'E' for English in that field.

[csvenkata]

I want to store the data itself in Japanese.

[aph]

Where the Japanese language data comming from??

[csvenkata]

It will come from the application. when I start the application it will allowme choose the language option. If I choose japanese then it will allow me store and retrieve the values.

TIA
venkat

[ca9mbu]

In essence this is a simple problem to solve. As was suggested eariler you could have two columns in the table, one for the English Data and one for the Japanese Data. Then when you select the relevant language at startup then you can store a variable to mark which language was chosen. Then use an If statement to only retrieve the required column based on the language selected. However - if an English language user stores data in the table it will (from your description) be stored in the English column, the Japanese column would contain a NULL value. So, then a Japanese user queries the database and returns the previuosly inserted row and will get NULL for the data - which is not strictly true. Unless you have a method of translation to automatically populate the other-language column I don't know how you'd get around this problem!

Hope this helps

Matt

[bmycroft]

Hi there,
the programming side is easy yes but I dont think that is the issue that csvenkata is raising.. If he wants to store Japanise language in the database then surely Japanese uses a different character set to "US English" (Not that there IS such a thing as US english mr Gates....). I know you can use the NLS_LANGUAGE parameters to set the language but as to how to store different character sets in the same database... i dunno if you can..

[aph]

You can store japanese or any other language in BLOB column type. It store the binary type data such as Japanese lang. etc, etc.

[dknight]

Try creating a database with the UTF-8 character set.

Search this forum on keyword UTF-8. There are posts concerning Japanese and Chinese.

Good luck.