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.

rows changed between retrieve and update

12 posts in DataWindow Last posting was on 2009-05-15 09:10:56.0Z
Ontsnapt Posted on 2009-05-12 12:22:45.0Z
From: Ontsnapt <ontsnapt@hotmail.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: rows changed between retrieve and update
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a096a15$1@forums-1-dub>
Date: 12 May 2009 05:22:45 -0700
X-Trace: forums-1-dub 1242130965 10.22.241.152 (12 May 2009 05:22:45 -0700)
X-Original-Trace: 12 May 2009 05:22:45 -0700, vip152.sybase.com
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89268
Article PK: 418521

PB 11.5 or PB 10.2

I asked this in the general powerbuilder group a while ago. No reaction.
In a other newsgroup I learned a command that might be helpfull.

In the database is some data that is unreadable. We try to delete the
database but allways get the message as describe.

The data is (a few examples):


description, description as binay

'ΗΛΙΚΙΑ',0xce97ce9bce99ce9ace99ce91

'ͅՁ\u05cfҁ
\u0516\x83Ɖ͠\x90ЂЋ',0xccc5d4c1d6cfd1c120d3d6c1c3c5c9cf20c1d0cfc2cfcbc7

'ͅՁ\u05cfҁ \u0516\x83Ɖ͠яʼn',0xccc5d4c1d6cfd1c120d3d6c1c3c5c9cf20d0cfc4c9c1

The database charset is UTF8.
Where clause for update and delete is: Key columns and updatable columns

1. Where can I find info how the binary matches with the character I see
on the screen
2. Since the datawindow is UTF8 I had expected ANY character could be in
without problems. Whats wrong with the above characters?
3. Anyone any idea how clients were able to get them in?

Thanks
Eric


Chris Pollach Posted on 2009-05-12 13:05:35.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a096a15$1@forums-1-dub>
Subject: Re: rows changed between retrieve and update
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a09741f$1@forums-1-dub>
Date: 12 May 2009 06:05:35 -0700
X-Trace: forums-1-dub 1242133535 10.22.241.152 (12 May 2009 06:05:35 -0700)
X-Original-Trace: 12 May 2009 06:05:35 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89271
Article PK: 418523

Hi Eric;

PB is Unicode (UTF-16LE) ... so an ANSI database if not translated properly
will look like jibberish.

Can you tell us:

1) DBMS & version
2) Your connectivity mechanism and connection parameters
3) Local code page you are using for the DB client.
etc

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"Ontsnapt" <ontsnapt@hotmail.com> wrote in message
news:4a096a15$1@forums-1-dub...
> PB 11.5 or PB 10.2
>
> I asked this in the general powerbuilder group a while ago. No reaction.
> In a other newsgroup I learned a command that might be helpfull.
>
> In the database is some data that is unreadable. We try to delete the
> database but allways get the message as describe.
>
> The data is (a few examples):
>
>
> description, description as binay
>
> '??????',0xce97ce9bce99ce9ace99ce91
>
> '??\u05cf?
> \u0516\x83D?\x90??',0xccc5d4c1d6cfd1c120d3d6c1c3c5c9cf20c1d0cfc2cfcbc7
>
> '??\u05cf? \u0516\x83D???',0xccc5d4c1d6cfd1c120d3d6c1c3c5c9cf20d0cfc4c9c1
>
> The database charset is UTF8.
> Where clause for update and delete is: Key columns and updatable columns
>
> 1. Where can I find info how the binary matches with the character I see
> on the screen
> 2. Since the datawindow is UTF8 I had expected ANY character could be in
> without problems. Whats wrong with the above characters?
> 3. Anyone any idea how clients were able to get them in?
>
> Thanks
> Eric


Ontsnapt Posted on 2009-05-13 06:05:08.0Z
From: ontsnapt <ontsnapt@hotmail.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: rows changed between retrieve and update
References: <4a096a15$1@forums-1-dub> <4a09741f$1@forums-1-dub>
In-Reply-To: <4a09741f$1@forums-1-dub>
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: <4a0a6314@forums-1-dub>
Date: 12 May 2009 23:05:08 -0700
X-Trace: forums-1-dub 1242194708 10.22.241.152 (12 May 2009 23:05:08 -0700)
X-Original-Trace: 12 May 2009 23:05:08 -0700, vip152.sybase.com
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89272
Article PK: 418526

