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.

Arabic-English Problem

3 posts in DataWindow Last posting was on 2009-04-27 14:32:21.0Z
Tony Posted on 2009-04-14 07:13:27.0Z
Sender: 195e.49e42b8d.1804289383@sybase.com
From: tony
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Arabic-English Problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49e43797.1a68.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Apr 2009 00:13:27 -0700
X-Trace: forums-1-dub 1239693207 10.22.241.41 (14 Apr 2009 00:13:27 -0700)
X-Original-Trace: 14 Apr 2009 00:13:27 -0700, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89160
Article PK: 418411

hi,

we migrated our app from pb9 to pb11.
we have dwo's which use english and arabic fonts on person
names.

the problem is when coming from an edit column with arabic
font and tabbing to an edit colmn with english font, the
english edit column writes arabic. the language bar key
input stays in arabic.

we already tried playing with character set property of the
font, but was not successful.
this happens in the datawindow designer and at runtime.

thanks


Thomas Waldorff Posted on 2009-04-14 09:15:49.0Z
Sender: 1c59.49e44ed4.1804289383@sybase.com
From: Thomas Waldorff
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Arabic-English Problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49e45445.1ce6.1681692777@sybase.com>
References: <49e43797.1a68.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Apr 2009 02:15:49 -0700
X-Trace: forums-1-dub 1239700549 10.22.241.41 (14 Apr 2009 02:15:49 -0700)
X-Original-Trace: 14 Apr 2009 02:15:49 -0700, 10.22.241.41
Lines: 66
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89161
Article PK: 418413

Hi

When you switched from PB9 to PB11 you also switched to
unicode pb, but the question is did you also switch your
database to unicode? You description indicates that this is
not the case.

If you had, you would not have to deal with charset, as all
charsets are displayable at all times, but only with
keyboard layout. Here you can see how you can control
keyboard layout:

External functions:
Function long GetKeyboardLayout (long IdThread) Library
"user32.dll"

Function long ActivateKeyboardLayout (long HKL, long flags)
Library "user32.dll"


type variables
private:
Constant long KLF_REORDER = 8
Constant long lang_US_English = 67699721

long CurrentLayout

end variables

public subroutine of_getkbdlocal ();CurrentLayout =
GetKeyboardLayout(0)
end subroutine

public subroutine of_setkbdeng
();ActivateKeyboardLayout(lang_US_English, KLF_REORDER)
end subroutine

public subroutine of_setkbdlocal
();ActivateKeyboardLayout(CurrentLayout, KLF_REORDER)
end subroutine

You can then use getfocus and losefocus events of the
field/column to set the keyboard layout you want.

If you want by be multilingual I can only recommend that you
go Unicode all the way, both PB and database.

regards
Thomas

> hi,
>
> we migrated our app from pb9 to pb11.
> we have dwo's which use english and arabic fonts on person
> names.
>
> the problem is when coming from an edit column with arabic
> font and tabbing to an edit colmn with english font, the
> english edit column writes arabic. the language bar key
> input stays in arabic.
>
> we already tried playing with character set property of
> the font, but was not successful.
> this happens in the datawindow designer and at runtime.
>
> thanks


Tony Posted on 2009-04-27 14:32:21.0Z
Sender: 170b.49f5b0a1.1804289383@sybase.com
From: tony
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Arabic-English Problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49f5c1f5.195c.1681692777@sybase.com>
References: <49e45445.1ce6.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Apr 2009 07:32:21 -0700
X-Trace: forums-1-dub 1240842741 10.22.241.41 (27 Apr 2009 07:32:21 -0700)
X-Original-Trace: 27 Apr 2009 07:32:21 -0700, 10.22.241.41
Lines: 76
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89202
Article PK: 418454

hi,

yes, the same solution you provided was also what we
applied. Regarding the Database we have Oracle 9i using
AR8ISO8859P6,UTF8. Of course, we will still have the same
problem when designing the DW Object because the fix applies
during runtime.

thanks,

> Hi
>
> When you switched from PB9 to PB11 you also switched to
> unicode pb, but the question is did you also switch your
> database to unicode? You description indicates that this
> is not the case.
>
> If you had, you would not have to deal with charset, as
> all charsets are displayable at all times, but only with
> keyboard layout. Here you can see how you can control
> keyboard layout:
>
> External functions:
> Function long GetKeyboardLayout (long IdThread) Library
> "user32.dll"
>
> Function long ActivateKeyboardLayout (long HKL, long
> flags) Library "user32.dll"
>
>
> type variables
> private:
> Constant long KLF_REORDER = 8
> Constant long lang_US_English = 67699721
>
> long CurrentLayout
>
> end variables
>
> public subroutine of_getkbdlocal ();CurrentLayout =
> GetKeyboardLayout(0)
> end subroutine
>
> public subroutine of_setkbdeng
> ();ActivateKeyboardLayout(lang_US_English, KLF_REORDER)
> end subroutine
>
> public subroutine of_setkbdlocal
> ();ActivateKeyboardLayout(CurrentLayout, KLF_REORDER)
> end subroutine
>
> You can then use getfocus and losefocus events of the
> field/column to set the keyboard layout you want.
>
> If you want by be multilingual I can only recommend that
> you go Unicode all the way, both PB and database.
>
> regards
> Thomas
>
> > hi,
> >
> > we migrated our app from pb9 to pb11.
> > we have dwo's which use english and arabic fonts on
> > person names.
> >
> > the problem is when coming from an edit column with
> > arabic font and tabbing to an edit colmn with english
> > font, the english edit column writes arabic. the
> > language bar key input stays in arabic.
> >
> > we already tried playing with character set property of
> > the font, but was not successful.
> > this happens in the datawindow designer and at runtime.
> >
> > thanks