Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Combining two character set in an application.

7 posts in General Discussion Last posting was on 2006-07-26 00:22:21.0Z
Prof. Dr. Bachok M Taib Posted on 2006-07-25 02:55:05.0Z
From: "Prof. Dr. Bachok M Taib" <bachok@admin.kuim.edu.my>
Newsgroups: ianywhere.public.general
Subject: Combining two character set in an application.
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: 58.26.99.3
Message-ID: <44c5863f@forums-2-dub>
X-Original-Trace: 24 Jul 2006 19:47:27 -0700, 58.26.99.3
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Jul 2006 19:47:28 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Jul 2006 19:55:05 -0700
X-Trace: forums-1-dub 1153796105 10.22.108.75 (24 Jul 2006 19:55:05 -0700)
X-Original-Trace: 24 Jul 2006 19:55:05 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5520
Article PK: 1560

I am developing an application using PB10 with ASA9. My question is, can I
store, retrieve and display combination of two character set English and
Arabic? If can how?.

Thanks

Bachok


Greg Fenton Posted on 2006-07-25 03:47:59.0Z
From: Greg Fenton <greg.fenton_nospam_@googles-mail-site.com>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Combining two character set in an application.
References: <44c5863f@forums-2-dub>
In-Reply-To: <44c5863f@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <44c592a4@forums-2-dub>
X-Original-Trace: 24 Jul 2006 20:40:20 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 12
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Jul 2006 20:40:21 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Jul 2006 20:47:59 -0700
X-Trace: forums-1-dub 1153799279 10.22.108.75 (24 Jul 2006 20:47:59 -0700)
X-Original-Trace: 24 Jul 2006 20:47:59 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5521
Article PK: 1559


Prof. Dr. Bachok M Taib wrote:
> I am developing an application using PB10 with ASA9. My question is, can I
> store, retrieve and display combination of two character set English and
> Arabic? If can how?.

Have you tried using UTF-8 as the character set of your SQLAnywhere
database?

g.f
--
Greg Fenton
Some Random Dude


Bachok M Taib Posted on 2006-07-25 08:39:52.0Z
From: "Bachok M Taib" <bachok@admin.kuim.edu.my>
Newsgroups: ianywhere.public.general
References: <44c5863f@forums-2-dub> <44c592a4@forums-2-dub>
Subject: Re: Combining two character set in an application.
Lines: 24
Organization: KUIM
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-Original-NNTP-Posting-Host: 58.26.99.3
Message-ID: <44c5d70b$1@forums-2-dub>
X-Original-Trace: 25 Jul 2006 01:32:11 -0700, 58.26.99.3
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Jul 2006 01:32:14 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Jul 2006 01:39:52 -0700
X-Trace: forums-1-dub 1153816792 10.22.108.75 (25 Jul 2006 01:39:52 -0700)
X-Original-Trace: 25 Jul 2006 01:39:52 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5522
Article PK: 1561

Dear Greg
Yes, I have tried UTF-8 as in the following ProfileString:

ProfileString ( ls_inifile, "Database", "DBParm",
"ConnectString='DSN=sppi;UID=dba;PWD=sql;UTF8=1;charset=utf8'")
but I am keep getting question marks ????? when ever the data is in Arabic.
No problem in getting the English character sets.

"Greg Fenton" <greg.fenton_nospam_@googles-mail-site.com> wrote in message
news:44c592a4@forums-2-dub...
> Prof. Dr. Bachok M Taib wrote:
>> I am developing an application using PB10 with ASA9. My question is, can
>> I store, retrieve and display combination of two character set English
>> and Arabic? If can how?.
>
> Have you tried using UTF-8 as the character set of your SQLAnywhere
> database?
>
> g.f
> --
> Greg Fenton
> Some Random Dude


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-07-25 12:46:05.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Combining two character set in an application.
References: <44c5863f@forums-2-dub> <44c592a4@forums-2-dub> <44c5d70b$1@forums-2-dub>
In-Reply-To: <44c5d70b$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <44c6128d$1@forums-1-dub>
Date: 25 Jul 2006 05:46:05 -0700
X-Trace: forums-1-dub 1153831565 10.25.98.170 (25 Jul 2006 05:46:05 -0700)
X-Original-Trace: 25 Jul 2006 05:46:05 -0700, keating-dm20.sybase.com
Lines: 40
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5523
Article PK: 1563

