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 (Windows), ISO_1, and Unicode conversions in ASE12

3 posts in Windows NT Last posting was on 2001-05-11 00:27:52.0Z
Milton Taylor Posted on 2001-05-01 05:10:14.0Z
Message-ID: <3AEE4535.644C0FB1@ingennia.com.au>
Date: Tue, 01 May 2001 15:10:14 +1000
From: Milton Taylor <mctaylor@ingennia.com.au>
Organization: Ingennia Systems Pty Ltd
X-Mailer: Mozilla 4.05 [en]C-CONNECTNET (Win95; I)
MIME-Version: 1.0
Subject: CP1252 (Windows), ISO_1, and Unicode conversions in ASE12
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 35
NNTP-Posting-Host: FLPP-p-144-134-16-106.prem.tmns.net.au 144.134.16.106
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:852
Article PK: 1087459

I've come across something that is puzzling me about ASE's default
configuration on Windows NT.

It seems that ASE's default config on Windows NT is to assume that
Windows, US English uses ISO_1.
(Check the locales.dat file).

It seems to me that this is not quite correct, and results in a few
minor character code conversion problems.

CP1252 is Window's native character set. This is almost identical to
ISO_1, except for about the first 32 characters
in the extended part of the code page. For example, the euro symbol is
in position 128 in the code page.

Now, my test ASE database is configured for UTF8 as default character
set.

By default, if I connect through ODBC to ASE (Say using MS Access 97),
and enter a euro symbol using Alt 0128
and the save this to the database, it does not get converted into the
correct UTF8 representation for euro symbol.

Conversely, if a euro symbol is in the database, it displays as "?",
meaning that the character set converter could
not convert it back again.

Now, if I set the character set to cp1252 in the ODBC connection
properties, it works fine. (I had to install cp1252
into the database though...).

So, the question I have is, how do you configure the ASE client to
default to cp1252 and not iso_1?
I presume this is an open client issue?

Thanks,
Milton Taylor


Mark Leidner Posted on 2001-05-10 13:29:18.0Z
Message-ID: <3AFA97AE.A4B608E5@cremer-gruppe.com>
Date: Thu, 10 May 2001 15:29:18 +0200
From: Mark Leidner <edventw@cremer-gruppe.com>
X-Mailer: Mozilla 4.73 [de]C-CCK-MCD QXW03240 (Windows NT 5.0; U)
X-Accept-Language: de,en
MIME-Version: 1.0
Subject: Re: CP1252 (Windows), ISO_1, and Unicode conversions in ASE12
References: <3AEE4535.644C0FB1@ingennia.com.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 50
NNTP-Posting-Host: 195.222.233.1
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:760
Article PK: 1087366

You're right. If you connect via an application you can use the connection
parameter CharSet='1252'. SQL-Advantage can get the commandline parameter
-Jcp1252, so it knows that the client is definitely a cp1252. If you can't
see the Eurosymbol change the Charset (in SQL-Advantage) to Courier New
(!!!).
Be aware of the limitations on using uft8, look at:
http://my.sybase.com/detail?id=1009196
Check the server parameter: 'enable unicode conversions'
I hope that helped a little bit.
Best regards

Mark


Milton Taylor schrieb:

> I've come across something that is puzzling me about ASE's default
> configuration on Windows NT.
>
> It seems that ASE's default config on Windows NT is to assume that
> Windows, US English uses ISO_1.
> (Check the locales.dat file).
>
> It seems to me that this is not quite correct, and results in a few
> minor character code conversion problems.
>
> CP1252 is Window's native character set. This is almost identical to
> ISO_1, except for about the first 32 characters
> in the extended part of the code page. For example, the euro symbol is
> in position 128 in the code page.
>
> Now, my test ASE database is configured for UTF8 as default character
> set.
>
> By default, if I connect through ODBC to ASE (Say using MS Access 97),
> and enter a euro symbol using Alt 0128
> and the save this to the database, it does not get converted into the
> correct UTF8 representation for euro symbol.
>
> Conversely, if a euro symbol is in the database, it displays as "?",
> meaning that the character set converter could
> not convert it back again.
>
> Now, if I set the character set to cp1252 in the ODBC connection
> properties, it works fine. (I had to install cp1252
> into the database though...).
>
> So, the question I have is, how do you configure the ASE client to
> default to cp1252 and not iso_1?
> I presume this is an open client issue?
>
> Thanks,
> Milton Taylor


Milton Taylor Posted on 2001-05-11 00:27:52.0Z
Message-ID: <3AFB3208.4F5DBB33@ingennia.com.au>
Date: Fri, 11 May 2001 10:27:52 +1000
From: Milton Taylor <mctaylor@ingennia.com.au>
Organization: Ingennia Systems Pty Ltd
X-Mailer: Mozilla 4.76 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: CP1252 (Windows), ISO_1, and Unicode conversions in ASE12
References: <3AEE4535.644C0FB1@ingennia.com.au> <3AFA97AE.A4B608E5@cremer-gruppe.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 58
NNTP-Posting-Host: ppp173.adsl137.pacific.net.au 210.23.137.173
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:754
Article PK: 1087361

I was just wondering which component on the client end was making it
default to iso_1 instead of cp1252.

Otherwise, it's working fine and I understand the limit issues.

Thanks,
Milton

Mark Leidner wrote:

> You're right. If you connect via an application you can use the connection
> parameter CharSet='1252'. SQL-Advantage can get the commandline parameter
> -Jcp1252, so it knows that the client is definitely a cp1252. If you can't
> see the Eurosymbol change the Charset (in SQL-Advantage) to Courier New
> (!!!).
> Be aware of the limitations on using uft8, look at:
> http://my.sybase.com/detail?id=1009196
> Check the server parameter: 'enable unicode conversions'
> I hope that helped a little bit.
> Best regards
>
> Mark
>
> Milton Taylor schrieb:
>
> > I've come across something that is puzzling me about ASE's default
> > configuration on Windows NT.
> >
> > It seems that ASE's default config on Windows NT is to assume that
> > Windows, US English uses ISO_1.
> > (Check the locales.dat file).
> >
> > It seems to me that this is not quite correct, and results in a few
> > minor character code conversion problems.
> >
> > CP1252 is Window's native character set. This is almost identical to
> > ISO_1, except for about the first 32 characters
> > in the extended part of the code page. For example, the euro symbol is
> > in position 128 in the code page.
> >
> > Now, my test ASE database is configured for UTF8 as default character
> > set.
> >
> > By default, if I connect through ODBC to ASE (Say using MS Access 97),
> > and enter a euro symbol using Alt 0128
> > and the save this to the database, it does not get converted into the
> > correct UTF8 representation for euro symbol.
> >
> > Conversely, if a euro symbol is in the database, it displays as "?",
> > meaning that the character set converter could
> > not convert it back again.
> >
> > Now, if I set the character set to cp1252 in the ODBC connection
> > properties, it works fine. (I had to install cp1252
> > into the database though...).
> >
> > So, the question I have is, how do you configure the ASE client to
> > default to cp1252 and not iso_1?
> > I presume this is an open client issue?
> >
> > Thanks,
> > Milton Taylor