1) DBMS = SQL Anywhere V9

2) ODBC connection Connectoption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
No other options are specified.

3) Codepage = UTF8

Thanks
Eric

Chris Pollach wrote:
> Hi Eric;
>
> PB is Unicode (UTF-16LE) ... so an ANSI database if not translated properly
> will look like jibberish.
>
> Can you tell us:
>
> 1) DBMS & version
> 2) Your connectivity mechanism and connection parameters
> 3) Local code page you are using for the DB client.
> etc
>


Chris Pollach Posted on 2009-05-13 12:21:45.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a096a15$1@forums-1-dub> <4a09741f$1@forums-1-dub> <4a0a6314@forums-1-dub>
Subject: Re: rows changed between retrieve and update
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a0abb59$1@forums-1-dub>
Date: 13 May 2009 05:21:45 -0700
X-Trace: forums-1-dub 1242217305 10.22.241.152 (13 May 2009 05:21:45 -0700)
X-Original-Trace: 13 May 2009 05:21:45 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89274
Article PK: 418524

Hmmm .. have you tried running the DBCC (Database Consistency Checker)
utility (aka "Validate the Database Contents" in Sybase Central)?
I wonder if you have some bad DB pages (blocks).

"ontsnapt" <ontsnapt@hotmail.com> wrote in message
news:4a0a6314@forums-1-dub...
>
> 1) DBMS = SQL Anywhere V9
>
> 2) ODBC connection Connectoption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
> No other options are specified.
>
> 3) Codepage = UTF8
>
> Thanks
> Eric
>
> Chris Pollach wrote:
>> Hi Eric;
>>
>> PB is Unicode (UTF-16LE) ... so an ANSI database if not translated
>> properly will look like jibberish.
>>
>> Can you tell us:
>>
>> 1) DBMS & version
>> 2) Your connectivity mechanism and connection parameters
>> 3) Local code page you are using for the DB client.
>> etc
>>


Ontsnapt Posted on 2009-05-13 12:57:14.0Z
From: ontsnapt <ontsnapt@hotmail.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: rows changed between retrieve and update
References: <4a096a15$1@forums-1-dub> <4a09741f$1@forums-1-dub> <4a0a6314@forums-1-dub> <4a0abb59$1@forums-1-dub>
In-Reply-To: <4a0abb59$1@forums-1-dub>
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: <4a0ac3aa@forums-1-dub>
Date: 13 May 2009 05:57:14 -0700
X-Trace: forums-1-dub 1242219434 10.22.241.152 (13 May 2009 05:57:14 -0700)
X-Original-Trace: 13 May 2009 05:57:14 -0700, vip152.sybase.com
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89275
Article PK: 418528

Its a difficult mistake.

DBValid.exe reports no errors. Tried it with -f and -fd.

We have this problem mostly with clients in Greece and Russia.

I don't know how it occurs. We only see it when they can't save the data
anymore.

Any ideas how I can find out which characters are not supported by
Powerbuilder?

Thanks
Eric

Chris Pollach wrote:
> Hmmm .. have you tried running the DBCC (Database Consistency Checker)
> utility (aka "Validate the Database Contents" in Sybase Central)?
> I wonder if you have some bad DB pages (blocks).
>
>
> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
> news:4a0a6314@forums-1-dub...
>> 1) DBMS = SQL Anywhere V9
>>
>> 2) ODBC connection Connectoption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
>> No other options are specified.
>>
>> 3) Codepage = UTF8
>>
>> Thanks
>> Eric
>>
>> Chris Pollach wrote:
>>> Hi Eric;
>>>
>>> PB is Unicode (UTF-16LE) ... so an ANSI database if not translated
>>> properly will look like jibberish.
>>>
>>> Can you tell us:
>>>
>>> 1) DBMS & version
>>> 2) Your connectivity mechanism and connection parameters
>>> 3) Local code page you are using for the DB client.
>>> etc
>>>
>
>


Chris Pollach Posted on 2009-05-13 15:06:23.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a096a15$1@forums-1-dub> <4a09741f$1@forums-1-dub> <4a0a6314@forums-1-dub> <4a0abb59$1@forums-1-dub> <4a0ac3aa@forums-1-dub>
Subject: Re: rows changed between retrieve and update
Lines: 62
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a0ae1ef@forums-1-dub>
Date: 13 May 2009 08:06:23 -0700
X-Trace: forums-1-dub 1242227183 10.22.241.152 (13 May 2009 08:06:23 -0700)
X-Original-Trace: 13 May 2009 08:06:23 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89276
Article PK: 418527

