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.

char(31) in 32-bit vs. 64-bit

3 posts in General Discussion Last posting was on 2009-10-02 20:17:34.0Z
Charou Posted on 2009-10-02 13:01:38.0Z
Sender: 3ea.4ac5f8b2.1804289383@sybase.com
From: Charou
Newsgroups: sybase.public.ase.general
Subject: char(31) in 32-bit vs. 64-bit
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ac5f9b2.41e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Oct 2009 06:01:38 -0700
X-Trace: forums-1-dub 1254488498 10.22.241.41 (2 Oct 2009 06:01:38 -0700)
X-Original-Trace: 2 Oct 2009 06:01:38 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28396
Article PK: 77641

When I want to display a char(31), it is displayed as an
ascii 95 character in 64-bit environment, but as an ascii
172 character in a 32-bit environment. Can anyone explain
why or where I could look up the differences based on 32 vs.
64 bit.

Thanks,
Charou


Neal Stack [Sybase] Posted on 2009-10-02 19:17:43.0Z
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: char(31) in 32-bit vs. 64-bit
References: <4ac5f9b2.41e.1681692777@sybase.com>
In-Reply-To: <4ac5f9b2.41e.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: <4ac651d7@forums-1-dub>
Date: 2 Oct 2009 12:17:43 -0700
X-Trace: forums-1-dub 1254511063 10.22.241.152 (2 Oct 2009 12:17:43 -0700)
X-Original-Trace: 2 Oct 2009 12:17:43 -0700, vip152.sybase.com
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28399
Article PK: 77642

Hello,

I'm not sure I follow your question. Are you doing a "select char(31)" and getting different results?
Or you have a character column defined to be 31 characters and length and you are seeing different lengths?

What is the character set in each server (check with "sp_helpsort")?

What is the client character set (check with "select @@client_csname")?

Regards,
Neal


Charou Posted on 2009-10-02 20:17:34.0Z
Sender: 1556.4ac65f6e.1804289383@sybase.com
From: Charou
Newsgroups: sybase.public.ase.general
Subject: Re: char(31) in 32-bit vs. 64-bit
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ac65fde.1570.1681692777@sybase.com>
References: <4ac651d7@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Oct 2009 13:17:34 -0700
X-Trace: forums-1-dub 1254514654 10.22.241.41 (2 Oct 2009 13:17:34 -0700)
X-Original-Trace: 2 Oct 2009 13:17:34 -0700, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28400
Article PK: 77643

Please disregard my question. The information I was given
was incorrect. Sorry.

Charou

> Hello,
>
> I'm not sure I follow your question. Are you doing a
> "select char(31)" and getting different results? Or you
> have a character column defined to be 31 characters and
> length and you are seeing different lengths?
>
> What is the character set in each server (check with
> "sp_helpsort")?
>
> What is the client character set (check with "select
> @@client_csname")?
>
> Regards,
> Neal