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.

application

4 posts in General Discussion Last posting was on 2004-12-24 15:23:48.0Z
Eric Verhorstert Posted on 2004-12-23 15:47:55.0Z
From: Eric Verhorstert <eric.verhorstert@farm.nl>
User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: application
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: a80-127-106-91.adsl.xs4all.nl
X-Original-NNTP-Posting-Host: a80-127-106-91.adsl.xs4all.nl
Message-ID: <41cae8ab@forums-1-dub>
Date: 23 Dec 2004 07:47:55 -0800
X-Trace: forums-1-dub 1103816875 80.127.106.91 (23 Dec 2004 07:47:55 -0800)
X-Original-Trace: 23 Dec 2004 07:47:55 -0800, a80-127-106-91.adsl.xs4all.nl
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4009
Article PK: 7901

We have a powerbuilder application which is translated in 15 languages.
The text is store in the database (ASA 7).

Now we have converted the program from powerbuilder 6.5 to powerbuilder
10. Powerbuilder 10 is unicode.

In our program is a translation utility. I copied a russian text from
the internet to the text field in powerbuilder. Yes, it still is Russian.

Now I store it in the database and then retrieve it. What I get back is
???????. This is probably because the ASA database is not unicode.

1) How can I see which character page is used?
2) If I would like that the text is stored correctly what should i change?
3) Can we still use the current translations if we change the database?

More information about translating to unicode is welcome.

Thanks
Eric


Nick Elson Posted on 2004-12-23 21:44:20.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <41cae8ab@forums-1-dub>
Subject: Re: application
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: vpn-concord-099.sybase.com
Message-ID: <41cb3c2e@forums-2-dub>
X-Original-Trace: 23 Dec 2004 13:44:14 -0800, vpn-concord-099.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Dec 2004 13:44:17 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Dec 2004 13:44:20 -0800
X-Trace: forums-1-dub 1103838260 10.22.108.75 (23 Dec 2004 13:44:20 -0800)
X-Original-Trace: 23 Dec 2004 13:44:20 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4010
Article PK: 7906


> In our program is a translation utility. I copied a Russian text from the
> internet to the text field in PowerBuilder. Yes, it still is Russian.
>
> Now I store it in the database and then retrieve it. What I get back is
> ???????. This is probably because the ASA database is not Unicode.

Quite probably. Version 7 supports UTF8 (I believe that is circa
2000/2001)
and with the many languages you are suggesting, that may be your only
option.

> 1) How can I see which character page is used?

The dbinfo.exe utility will do that. You can also query it
directly this way

SELECT PROPERTY( 'DefaultCollation' )

> 2) If I would like that the text is stored correctly what should I change?

To change the character set used by a database you will need to
recreate. The character set is specified when you create the database.

See the dbinit.exe utility, for more information.

> 3) Can we still use the current translations if we change the database?

You will be rebuilding the database and inputting or loading the data
into an new database. I would resort to externalized data so that
translation can work for you (if that makes sense to your current usage).
To do that you will need to run dbunload -xx and start the old and
new databases with the -ct + switch. [do not use -an or -ar for this]

Of course, a lot of that depends upon how you currently work with the
engine's -ct switch now.


HTH



"Eric Verhorstert" <eric.verhorstert@farm.nl> wrote in message
news:41cae8ab@forums-1-dub...
> We have a powerbuilder application which is translated in 15 languages.
> The text is store in the database (ASA 7).
>
> Now we have converted the program from powerbuilder 6.5 to powerbuilder
> 10. Powerbuilder 10 is unicode.
>
> In our program is a translation utility. I copied a russian text from the
> internet to the text field in powerbuilder. Yes, it still is Russian.
>
> Now I store it in the database and then retrieve it. What I get back is
> ???????. This is probably because the ASA database is not unicode.
>
> 1) How can I see which character page is used?
> 2) If I would like that the text is stored correctly what should i change?
> 3) Can we still use the current translations if we change the database?
>
> More information about translating to unicode is welcome.
>
> Thanks
> Eric


Eric Verhorstert Posted on 2004-12-24 07:33:15.0Z
From: Eric Verhorstert <eric.verhorstert@farm.nl>
User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: application
References: <41cae8ab@forums-1-dub> <41cb3c2e@forums-2-dub>
In-Reply-To: <41cb3c2e@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: a80-127-106-91.adsl.xs4all.nl
Message-ID: <41cbc636$1@forums-2-dub>
X-Original-Trace: 23 Dec 2004 23:33:10 -0800, a80-127-106-91.adsl.xs4all.nl
Lines: 93
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Dec 2004 23:33:12 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Dec 2004 23:33:15 -0800
X-Trace: forums-1-dub 1103873595 10.22.108.75 (23 Dec 2004 23:33:15 -0800)
X-Original-Trace: 23 Dec 2004 23:33:15 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4011
Article PK: 7902

Nick,

Thanks for the answer.

I rebuild the database, exporting everything to files, creating a new
database with dbinit -zUTF8.
Now when I put chinees in and retrieve it. It stays chinese.

What a beautiful combination is Powerbuilder and Sybase. But I can not
believe it is that easy.

What are the disadvantages of using UTF8 in ASA7.

Thanks

Eric