All characters are supported by PB as its fully Unicode.
Sounds like the problem is the translation between the ANSI ASA 9 world and
PB.

I have these type of things running today, but I use SA 10/11 Unicode
databases with PB 10.5.2, 11.2 and 11.5

"ontsnapt" <ontsnapt@hotmail.com> wrote in message
news:4a0ac3aa@forums-1-dub...
> Its a difficult mistake.
>
> DBValid.exe reports no errors. Tried it with -f and -fd.
>
> We have this problem mostly with clients in Greece and Russia.
>
> I don't know how it occurs. We only see it when they can't save the data
> anymore.
>
> Any ideas how I can find out which characters are not supported by
> Powerbuilder?
>
> Thanks
> Eric
>
> Chris Pollach wrote:
>> Hmmm .. have you tried running the DBCC (Database Consistency Checker)
>> utility (aka "Validate the Database Contents" in Sybase Central)?
>> I wonder if you have some bad DB pages (blocks).
>>
>>
>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>> news:4a0a6314@forums-1-dub...
>>> 1) DBMS = SQL Anywhere V9
>>>
>>> 2) ODBC connection
>>> Connectoption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
>>> No other options are specified.
>>>
>>> 3) Codepage = UTF8
>>>
>>> Thanks
>>> Eric
>>>
>>> Chris Pollach wrote:
>>>> Hi Eric;
>>>>
>>>> PB is Unicode (UTF-16LE) ... so an ANSI database if not translated
>>>> properly will look like jibberish.
>>>>
>>>> Can you tell us:
>>>>
>>>> 1) DBMS & version
>>>> 2) Your connectivity mechanism and connection parameters
>>>> 3) Local code page you are using for the DB client.
>>>> etc
>>>>
>>


Ontsnapt Posted on 2009-05-14 10:19:31.0Z
From: Ontsnapt <ontsnapt@hotmail.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: rows changed between retrieve and update
References: <4a096a15$1@forums-1-dub> <4a09741f$1@forums-1-dub> <4a0a6314@forums-1-dub> <4a0abb59$1@forums-1-dub> <4a0ac3aa@forums-1-dub> <4a0ae1ef@forums-1-dub>
In-Reply-To: <4a0ae1ef@forums-1-dub>
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: <4a0bf033@forums-1-dub>
Date: 14 May 2009 03:19:31 -0700
X-Trace: forums-1-dub 1242296371 10.22.241.152 (14 May 2009 03:19:31 -0700)
X-Original-Trace: 14 May 2009 03:19:31 -0700, vip152.sybase.com
Lines: 76
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89282
Article PK: 418532

Hello Chris,

You say you use unicode databases. Does this mean you use the NCHAR()
datatype instead of CHAR()?

- Is NCHAR() introduced in ASA 10?

- Is CHAR(40) the same as NCHAR(10)?

- Can a datatype be changed from CHAR(10) to NCHAR(10) without problems,
or is a data conversion needed?

Thanks
Eric

Chris Pollach schreef:

> All characters are supported by PB as its fully Unicode.
> Sounds like the problem is the translation between the ANSI ASA 9 world and
> PB.
>
> I have these type of things running today, but I use SA 10/11 Unicode
> databases with PB 10.5.2, 11.2 and 11.5
>
>
>
>
> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
> news:4a0ac3aa@forums-1-dub...
>> Its a difficult mistake.
>>
>> DBValid.exe reports no errors. Tried it with -f and -fd.
>>
>> We have this problem mostly with clients in Greece and Russia.
>>
>> I don't know how it occurs. We only see it when they can't save the data
>> anymore.
>>
>> Any ideas how I can find out which characters are not supported by
>> Powerbuilder?
>>
>> Thanks
>> Eric
>>
>> Chris Pollach wrote:
>>> Hmmm .. have you tried running the DBCC (Database Consistency Checker)
>>> utility (aka "Validate the Database Contents" in Sybase Central)?
>>> I wonder if you have some bad DB pages (blocks).
>>>
>>>
>>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>>> news:4a0a6314@forums-1-dub...
>>>> 1) DBMS = SQL Anywhere V9
>>>>
>>>> 2) ODBC connection
>>>> Connectoption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
>>>> No other options are specified.
>>>>
>>>> 3) Codepage = UTF8
>>>>
>>>> Thanks
>>>> Eric
>>>>
>>>> Chris Pollach wrote:
>>>>> Hi Eric;
>>>>>
>>>>> PB is Unicode (UTF-16LE) ... so an ANSI database if not translated
>>>>> properly will look like jibberish.
>>>>>
>>>>> Can you tell us:
>>>>>
>>>>> 1) DBMS & version
>>>>> 2) Your connectivity mechanism and connection parameters
>>>>> 3) Local code page you are using for the DB client.
>>>>> etc
>>>>>
>


