SQL Anywhere Mobile - What character set do you use on your Oracle Consolidated?

Author

What character set do you use on your Oracle Consolidated?

Reg Domaratzki \(iAnywhere Solutions\)

2005-11-10, 1:24 pm

We're in the process of adding some tests to the MobiLink test stream to
test MobiLink against a variety of Oracle character sets. We'd like to make
sure that the character sets we choose are relevant to our installed and
future customer base. If you use, or are planning to use Oracle as your
consolidated database in a MobiLink environment, I was wondering if you
could answer the following questions for us :

1) What is the version of your Oracle consolidated database?
2) What character set is being used on your Oracle consolidated? The
following SQL should give you the answer if you're not sure :
select * from NLS_DATABASE_PARAMET
ERS where PARAMETER = 'NLS_CHARACTERSET';
3) What platform is the MobiLink server running on?
4) What is the default language on machine where the MobiLink server is
running?
5) Do you set the IANAAppCodePage connection parameter in your DSN or
MobiLink connect string? If so, what value do you use.
6) What collation sequence are you using in your UltraLite or ASA remote
databases?

You're welcome to e-mail me this information directly if you don't want to
post it to a public forum. My e-mail address is
<FirstName>.<LastName>@ianywhere.com, where you replace <FirstName> and
<LastName> with my actual first and last name, leaving the dot between the
two names.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

Omri

2005-11-14, 3:24 am

> We're in the process of adding some tests to the MobiLink
> test stream to test MobiLink against a variety of Oracle
> character sets. We'd like to make sure that the character
> sets we choose are relevant to our installed and future
> customer base. If you use, or are planning to use Oracle
> as your consolidated database in a MobiLink environment, I
> was wondering if you could answer the following questions
> for us :
>
> 1) What is the version of your Oracle consolidated
> database?
-----oracle 9i
2) What character set is being used on your
> Oracle consolidated? The following SQL should give you the
------we8mswin1252

3) What platform is the MobiLink
> server running on?
-------windows server 2003
4) What is the default language on
> machine where the MobiLink server is running?
-------- english(usa)
> 5) Do you set the IANAAppCodePage connection parameter in
> your DSN or MobiLink connect string? If so, what value do
> you use.
6) What collation sequence are you using in your
> UltraLite or ASA remote databases?
---------856HEB
Have a Great Day
Omri Ziv

Sponsored Links