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

2 posts in General Discussion (Chinese) Last posting was on 2008-05-09 09:10:34.0Z
Bala Posted on 2008-05-05 12:02:45.0Z
Sender: 4b12.481ef3f5.1804289383@sybase.com
From: Bala
Newsgroups: sybase.public.chinese.powerbuilder.general
Subject: Powerbuilder 11 does not save the transaction with Chinese characters
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <481ef764.4b77.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub481ef764"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 May 2008 05:02:45 -0700
X-Trace: forums-1-dub 1209988965 10.22.241.41 (5 May 2008 05:02:45 -0700)
X-Original-Trace: 5 May 2008 05:02:45 -0700, 10.22.241.41
Lines: 6507
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.chinese.powerbuilder.general:350
Article PK: 104382

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

Regional setting.JPG
Transaction Entered.JPG
DB Error.JPG

qliang Posted on 2008-05-09 09:10:34.0Z
Sender: 3ddb.48240b75.1804289383@sybase.com
From: qliang
Newsgroups: sybase.public.chinese.powerbuilder.general
Subject: Re: Powerbuilder 11 does not save the transaction with Chinese characters
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4824150a.3eab.1681692777@sybase.com>
References: <481ef764.4b77.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 May 2008 02:10:34 -0700
X-Trace: forums-1-dub 1210324234 10.22.241.41 (9 May 2008 02:10:34 -0700)
X-Original-Trace: 9 May 2008 02:10:34 -0700, 10.22.241.41
Lines: 56
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.chinese.powerbuilder.general:355
Article PK: 104376


> 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
>
>
>
>
> [Attachment: Regional setting.JPG]
> [Attachment: Transaction Entered.JPG]
> [Attachment: DB Error.JPG]

Powerbuilder supports unicode since version 10, every
character you input in an edit will be treated as an unicode
character. So the Beneficiary fields can accept 35
characters because it's limit is set to 35. However, your db
table field length is same as before, this might cause error
when updating db.

I think the most quick and safe solution for your situation
is changing limit property value of Beneficiary fields.