Chris Pollach Posted on 2009-05-14 10:58:41.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a096a15$1@forums-1-dub> <4a09741f$1@forums-1-dub> <4a0a6314@forums-1-dub> <4a0abb59$1@forums-1-dub> <4a0ac3aa@forums-1-dub> <4a0ae1ef@forums-1-dub> <4a0bf033@forums-1-dub>
Subject: Re: rows changed between retrieve and update
Lines: 84
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a0bf961$1@forums-1-dub>
Date: 14 May 2009 03:58:41 -0700
X-Trace: forums-1-dub 1242298721 10.22.241.152 (14 May 2009 03:58:41 -0700)
X-Original-Trace: 14 May 2009 03:58:41 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89283
Article PK: 418535

Correct .. I use the Nxxxx data types.

"Ontsnapt" <ontsnapt@hotmail.com> wrote in message
news:4a0bf033@forums-1-dub...
> Hello Chris,
>
> You say you use unicode databases. Does this mean you use the NCHAR()
> datatype instead of CHAR()?
>
> - Is NCHAR() introduced in ASA 10?
>
> - Is CHAR(40) the same as NCHAR(10)?
>
> - Can a datatype be changed from CHAR(10) to NCHAR(10) without problems,
> or is a data conversion needed?
>
> Thanks
> Eric
>
> Chris Pollach schreef:
>> All characters are supported by PB as its fully Unicode.
>> Sounds like the problem is the translation between the ANSI ASA 9 world
>> and PB.
>>
>> I have these type of things running today, but I use SA 10/11 Unicode
>> databases with PB 10.5.2, 11.2 and 11.5
>>
>>
>>
>>
>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>> news:4a0ac3aa@forums-1-dub...
>>> Its a difficult mistake.
>>>
>>> DBValid.exe reports no errors. Tried it with -f and -fd.
>>>
>>> We have this problem mostly with clients in Greece and Russia.
>>>
>>> I don't know how it occurs. We only see it when they can't save the data
>>> anymore.
>>>
>>> Any ideas how I can find out which characters are not supported by
>>> Powerbuilder?
>>>
>>> Thanks
>>> Eric
>>>
>>> Chris Pollach wrote:
>>>> Hmmm .. have you tried running the DBCC (Database Consistency Checker)
>>>> utility (aka "Validate the Database Contents" in Sybase Central)?
>>>> I wonder if you have some bad DB pages (blocks).
>>>>
>>>>
>>>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>>>> news:4a0a6314@forums-1-dub...
>>>>> 1) DBMS = SQL Anywhere V9
>>>>>
>>>>> 2) ODBC connection
>>>>> Connectoption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
>>>>> No other options are specified.
>>>>>
>>>>> 3) Codepage = UTF8
>>>>>
>>>>> Thanks
>>>>> Eric
>>>>>
>>>>> Chris Pollach wrote:
>>>>>> Hi Eric;
>>>>>>
>>>>>> PB is Unicode (UTF-16LE) ... so an ANSI database if not translated
>>>>>> properly will look like jibberish.
>>>>>>
>>>>>> Can you tell us:
>>>>>>
>>>>>> 1) DBMS & version
>>>>>> 2) Your connectivity mechanism and connection parameters
>>>>>> 3) Local code page you are using for the DB client.
>>>>>> etc
>>>>>>
>>