Do you get the ????? when you query the same data in DBISQL?

Make sure that you are using an UNICODE font in PB10. You will need to
verify that the font contains the characters that you need to deplay
(see Character Map windows utility). If the font cannot display the
character, a ? will be displayed.


--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Register now for TechWave 2006 August 6-10 in Las Vegas. New! 2-day
and 4-day options for SQL Anywhere technical training.
Sessions will focus on data management, data movement, and SQL Anywhere
10. Visit www.sybase.com/techwave


*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Nick Elson Posted on 2006-07-25 13:59:01.0Z
From: "Nick Elson" <no_span_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <44c5863f@forums-2-dub> <44c592a4@forums-2-dub> <44c5d70b$1@forums-2-dub>
Subject: Re: Combining two character set in an application.
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: nicelson-m20.sybase.com
X-Original-NNTP-Posting-Host: nicelson-m20.sybase.com
Message-ID: <44c623a5$1@forums-1-dub>
Date: 25 Jul 2006 06:59:01 -0700
X-Trace: forums-1-dub 1153835941 10.25.98.215 (25 Jul 2006 06:59:01 -0700)
X-Original-Trace: 25 Jul 2006 06:59:01 -0700, nicelson-m20.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5524
Article PK: 1564

The database needs to be created with UTF-8 [which is really
what Greg was suggesting].

"Bachok M Taib" <bachok@admin.kuim.edu.my> wrote in message
news:44c5d70b$1@forums-2-dub...
> Dear Greg
> Yes, I have tried UTF-8 as in the following ProfileString:
>
> ProfileString ( ls_inifile, "Database", "DBParm",
> "ConnectString='DSN=sppi;UID=dba;PWD=sql;UTF8=1;charset=utf8'")
> but I am keep getting question marks ????? when ever the data is in
> Arabic. No problem in getting the English character sets.
>
> "Greg Fenton" <greg.fenton_nospam_@googles-mail-site.com> wrote in message
> news:44c592a4@forums-2-dub...
>> Prof. Dr. Bachok M Taib wrote:
>>> I am developing an application using PB10 with ASA9. My question is, can
>>> I store, retrieve and display combination of two character set English
>>> and Arabic? If can how?.
>>
>> Have you tried using UTF-8 as the character set of your SQLAnywhere
>> database?
>>
>> g.f
>> --
>> Greg Fenton
>> Some Random Dude
>
>


Rob Waywell Posted on 2006-07-25 15:07:01.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <44c5863f@forums-2-dub> <44c592a4@forums-2-dub> <44c5d70b$1@forums-2-dub> <44c623a5$1@forums-1-dub>
Subject: Re: Combining two character set in an application.
Lines: 62
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <44c63395$1@forums-1-dub>
Date: 25 Jul 2006 08:07:01 -0700
X-Trace: forums-1-dub 1153840021 10.25.98.235 (25 Jul 2006 08:07:01 -0700)
X-Original-Trace: 25 Jul 2006 08:07:01 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5525
Article PK: 1562

The 1256ARA collation may be a better choice than UTF-8 since the 1256ARA
collation will actually know how to sort Arabic characters.

