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.

Powerbuilder 11 does not save the transaction with Chinese characters

4 posts in DataWindow Last posting was on 2008-05-09 13:43:29.0Z
Bala Posted on 2008-05-06 04:35:55.0Z
Sender: 4b12.481ef3f5.1804289383@sybase.com
From: Bala
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Powerbuilder 11 does not save the transaction with Chinese characters
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <481fe02b.86c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 May 2008 21:35:55 -0700
X-Trace: forums-1-dub 1210048555 10.22.241.41 (5 May 2008 21:35:55 -0700)
X-Original-Trace: 5 May 2008 21:35:55 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86778
Article PK: 416037

Dear All,

I have raised a critical issue in the Chinese Powerbuilder
forum.

Please get the issue description from the below link.

http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=item-350&group=sybase.public.chinese.powerbuilder.general


Kindly get me a solution for the issue.

Thanks,
Bala


"Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_ Posted on 2008-05-06 14:39:27.0Z
From: "Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_@_teamsybase.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Powerbuilder 11 does not save the transaction with Chinese characters
References: <481fe02b.86c.1681692777@sybase.com>
In-Reply-To: <481fe02b.86c.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48206d9f$1@forums-1-dub>
Date: 6 May 2008 07:39:27 -0700
X-Trace: forums-1-dub 1210084767 10.22.241.152 (6 May 2008 07:39:27 -0700)
X-Original-Trace: 6 May 2008 07:39:27 -0700, vip152.sybase.com
Lines: 86
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86783
Article PK: 416041

With PB10, PowerBuilder started using Unicode. In PB9, it was DBCS. This
change is probably what is causing the behavior you see. The simple
answer is to set a size limit on the datawindow column (properties pane,
"Edit" tab, "Limit" field). There may be some tricks at the connectivity
level to fix this, as well, but I'm no Oracle expert and have nothing to
offer in that area.


-----------------------
NewsGroup: sybase.public.chinese.powerbuilder.general
Date: May 5,2008 04:02 am
Created by: Bala
Topic: Powerbuilder 11 does not save the transaction with Chinese
characters
Attachments: Regional_setting.JPG Transaction_Entered.JPG DB_Error.JPG

Hi,

I am getting an strange issue, which I have explained below:
-------------------------------------------------------------
1. We have migrated our application from PB 9 to PB 11.
2. We have a screen where we use to enter Chinese characters
into the Beneficiary fields which is of type STRING & LENGTH
35.
3. The Beneficiary fields in PB 9 use to accept only 17
characters though its LENGTH is 35 since the Chienese
characters are of two byte. This is fine. This is the way it
should work.
4. But the same Beneficiary fields in PB 11 are accepting 35
characters but while saving, it is throwing the following
database error ( You can see the error message attached)
5. Basically the PB 11 should not allow us to enter 35
characters rather it should us to enter 17 characters as PB
9 is working.

Environmental Details:
----------------------
1. We are using Powerbuilder Version 11.0 Build 6525
2. Using Windows XP Service Pack 2, Regional Setting is
Chinese PRC (Find more details from the regional setting
attachment).
3. Our database is Oracle 10G with US7ASCII characterset.
4. Our PB Profile is as below.
SQLCA.DBMS = "O10 Oracle10g (10.1.0)"
SQLCA.LogPass = <TIGER>
SQLCA.ServerName = "DBNAME"
SQLCA.LogId = "SCOTT"
SQLCA.AutoCommit = False
SQLCA.DBParm = "NLS_Charset='Local'"

Kindly give me some solution for this issue asap.

Thanks,
Bala

---------------------

Bala wrote:
> Dear All,
>
> I have raised a critical issue in the Chinese Powerbuilder
> forum.
>
> Please get the issue description from the below link.
>
> http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=item-350&group=sybase.public.chinese.powerbuilder.general
>
>
> Kindly get me a solution for the issue.
>
> Thanks,
> Bala

--
Off topic:
Sybase has been reviewing NNTP availability and is looking at
alternative ways to build a user community. As a test-bed /
proof-of-concept, I have personally created a community on Ning
(http://powerbuilder.ning.com). While Ning certainly doesn't offer all
of the features that I'd like to see Sybase eventually implement, I am
trying to foster some community involvement on that site. Several of the
TeamSybase members have joined already and are available to answer
questions there.

Please sign up; give it a try. My hope is that it evolves into more than
just a Q&A database, but it won't get there without your participation.


Millard F. Brown III Posted on 2008-05-08 19:42:04.0Z
From: "Millard F. Brown III" <millard.brown@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <481fe02b.86c.1681692777@sybase.com>
Subject: Re: Powerbuilder 11 does not save the transaction with Chinese characters
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4823578c$1@forums-1-dub>
Date: 8 May 2008 12:42:04 -0700
X-Trace: forums-1-dub 1210275724 10.22.241.152 (8 May 2008 12:42:04 -0700)
X-Original-Trace: 8 May 2008 12:42:04 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86795
Article PK: 416054

I left you a reply in the '.datawindow' newsgroup.

--
Regards,
Millard [TeamSybase]

<Bala> wrote in message news:481fe02b.86c.1681692777@sybase.com...
> Dear All,
>
> I have raised a critical issue in the Chinese Powerbuilder
> forum.
>
> Please get the issue description from the below link.
>
> http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=item-350&group=sybase.public.chinese.powerbuilder.general
>
>
> Kindly get me a solution for the issue.
>
> Thanks,
> Bala


Damir Grbic Posted on 2008-05-09 13:43:29.0Z
From: "Damir Grbic" <dgrbic@eisen.de>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <481fe02b.86c.1681692777@sybase.com> <4823578c$1@forums-1-dub>
Subject: Re: Powerbuilder 11 does not save the transaction with Chinese characters
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48245501$1@forums-1-dub>
Date: 9 May 2008 06:43:29 -0700
X-Trace: forums-1-dub 1210340609 10.22.241.152 (9 May 2008 06:43:29 -0700)
X-Original-Trace: 9 May 2008 06:43:29 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86796
Article PK: 416055

Hallo,
Are your database columns defined as VARCHAR2( 35 char), VARCHAR2( 66
char)?
By default Oracle defines the length in bytes not in chars.
Regards, Damir

"Millard F. Brown III" <millard.brown@teamsybase.com> schrieb im Newsbeitrag
news:4823578c$1@forums-1-dub...

>I left you a reply in the '.datawindow' newsgroup.
>
> --
> Regards,
> Millard [TeamSybase]
>
> <Bala> wrote in message news:481fe02b.86c.1681692777@sybase.com...
>> Dear All,
>>
>> I have raised a critical issue in the Chinese Powerbuilder
>> forum.
>>
>> Please get the issue description from the below link.
>>
>> http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=item-350&group=sybase.public.chinese.powerbuilder.general
>>
>>
>> Kindly get me a solution for the issue.
>>
>> Thanks,
>> Bala
>
>