"Chris Keating [Sybase iAnywhere]" <keating_no Posted on 2009-05-14 12:54:10.0Z
From: "Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: rows changed between retrieve and update
References: <4a096a15$1@forums-1-dub> <4a09741f$1@forums-1-dub> <4a0a6314@forums-1-dub> <4a0abb59$1@forums-1-dub> <4a0ac3aa@forums-1-dub> <4a0ae1ef@forums-1-dub> <4a0bf033@forums-1-dub>
In-Reply-To: <4a0bf033@forums-1-dub>
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: <4a0c1472$1@forums-1-dub>
Date: 14 May 2009 05:54:10 -0700
X-Trace: forums-1-dub 1242305650 10.22.241.152 (14 May 2009 05:54:10 -0700)
X-Original-Trace: 14 May 2009 05:54:10 -0700, vip152.sybase.com
Lines: 107
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89285
Article PK: 418537

"Adaptive Server Anywhere supports variable width 8-bit character sets.
In these sets, some characters are represented by one byte, and some by
more than one, to a maximum of four bytes." "All client libraries other
than embedded SQL are Unicode-enabled, using the UTF-16 encoding.
Translation occurs between the client and the server."

SQL Anywhere 9 is not limited to ANSI characters and until SA - as I
have pointed out in previous posts where that claim was made. PB10 being
UNICODE is simply an element that plays into the many layers that play a
role in how characters are handled.

When characters are displayed incorrectly, it is almost always the
result of some translation in the intermediate layer i.e., a difference
between the application, the database, and the OS interpretation of a
byte sequence that represents the character. It could be as simple as
using a display font which does not represent the character to more
complex issues.

I refer you back to your post in the SQL Anywhere newsgroup when you ran
into challenges during a rebuild of a database. Specifically, the
discussion on this topic by John Smirnios. The documentation also covers
this topic. See

ASA Database Administration Guide
International Languages and Character Sets


-chris

Ontsnapt wrote:
> Hello Chris,
>
> You say you use unicode databases. Does this mean you use the NCHAR()
> datatype instead of CHAR()?
>
> - Is NCHAR() introduced in ASA 10?
>
> - Is CHAR(40) the same as NCHAR(10)?
>
> - Can a datatype be changed from CHAR(10) to NCHAR(10) without problems,
> or is a data conversion needed?
>
> Thanks
> Eric
>
> Chris Pollach schreef:
>> All characters are supported by PB as its fully Unicode.
>> Sounds like the problem is the translation between the ANSI ASA 9
>> world and PB.
>>
>> I have these type of things running today, but I use SA 10/11 Unicode
>> databases with PB 10.5.2, 11.2 and 11.5
>>
>>
>>
>>
>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>> news:4a0ac3aa@forums-1-dub...
>>> Its a difficult mistake.
>>>
>>> DBValid.exe reports no errors. Tried it with -f and -fd.
>>>
>>> We have this problem mostly with clients in Greece and Russia.
>>>
>>> I don't know how it occurs. We only see it when they can't save the
>>> data anymore.
>>>
>>> Any ideas how I can find out which characters are not supported by
>>> Powerbuilder?
>>>
>>> Thanks
>>> Eric
>>>
>>> Chris Pollach wrote:
>>>> Hmmm .. have you tried running the DBCC (Database Consistency
>>>> Checker) utility (aka "Validate the Database Contents" in Sybase
>>>> Central)?
>>>> I wonder if you have some bad DB pages (blocks).
>>>>
>>>>
>>>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>>>> news:4a0a6314@forums-1-dub...
>>>>> 1) DBMS = SQL Anywhere V9
>>>>>
>>>>> 2) ODBC connection
>>>>> Connectoption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
>>>>> No other options are specified.
>>>>>
>>>>> 3) Codepage = UTF8
>>>>>
>>>>> Thanks
>>>>> Eric
>>>>>
>>>>> Chris Pollach wrote:
>>>>>> Hi Eric;
>>>>>>
>>>>>> PB is Unicode (UTF-16LE) ... so an ANSI database if not
>>>>>> translated properly will look like jibberish.
>>>>>>
>>>>>> Can you tell us:
>>>>>>
>>>>>> 1) DBMS & version
>>>>>> 2) Your connectivity mechanism and connection parameters
>>>>>> 3) Local code page you are using for the DB client.
>>>>>> etc
>>>>>>
>>


