Devart Forums

Posted: **Fri 14 May 2010 06:56**

How to choose characterset in mobile edtion?

I'm developing using "connect for oracle mobile edition".

I'm from korea so I use korean in the app and windows ce environment.

but query result of korean is crashed.

the server characterset is AMERICAN_AMERICA.US7ASCII.

connect type is unicode because no unicode can't connect db server.

plz you help me , It's very important.

Posted: **Mon 17 May 2010 11:06**

Oracle characterset is defined during the process of a new Oracle database creation. You can check your current character set by executing the following SQL:
select * from nls_database_parameters where parameter='NLS_CHARACTERSET'

Characterset of your mobile device is determined basing on its operating system Regional Settings. US7ASCII doesn't include national Korean symbols. Please create database with characterset that supports Korean symbols or use the datatypes that support Unicode (NCHAR,NVARCHAR2, and NCLOB).