Nick Elson wrote:
>>In our program is a translation utility. I copied a Russian text from the
>>internet to the text field in PowerBuilder. Yes, it still is Russian.
>>
>>Now I store it in the database and then retrieve it. What I get back is
>>???????. This is probably because the ASA database is not Unicode.
>
>
> Quite probably. Version 7 supports UTF8 (I believe that is circa
> 2000/2001)
> and with the many languages you are suggesting, that may be your only
> option.
>
>
>>1) How can I see which character page is used?
>
>
> The dbinfo.exe utility will do that. You can also query it
> directly this way
>
> SELECT PROPERTY( 'DefaultCollation' )
>
>
>>2) If I would like that the text is stored correctly what should I change?
>
>
> To change the character set used by a database you will need to
> recreate. The character set is specified when you create the database.
>
> See the dbinit.exe utility, for more information.
>
>
>>3) Can we still use the current translations if we change the database?
>
>
> You will be rebuilding the database and inputting or loading the data
> into an new database. I would resort to externalized data so that
> translation can work for you (if that makes sense to your current usage).
> To do that you will need to run dbunload -xx and start the old and
> new databases with the -ct + switch. [do not use -an or -ar for this]
>
> Of course, a lot of that depends upon how you currently work with the
> engine's -ct switch now.
>
>
> HTH
>
>
>
> "Eric Verhorstert" <eric.verhorstert@farm.nl> wrote in message
> news:41cae8ab@forums-1-dub...
>
>>We have a powerbuilder application which is translated in 15 languages.
>>The text is store in the database (ASA 7).
>>
>>Now we have converted the program from powerbuilder 6.5 to powerbuilder
>>10. Powerbuilder 10 is unicode.
>>
>>In our program is a translation utility. I copied a russian text from the
>>internet to the text field in powerbuilder. Yes, it still is Russian.
>>
>>Now I store it in the database and then retrieve it. What I get back is
>>???????. This is probably because the ASA database is not unicode.
>>
>>1) How can I see which character page is used?
>>2) If I would like that the text is stored correctly what should i change?
>>3) Can we still use the current translations if we change the database?
>>
>>More information about translating to unicode is welcome.
>>
>>Thanks
>>Eric
>
>
>


Nick Elson Posted on 2004-12-24 15:23:48.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <41cae8ab@forums-1-dub> <41cb3c2e@forums-2-dub> <41cbc636$1@forums-2-dub>
Subject: Re: application
Lines: 109
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <41cc347f$1@forums-2-dub>
X-Original-Trace: 24 Dec 2004 07:23:43 -0800, nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Dec 2004 07:23:45 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Dec 2004 07:23:48 -0800
X-Trace: forums-1-dub 1103901828 10.22.108.75 (24 Dec 2004 07:23:48 -0800)
X-Original-Trace: 24 Dec 2004 07:23:48 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4013
Article PK: 7905

Other than

- the age of the support (some new UCS-2 characters may not
be fully supported, yet; if there are any that concern you)
and
- the loss of some sorting capabilities (I believe in ASA 7 UTF8
was limited to a strictly binary sort/compare on/of the first byte
of the UTF8 char where ordering may matter)

I am not aware of any other limitations.

"Eric Verhorstert" <eric.verhorstert@farm.nl> wrote in message
news:41cbc636$1@forums-2-dub...
> Nick,
>
> Thanks for the answer.
>
> I rebuild the database, exporting everything to files, creating a new
> database with dbinit -zUTF8.
> Now when I put chinees in and retrieve it. It stays chinese.
>
> What a beautiful combination is Powerbuilder and Sybase. But I can not
> believe it is that easy.
>
> What are the disadvantages of using UTF8 in ASA7.
>
> Thanks
>
> Eric
>
>
> Nick Elson wrote:
>>>In our program is a translation utility. I copied a Russian text from the
>>>internet to the text field in PowerBuilder. Yes, it still is Russian.
>>>
>>>Now I store it in the database and then retrieve it. What I get back is
>>>???????. This is probably because the ASA database is not Unicode.
>>
>>
>> Quite probably. Version 7 supports UTF8 (I believe that is circa
>> 2000/2001)
>> and with the many languages you are suggesting, that may be your only
>> option.
>>
>>
>>>1) How can I see which character page is used?
>>
>>
>> The dbinfo.exe utility will do that. You can also query it
>> directly this way
>>
>> SELECT PROPERTY( 'DefaultCollation' )
>>
>>
>>>2) If I would like that the text is stored correctly what should I
>>>change?
>>
>>
>> To change the character set used by a database you will need to
>> recreate. The character set is specified when you create the database.
>>
>> See the dbinit.exe utility, for more information.
>>
>>
>>>3) Can we still use the current translations if we change the database?
>>
>>
>> You will be rebuilding the database and inputting or loading the data
>> into an new database. I would resort to externalized data so that
>> translation can work for you (if that makes sense to your current usage).
>> To do that you will need to run dbunload -xx and start the old and
>> new databases with the -ct + switch. [do not use -an or -ar for this]
>>
>> Of course, a lot of that depends upon how you currently work with the
>> engine's -ct switch now.
>>
>>
>> HTH
>>
>>
>>
>> "Eric Verhorstert" <eric.verhorstert@farm.nl> wrote in message
>> news:41cae8ab@forums-1-dub...
>>
>>>We have a powerbuilder application which is translated in 15 languages.
>>>The text is store in the database (ASA 7).
>>>
>>>Now we have converted the program from powerbuilder 6.5 to powerbuilder
>>>10. Powerbuilder 10 is unicode.
>>>
>>>In our program is a translation utility. I copied a russian text from the
>>>internet to the text field in powerbuilder. Yes, it still is Russian.
>>>
>>>Now I store it in the database and then retrieve it. What I get back is
>>>???????. This is probably because the ASA database is not unicode.
>>>
>>>1) How can I see which character page is used?
>>>2) If I would like that the text is stored correctly what should i
>>>change?
>>>3) Can we still use the current translations if we change the database?
>>>
>>>More information about translating to unicode is welcome.
>>>
>>>Thanks
>>>Eric
>>
>>