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.

cp1252 charset in ASE 15.0.3 Solaris

6 posts in General Discussion Last posting was on 2010-05-20 15:16:48.0Z
liyp Posted on 2010-05-17 20:08:03.0Z
From: "liyp" <li_yuping@bls.gov>
Newsgroups: sybase.public.ase.general
Subject: cp1252 charset in ASE 15.0.3 Solaris
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
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: <4bf1a223$1@forums-1-dub>
Date: 17 May 2010 13:08:03 -0700
X-Trace: forums-1-dub 1274126883 10.22.241.152 (17 May 2010 13:08:03 -0700)
X-Original-Trace: 17 May 2010 13:08:03 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29222
Article PK: 78457

What's the equivalent of cp1252 charset in ASE 15.0.3 Solaris?

Thanks,
liyp


ET Posted on 2010-05-17 21:09:50.0Z
Message-ID: <4BF1B09B.1020308@gmail.com>
From: ET <dbccjob@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: liyp <li_yuping@bls.gov>
Subject: Re: cp1252 charset in ASE 15.0.3 Solaris
References: <4bf1a223$1@forums-1-dub>
In-Reply-To: <4bf1a223$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 17 May 2010 14:09:50 -0700
X-Trace: forums-1-dub 1274130590 10.22.241.152 (17 May 2010 14:09:50 -0700)
X-Original-Trace: 17 May 2010 14:09:50 -0700, vip152.sybase.com
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29223
Article PK: 78456

Le 17/05/2010 22:08, liyp a écrit :

> What's the equivalent of cp1252 charset in ASE 15.0.3 Solaris?
>
> Thanks,
> liyp
>
>

The equivalent would be iso_1 but what do you need to do exactly ?

Emmanuel


liyp Posted on 2010-05-18 15:38:34.0Z
From: "liyp" <li_yuping@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4bf1a223$1@forums-1-dub> <4BF1B09B.1020308@gmail.com>
Subject: Re: cp1252 charset in ASE 15.0.3 Solaris
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
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: <4bf2b47a$1@forums-1-dub>
Date: 18 May 2010 08:38:34 -0700
X-Trace: forums-1-dub 1274197114 10.22.241.152 (18 May 2010 08:38:34 -0700)
X-Original-Trace: 18 May 2010 08:38:34 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29224
Article PK: 78458

We have issues with en-dash, em-dash and right single quote which couldn't
be converted correctly during synchronization between ASE and ASA. Sybase
technical support suggested us to use different charset in ASE which is
equivaltent to cp 1252. Below is the information from sybase support,

iso_1 is a proper subset of CP1252 and the problematic
characters are not defined members of iso_1.


Thanks,
liyp

"ET" <dbccjob@gmail.com> wrote in message news:4BF1B09B.1020308@gmail.com...
> Le 17/05/2010 22:08, liyp a écrit :
>> What's the equivalent of cp1252 charset in ASE 15.0.3 Solaris?
>>
>> Thanks,
>> liyp
>>
>>
> The equivalent would be iso_1 but what do you need to do exactly ?
>
> Emmanuel


J Posted on 2010-05-19 23:12:41.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: cp1252 charset in ASE 15.0.3 Solaris
Reply-To: J@bogusemailAddress.com
Message-ID: <4bf4700b.29529343@forums.sybase.com>
References: <4bf1a223$1@forums-1-dub> <4BF1B09B.1020308@gmail.com> <4bf2b47a$1@forums-1-dub>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 19 May 2010 16:12:41 -0700
X-Trace: forums-1-dub 1274310761 10.22.241.152 (19 May 2010 16:12:41 -0700)
X-Original-Trace: 19 May 2010 16:12:41 -0700, vip152.sybase.com
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29233
Article PK: 78467

On 18 May 2010 08:38:34 -0700, "liyp" <li_yuping@bls.gov> wrote:

When I did a "select convert(char(1), 0x8212) it shows up as a
"dash":

isql -Usa -P -Sdtm -Jiso_1
1> select convert(char(1), 0x8212)
2> go

-


(1 row affected)

Jay

>We have issues with en-dash, em-dash and right single quote which couldn't
>be converted correctly during synchronization between ASE and ASA. Sybase
>technical support suggested us to use different charset in ASE which is
>equivaltent to cp 1252. Below is the information from sybase support,
>
>iso_1 is a proper subset of CP1252 and the problematic
>characters are not defined members of iso_1.
>
>
>Thanks,
>liyp
>
>"ET" <dbccjob@gmail.com> wrote in message news:4BF1B09B.1020308@gmail.com...
>> Le 17/05/2010 22:08, liyp a écrit :
>>> What's the equivalent of cp1252 charset in ASE 15.0.3 Solaris?
>>>
>>> Thanks,
>>> liyp
>>>
>>>
>> The equivalent would be iso_1 but what do you need to do exactly ?
>>
>> Emmanuel
>
>