That said, the display problem is independent of what collation you are
using. In addition to checking the font in PB, what is the language setting
of the OS you are using?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Nick Elson" <no_span_nicelson@sybase.com> wrote in message
news:44c623a5$1@forums-1-dub...
> The database needs to be created with UTF-8 [which is really
> what Greg was suggesting].
>
>
> "Bachok M Taib" <bachok@admin.kuim.edu.my> wrote in message
> news:44c5d70b$1@forums-2-dub...
>> Dear Greg
>> Yes, I have tried UTF-8 as in the following ProfileString:
>>
>> ProfileString ( ls_inifile, "Database", "DBParm",
>> "ConnectString='DSN=sppi;UID=dba;PWD=sql;UTF8=1;charset=utf8'")
>> but I am keep getting question marks ????? when ever the data is in
>> Arabic. No problem in getting the English character sets.
>>
>> "Greg Fenton" <greg.fenton_nospam_@googles-mail-site.com> wrote in
>> message news:44c592a4@forums-2-dub...
>>> Prof. Dr. Bachok M Taib wrote:
>>>> I am developing an application using PB10 with ASA9. My question is,
>>>> can I store, retrieve and display combination of two character set
>>>> English and Arabic? If can how?.
>>>
>>> Have you tried using UTF-8 as the character set of your SQLAnywhere
>>> database?
>>>
>>> g.f
>>> --
>>> Greg Fenton
>>> Some Random Dude
>>
>>
>
>


Bachok M Taib Posted on 2006-07-26 00:22:21.0Z
From: "Bachok M Taib" <bachok@admin.kuim.edu.my>
Newsgroups: ianywhere.public.general
References: <44c5863f@forums-2-dub> <44c592a4@forums-2-dub> <44c5d70b$1@forums-2-dub> <44c623a5$1@forums-1-dub> <44c63395$1@forums-1-dub>
Subject: Re: Combining two character set in an application.
Lines: 69
Organization: KUIM
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 58.26.99.3
X-Original-NNTP-Posting-Host: 58.26.99.3
Message-ID: <44c6b5bd@forums-1-dub>
Date: 25 Jul 2006 17:22:21 -0700
X-Trace: forums-1-dub 1153873341 58.26.99.3 (25 Jul 2006 17:22:21 -0700)
X-Original-Trace: 25 Jul 2006 17:22:21 -0700, 58.26.99.3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5526
Article PK: 1565

By using 1256ARA collation sequence, I manage to solve the problem. Thanks
for all your helps
.

"Rob Waywell" <rwaywell_no_spam_please@ianywhere.com> wrote in message
news:44c63395$1@forums-1-dub...
> The 1256ARA collation may be a better choice than UTF-8 since the 1256ARA
> collation will actually know how to sort Arabic characters.
>
> That said, the display problem is independent of what collation you are
> using. In addition to checking the font in PB, what is the language
> setting of the OS you are using?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
> http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> "Nick Elson" <no_span_nicelson@sybase.com> wrote in message
> news:44c623a5$1@forums-1-dub...
>> The database needs to be created with UTF-8 [which is really
>> what Greg was suggesting].
>>
>>
>> "Bachok M Taib" <bachok@admin.kuim.edu.my> wrote in message
>> news:44c5d70b$1@forums-2-dub...
>>> Dear Greg
>>> Yes, I have tried UTF-8 as in the following ProfileString:
>>>
>>> ProfileString ( ls_inifile, "Database", "DBParm",
>>> "ConnectString='DSN=sppi;UID=dba;PWD=sql;UTF8=1;charset=utf8'")
>>> but I am keep getting question marks ????? when ever the data is in
>>> Arabic. No problem in getting the English character sets.
>>>
>>> "Greg Fenton" <greg.fenton_nospam_@googles-mail-site.com> wrote in
>>> message news:44c592a4@forums-2-dub...
>>>> Prof. Dr. Bachok M Taib wrote:
>>>>> I am developing an application using PB10 with ASA9. My question is,
>>>>> can I store, retrieve and display combination of two character set
>>>>> English and Arabic? If can how?.
>>>>
>>>> Have you tried using UTF-8 as the character set of your SQLAnywhere
>>>> database?
>>>>
>>>> g.f
>>>> --
>>>> Greg Fenton
>>>> Some Random Dude
>>>
>>>
>>
>>
>
>