Ontsnapt Posted on 2009-05-15 07:10:25.0Z
From: ontsnapt <ontsnapt@hotmail.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: rows changed between retrieve and update
References: <4a096a15$1@forums-1-dub> <4a09741f$1@forums-1-dub> <4a0a6314@forums-1-dub> <4a0abb59$1@forums-1-dub> <4a0ac3aa@forums-1-dub> <4a0ae1ef@forums-1-dub> <4a0bf033@forums-1-dub> <4a0c1472$1@forums-1-dub>
In-Reply-To: <4a0c1472$1@forums-1-dub>
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: <4a0d1561$1@forums-1-dub>
Date: 15 May 2009 00:10:25 -0700
X-Trace: forums-1-dub 1242371425 10.22.241.152 (15 May 2009 00:10:25 -0700)
X-Original-Trace: 15 May 2009 00:10:25 -0700, vip152.sybase.com
Lines: 108
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89298
Article PK: 418549


Chris Keating [Sybase iAnywhere] wrote:
> "Adaptive Server Anywhere supports variable width 8-bit character sets.
> In these sets, some characters are represented by one byte, and some by
> more than one, to a maximum of four bytes." "All client libraries other
> than embedded SQL are Unicode-enabled, using the UTF-16 encoding.
> Translation occurs between the client and the server."
>
> SQL Anywhere 9 is not limited to ANSI characters and until SA - as I
> have pointed out in previous posts where that claim was made. PB10 being
> UNICODE is simply an element that plays into the many layers that play a
> role in how characters are handled.
>
> When characters are displayed incorrectly, it is almost always the
> result of some translation in the intermediate layer i.e., a difference
> between the application, the database, and the OS interpretation of a
> byte sequence that represents the character. It could be as simple as
> using a display font which does not represent the character to more
> complex issues.
>
> I refer you back to your post in the SQL Anywhere newsgroup when you ran
> into challenges during a rebuild of a database. Specifically, the
> discussion on this topic by John Smirnios. The documentation also covers
> this topic. See
>
> ASA Database Administration Guide
> International Languages and Character Sets
>
>
> -chris
>
> Ontsnapt wrote:
>> Hello Chris,
>>
>> You say you use unicode databases. Does this mean you use the NCHAR()
>> datatype instead of CHAR()?
>>
>> - Is NCHAR() introduced in ASA 10?
>>
>> - Is CHAR(40) the same as NCHAR(10)?
>>
>> - Can a datatype be changed from CHAR(10) to NCHAR(10) without
>> problems, or is a data conversion needed?
>>
>> Thanks
>> Eric
>>
>> Chris Pollach schreef:
>>> All characters are supported by PB as its fully Unicode.
>>> Sounds like the problem is the translation between the ANSI ASA 9
>>> world and PB.
>>>
>>> I have these type of things running today, but I use SA 10/11 Unicode
>>> databases with PB 10.5.2, 11.2 and 11.5
>>>
>>>
>>>
>>>
>>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>>> news:4a0ac3aa@forums-1-dub...
>>>> Its a difficult mistake.
>>>>
>>>> DBValid.exe reports no errors. Tried it with -f and -fd.
>>>>
>>>> We have this problem mostly with clients in Greece and Russia.
>>>>
>>>> I don't know how it occurs. We only see it when they can't save the
>>>> data anymore.
>>>>
>>>> Any ideas how I can find out which characters are not supported by
>>>> Powerbuilder?
>>>>
>>>> Thanks
>>>> Eric
>>>>
>>>> Chris Pollach wrote:
>>>>> Hmmm .. have you tried running the DBCC (Database Consistency
>>>>> Checker) utility (aka "Validate the Database Contents" in Sybase
>>>>> Central)?
>>>>> I wonder if you have some bad DB pages (blocks).
>>>>>
>>>>>
>>>>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>>>>> news:4a0a6314@forums-1-dub...
>>>>>> 1) DBMS = SQL Anywhere V9
>>>>>>
>>>>>> 2) ODBC connection
>>>>>> Connectoption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
>>>>>> No other options are specified.
>>>>>>
>>>>>> 3) Codepage = UTF8
>>>>>>
>>>>>> Thanks
>>>>>> Eric
>>>>>>
>>>>>> Chris Pollach wrote:
>>>>>>> Hi Eric;
>>>>>>>
>>>>>>> PB is Unicode (UTF-16LE) ... so an ANSI database if not
>>>>>>> translated properly will look like jibberish.
>>>>>>>
>>>>>>> Can you tell us:
>>>>>>>
>>>>>>> 1) DBMS & version
>>>>>>> 2) Your connectivity mechanism and connection parameters
>>>>>>> 3) Local code page you are using for the DB client.
>>>>>>> etc
>>>>>>>
>>>