Sherlock, Kevin [TeamSybase] Posted on 2010-05-20 14:42:31.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4bf1a223$1@forums-1-dub> <4BF1B09B.1020308@gmail.com> <4bf2b47a$1@forums-1-dub> <4bf4700b.29529343@forums.sybase.com>
Subject: Re: cp1252 charset in ASE 15.0.3 Solaris
Lines: 56
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: <4bf54a57$1@forums-1-dub>
Date: 20 May 2010 07:42:31 -0700
X-Trace: forums-1-dub 1274366551 10.22.241.152 (20 May 2010 07:42:31 -0700)
X-Original-Trace: 20 May 2010 07:42:31 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29235
Article PK: 78472

And I'll bet

select convert(char(1),0x8212) as "xx"

results in two dashes? :)

The dash is your one-character column heading coming from isql. The actual
result is the unprintable data underneath the heading.

"J" <jtotally_bogus@sbcglobal.net> wrote in message
news:4bf4700b.29529343@forums.sybase.com...
> On 18 May 2010 08:38:34 -0700, "liyp" <li_yuping@bls.gov> wrote:
>
> When I did a "select convert(char(1), 0x8212) it shows up as a
> "dash":
>
> isql -Usa -P -Sdtm -Jiso_1
> 1> select convert(char(1), 0x8212)
> 2> go
>
> -
>
>
> (1 row affected)
>
> Jay
>
>>We have issues with en-dash, em-dash and right single quote which couldn't
>>be converted correctly during synchronization between ASE and ASA. Sybase
>>technical support suggested us to use different charset in ASE which is
>>equivaltent to cp 1252. Below is the information from sybase support,
>>
>>iso_1 is a proper subset of CP1252 and the problematic
>>characters are not defined members of iso_1.
>>
>>
>>Thanks,
>>liyp
>>
>>"ET" <dbccjob@gmail.com> wrote in message
>>news:4BF1B09B.1020308@gmail.com...
>>> Le 17/05/2010 22:08, liyp a écrit :
>>>> What's the equivalent of cp1252 charset in ASE 15.0.3 Solaris?
>>>>
>>>> Thanks,
>>>> liyp
>>>>
>>>>
>>> The equivalent would be iso_1 but what do you need to do exactly ?
>>>
>>> Emmanuel
>>
>>
>


J Posted on 2010-05-20 15:16:48.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: cp1252 charset in ASE 15.0.3 Solaris
Reply-To: J@bogusemailAddress.com
Message-ID: <4bf5523c.87434203@forums.sybase.com>
References: <4bf1a223$1@forums-1-dub> <4BF1B09B.1020308@gmail.com> <4bf2b47a$1@forums-1-dub> <4bf4700b.29529343@forums.sybase.com> <4bf54a57$1@forums-1-dub>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 20 May 2010 08:16:48 -0700
X-Trace: forums-1-dub 1274368608 10.22.241.152 (20 May 2010 08:16:48 -0700)
X-Original-Trace: 20 May 2010 08:16:48 -0700, vip152.sybase.com
Lines: 65
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29236
Article PK: 78468

On 20 May 2010 07:42:31 -0700, "Sherlock, Kevin [TeamSybase]"
<kevin.sherlock@teamsybase.com> wrote:

Oh boy (egg on face), was I unlucky and wrong. I should have picked
the other character.

Jay

>And I'll bet
>
>select convert(char(1),0x8212) as "xx"
>
>results in two dashes? :)
>
>The dash is your one-character column heading coming from isql. The actual
>result is the unprintable data underneath the heading.
>
>"J" <jtotally_bogus@sbcglobal.net> wrote in message
>news:4bf4700b.29529343@forums.sybase.com...
>> On 18 May 2010 08:38:34 -0700, "liyp" <li_yuping@bls.gov> wrote:
>>
>> When I did a "select convert(char(1), 0x8212) it shows up as a
>> "dash":
>>
>> isql -Usa -P -Sdtm -Jiso_1
>> 1> select convert(char(1), 0x8212)
>> 2> go
>>
>> -
>>
>>
>> (1 row affected)
>>
>> Jay
>>
>>>We have issues with en-dash, em-dash and right single quote which couldn't
>>>be converted correctly during synchronization between ASE and ASA. Sybase
>>>technical support suggested us to use different charset in ASE which is
>>>equivaltent to cp 1252. Below is the information from sybase support,
>>>
>>>iso_1 is a proper subset of CP1252 and the problematic
>>>characters are not defined members of iso_1.
>>>
>>>
>>>Thanks,
>>>liyp
>>>
>>>"ET" <dbccjob@gmail.com> wrote in message
>>>news:4BF1B09B.1020308@gmail.com...
>>>> Le 17/05/2010 22:08, liyp a écrit :
>>>>> What's the equivalent of cp1252 charset in ASE 15.0.3 Solaris?
>>>>>
>>>>> Thanks,
>>>>> liyp
>>>>>
>>>>>
>>>> The equivalent would be iso_1 but what do you need to do exactly ?
>>>>
>>>> Emmanuel
>>>
>>>
>>
>
>