Ontsnapt Posted on 2009-05-15 09:10:56.0Z
From: ontsnapt <ontsnapt@hotmail.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: rows changed between retrieve and update
References: <4a096a15$1@forums-1-dub> <4a09741f$1@forums-1-dub> <4a0a6314@forums-1-dub> <4a0abb59$1@forums-1-dub> <4a0ac3aa@forums-1-dub> <4a0ae1ef@forums-1-dub> <4a0bf033@forums-1-dub> <4a0c1472$1@forums-1-dub>
In-Reply-To: <4a0c1472$1@forums-1-dub>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a0d31a0@forums-1-dub>
Date: 15 May 2009 02:10:56 -0700
X-Trace: forums-1-dub 1242378656 10.22.241.152 (15 May 2009 02:10:56 -0700)
X-Original-Trace: 15 May 2009 02:10:56 -0700, vip152.sybase.com
Lines: 136
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89299
Article PK: 418550

Hello Chris,

Thanks for the info. Yes, some rebuild we did were not correct and some
strange signs are on the screen. We have to accept that for now. I
althought thought that the input of characters went wrong. However this
war not correct because a rebuild was done before where I wasn't aware off.

What I don't understand is (and was my original question):
powerbuilder displays the data but can't update it anymore.

So, retrieve column abrev and description with datawindow, change abrev
and update it.
update ... set abrev = where description = <the retrieved description>'.

The description does not equal 'the retrieved description' anymore
alhough we did not change anything. The retrieved description has the
strange signs.

Maybe a character is responsible for this and would like to find out
which one. Where can I find more info what the binary represents and how
to interpreted it? For example 'ΗΛΙΚΙΑ' is binary
0xce97ce9bce99ce9ace99ce91.

Thanks
Eric

Chris Keating [Sybase iAnywhere] wrote:
> "Adaptive Server Anywhere supports variable width 8-bit character sets.
> In these sets, some characters are represented by one byte, and some by
> more than one, to a maximum of four bytes." "All client libraries other
> than embedded SQL are Unicode-enabled, using the UTF-16 encoding.
> Translation occurs between the client and the server."
>
> SQL Anywhere 9 is not limited to ANSI characters and until SA - as I
> have pointed out in previous posts where that claim was made. PB10 being
> UNICODE is simply an element that plays into the many layers that play a
> role in how characters are handled.
>
> When characters are displayed incorrectly, it is almost always the
> result of some translation in the intermediate layer i.e., a difference
> between the application, the database, and the OS interpretation of a
> byte sequence that represents the character. It could be as simple as
> using a display font which does not represent the character to more
> complex issues.
>
> I refer you back to your post in the SQL Anywhere newsgroup when you ran
> into challenges during a rebuild of a database. Specifically, the
> discussion on this topic by John Smirnios. The documentation also covers
> this topic. See
>
> ASA Database Administration Guide
> International Languages and Character Sets
>
>
> -chris
>
> Ontsnapt wrote:
>> Hello Chris,
>>
>> You say you use unicode databases. Does this mean you use the NCHAR()
>> datatype instead of CHAR()?
>>
>> - Is NCHAR() introduced in ASA 10?
>>
>> - Is CHAR(40) the same as NCHAR(10)?
>>
>> - Can a datatype be changed from CHAR(10) to NCHAR(10) without
>> problems, or is a data conversion needed?
>>
>> Thanks
>> Eric
>>
>> Chris Pollach schreef:
>>> All characters are supported by PB as its fully Unicode.
>>> Sounds like the problem is the translation between the ANSI ASA 9
>>> world and PB.
>>>
>>> I have these type of things running today, but I use SA 10/11 Unicode
>>> databases with PB 10.5.2, 11.2 and 11.5
>>>
>>>
>>>
>>>
>>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>>> news:4a0ac3aa@forums-1-dub...
>>>> Its a difficult mistake.
>>>>
>>>> DBValid.exe reports no errors. Tried it with -f and -fd.
>>>>
>>>> We have this problem mostly with clients in Greece and Russia.
>>>>
>>>> I don't know how it occurs. We only see it when they can't save the
>>>> data anymore.
>>>>
>>>> Any ideas how I can find out which characters are not supported by
>>>> Powerbuilder?
>>>>
>>>> Thanks
>>>> Eric
>>>>
>>>> Chris Pollach wrote:
>>>>> Hmmm .. have you tried running the DBCC (Database Consistency
>>>>> Checker) utility (aka "Validate the Database Contents" in Sybase
>>>>> Central)?
>>>>> I wonder if you have some bad DB pages (blocks).
>>>>>
>>>>>
>>>>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>>>>> news:4a0a6314@forums-1-dub...
>>>>>> 1) DBMS = SQL Anywhere V9
>>>>>>
>>>>>> 2) ODBC connection
>>>>>> Connectoption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
>>>>>> No other options are specified.
>>>>>>
>>>>>> 3) Codepage = UTF8
>>>>>>
>>>>>> Thanks
>>>>>> Eric
>>>>>>
>>>>>> Chris Pollach wrote:
>>>>>>> Hi Eric;
>>>>>>>
>>>>>>> PB is Unicode (UTF-16LE) ... so an ANSI database if not
>>>>>>> translated properly will look like jibberish.
>>>>>>>
>>>>>>> Can you tell us:
>>>>>>>
>>>>>>> 1) DBMS & version
>>>>>>> 2) Your connectivity mechanism and connection parameters
>>>>>>> 3) Local code page you are using for the DB client.
>>>>>>> etc
>>>>>>>
>>>


Ontsnapt Posted on 2009-05-14 05:43:00.0Z
From: Ontsnapt <ontsnapt@hotmail.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: rows changed between retrieve and update
References: <4a096a15$1@forums-1-dub> <4a09741f$1@forums-1-dub> <4a0a6314@forums-1-dub> <4a0abb59$1@forums-1-dub> <4a0ac3aa@forums-1-dub> <4a0ae1ef@forums-1-dub>
In-Reply-To: <4a0ae1ef@forums-1-dub>
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: <4a0baf64$1@forums-1-dub>
Date: 13 May 2009 22:43:00 -0700
X-Trace: forums-1-dub 1242279780 10.22.241.152 (13 May 2009 22:43:00 -0700)
X-Original-Trace: 13 May 2009 22:43:00 -0700, vip152.sybase.com
Lines: 72
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89280
Article PK: 418534

Our database is unicode.

SELECT db_property('MultiByteCharSet') FROM dummy; returns ON.
In table sys.syscollation column collation label = UTF8.

Thanks
Eric




Chris Pollach schreef:

> All characters are supported by PB as its fully Unicode.
> Sounds like the problem is the translation between the ANSI ASA 9 world and
> PB.
>
> I have these type of things running today, but I use SA 10/11 Unicode
> databases with PB 10.5.2, 11.2 and 11.5
>
>
>
>
> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
> news:4a0ac3aa@forums-1-dub...
>> Its a difficult mistake.
>>
>> DBValid.exe reports no errors. Tried it with -f and -fd.
>>
>> We have this problem mostly with clients in Greece and Russia.
>>
>> I don't know how it occurs. We only see it when they can't save the data
>> anymore.
>>
>> Any ideas how I can find out which characters are not supported by
>> Powerbuilder?
>>
>> Thanks
>> Eric
>>
>> Chris Pollach wrote:
>>> Hmmm .. have you tried running the DBCC (Database Consistency Checker)
>>> utility (aka "Validate the Database Contents" in Sybase Central)?
>>> I wonder if you have some bad DB pages (blocks).
>>>
>>>
>>> "ontsnapt" <ontsnapt@hotmail.com> wrote in message
>>> news:4a0a6314@forums-1-dub...
>>>> 1) DBMS = SQL Anywhere V9
>>>>
>>>> 2) ODBC connection
>>>> Connectoption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
>>>> No other options are specified.
>>>>
>>>> 3) Codepage = UTF8
>>>>
>>>> Thanks
>>>> Eric
>>>>
>>>> Chris Pollach wrote:
>>>>> Hi Eric;
>>>>>
>>>>> PB is Unicode (UTF-16LE) ... so an ANSI database if not translated
>>>>> properly will look like jibberish.
>>>>>
>>>>> Can you tell us:
>>>>>
>>>>> 1) DBMS & version
>>>>> 2) Your connectivity mechanism and connection parameters
>>>>> 3) Local code page you are using for the DB client.
>>>>> etc
>>>>>
>