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.

JDBC Charset cp850 problem

14 posts in General Discussion Last posting was on 2006-09-28 06:49:27.0Z
Pieter Coene Posted on 2006-09-06 10:59:57.0Z
Sender: 6ca4.44fea881.1804289383@sybase.com
From: Pieter Coene
Newsgroups: sybase.public.workspace.general
Subject: JDBC Charset cp850 problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44feaa2d.6cc9.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Sep 2006 03:59:57 -0700
X-Trace: forums-1-dub 1157540397 10.22.241.41 (6 Sep 2006 03:59:57 -0700)
X-Original-Trace: 6 Sep 2006 03:59:57 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:171
Article PK: 1087818

Hi,

i'm using Workspace 1.5 (with ASE 12.5.3 ESD 7).

In my connection profile i added in 'Other Properties' the
following: CHARSET=cp850. I get no error when connecting.
When i retrieve some data from my db, chars aren't showing
like they should. For example: 'é' is shown as 'Ú'.

Am I setting the property wrong here? What should i do?

Pieter


courtney.blatherwick Posted on 2006-09-11 13:42:54.0Z
From: courtney.blatherwick@sybase.com
Subject: Re: JDBC Charset cp850 problem
Newsgroups: sybase.public.workspace.general
MIME-Version: 1.0
References: <44feaa2d.6cc9.1681692777@sybase.com>
X-Newsreader: Lotus Notes Release 6.5 September 26, 2003
X-MIMETrack: Serialize by Notes Client on Courtney Blatherwick/SYBASE(Release 6.5|September 26, 2003) at 09/11/2006 07:42:32 AM, Serialize complete at 09/11/2006 07:42:32 AM
Content-Type: multipart/alternative; boundary="=_alternative 004B4E32872571E6_="
X-Original-NNTP-Posting-Host: cblatherxp1.sybase.com
Message-ID: <450567c8$1@forums-2-dub>
X-Original-Trace: 11 Sep 2006 06:42:32 -0700, cblatherxp1.sybase.com
Lines: 29
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Sep 2006 06:42:33 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Sep 2006 06:42:54 -0700
X-Trace: forums-1-dub 1157982174 10.22.108.75 (11 Sep 2006 06:42:54 -0700)
X-Original-Trace: 11 Sep 2006 06:42:54 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:178
Article PK: 1087814


Jeff Tallman suggests:

Have them check the default char set for the server...it might be cp432 (the
old default for NT) - in which case the character isn't mappable directly to
cp850.

jeff.tallman@sybase.com


Hung Hsi Posted on 2006-09-13 00:17:06.0Z
From: "Hung Hsi" <hhsi@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <450567c8$1@forums-2-dub> <45065560.668a.1681692777@sybase.com>
Subject: Re: JDBC Charset cp850 problem
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
X-Original-NNTP-Posting-Host: hhsixp.sybase.com
Message-ID: <45074de5$1@forums-2-dub>
X-Original-Trace: 12 Sep 2006 17:16:37 -0700, hhsixp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Sep 2006 17:16:38 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Sep 2006 17:17:06 -0700
X-Trace: forums-1-dub 1158106626 10.22.108.75 (12 Sep 2006 17:17:06 -0700)
X-Original-Trace: 12 Sep 2006 17:17:06 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:183
Article PK: 1087826

Pieter,

My team failed to reproduce the problem here. Is it possible to provide a
detailed test case or even a test script for use to run to reproduce the
problem?

Thanks and regards,
Hung

<Pieter Coene> wrote in message news:45065560.668a.1681692777@sybase.com...
> Hi Jeff,
>
> our server language options are this:
>
> Language: English
> Char Set: cp850
> Sort Order: noaccent
>
> We connect with different tools (Powerbuilder, SQL
> Advantage, Sybase Central, ...) and never had problems with
> cp850.
>
> We tested Sybase Workspace and we like the product. But this
> is crucial for us...
>
> Can you help me?
>
> Pieter
>
>
> > Jeff Tallman suggests:
> >
> > Have them check the default char set for the server...it
> > might be cp432 (the
> > old default for NT) - in which case the character isn't
> > mappable directly to
> > cp850.
> >
> > jeff.tallman@sybase.com
> >


Hung Hsi Posted on 2006-09-13 17:59:21.0Z
From: "Hung Hsi" <hhsi@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <45074de5$1@forums-2-dub> <4507d0da.12af.1681692777@sybase.com>
Subject: Re: JDBC Charset cp850 problem
Lines: 82
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
X-Original-NNTP-Posting-Host: hhsixp.sybase.com
Message-ID: <450846d6$1@forums-2-dub>
X-Original-Trace: 13 Sep 2006 10:58:46 -0700, hhsixp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Sep 2006 10:58:47 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Sep 2006 10:59:21 -0700
X-Trace: forums-1-dub 1158170361 10.22.108.75 (13 Sep 2006 10:59:21 -0700)
X-Original-Trace: 13 Sep 2006 10:59:21 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:192
Article PK: 1087832

Pieter,

Thanks for the info., we'll try to reproduce it again.

Regards,
Hung

<Pieter Coene> wrote in message news:4507d0da.12af.1681692777@sybase.com...
Hi,

i don't know how to make a test case, cause it's something
that always occurs... If I select a column in our db in WS
1.5, the 'special' chars aren't displaying correct.

example: we have a table 'contacten'. If I do:

"select con_naam from contacten", i get for the 'é' this:
'Ú'.
example: 'Ann Pierlé' would display 'Ann PierlÚ'

What i can give you are our specs.

- ASE 12.5.3 EBF 13331 ESD#7 (running on Win2003 Server)
Language: English
Char Set: cp850
Sort Order: noaccent
- Workspace 1.5 (Build id: 2006051914)
- "CHARSET=cp850" as property of my db-connection

when i export my result in Worspace, i can choose a output
encoding. There i can choose cp850. When i save it to a
file, the display is correct (é is shown)

Greetz,
Pieter

ps: i hope i didn't post this multiple times, cause
sometimes my posts aren't coming through...

> Pieter,
>
> My team failed to reproduce the problem here. Is it
> possible to provide a detailed test case or even a test
> script for use to run to reproduce the problem?
>
> Thanks and regards,
> Hung
> <Pieter Coene> wrote in message
> > news:45065560.668a.1681692777@sybase.com... Hi Jeff,
> >
> > our server language options are this:
> >
> > Language: English
> > Char Set: cp850
> > Sort Order: noaccent
> >
> > We connect with different tools (Powerbuilder, SQL
> > Advantage, Sybase Central, ...) and never had problems
> > with cp850.
> >
> > We tested Sybase Workspace and we like the product. But
> > this is crucial for us...
> >
> > Can you help me?
> >
> > Pieter
> >
> >
> > > Jeff Tallman suggests:
> > >
> > > Have them check the default char set for the
> > > server...it might be cp432 (the
> > > old default for NT) - in which case the character
> > > isn't mappable directly to
> > > cp850.
> > >
> > > jeff.tallman@sybase.com
> > >
>
>


shobha srinivasa Posted on 2006-09-20 19:16:11.0Z
Sender: 863.45118ec2.1804289383@sybase.com
From: shobha srinivasa
Newsgroups: sybase.public.workspace.general
Subject: Re: JDBC Charset cp850 problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4511937b.88d.1681692777@sybase.com>
References: <450846d6$1@forums-2-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Sep 2006 12:16:11 -0700
X-Trace: forums-1-dub 1158779771 10.22.241.41 (20 Sep 2006 12:16:11 -0700)
X-Original-Trace: 20 Sep 2006 12:16:11 -0700, 10.22.241.41
Lines: 126
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:205
Article PK: 1087870

HI Pieter,

I tried the same scenario but am not able to re-produce the
problem. I think the problem could be the sort order id for
CP850 should be 44 not 54.

Please do

>sp_configure Languages
>go

Here is how mine looks. Please make sure this is how yours
is configures


1> sp_configure Languages
2> go

Group: Languages

Parameter Name Default Memory Used
Config value
Run Value Unit Type
------------------------------ ----------- -----------
------------
------------ -------------------- ----------
default character set id 2 0
2
2 id static
default language id 0 0
0
0 id dynamic
default sortorder id 50 0
44
44 id static
disable character set conversi 0 0
0
0 switch static
enable unicode conversions 1 0
1
1 switch dynamic

Thanks a lot. Please let us know what you find.
Shobha Srinivasa
> Pieter,
>
> Thanks for the info., we'll try to reproduce it again.
>
> Regards,
> Hung
>
> <Pieter Coene> wrote in message
> news:4507d0da.12af.1681692777@sybase.com... Hi,
>
> i don't know how to make a test case, cause it's something
> that always occurs... If I select a column in our db in WS
> 1.5, the 'special' chars aren't displaying correct.
>
> example: we have a table 'contacten'. If I do:
>
> "select con_naam from contacten", i get for the 'é'
this:
> 'Ú'.
> example: 'Ann Pierlé' would display 'Ann PierlÚ'
>
> What i can give you are our specs.
>
> - ASE 12.5.3 EBF 13331 ESD#7 (running on Win2003 Server)
> Language: English
> Char Set: cp850
> Sort Order: noaccent
> - Workspace 1.5 (Build id: 2006051914)
> - "CHARSET=cp850" as property of my db-connection
>
> when i export my result in Worspace, i can choose a output
> encoding. There i can choose cp850. When i save it to a
> file, the display is correct (é is shown)
>
> Greetz,
> Pieter
>
> ps: i hope i didn't post this multiple times, cause
> sometimes my posts aren't coming through...
>
> > Pieter,
> >
> > My team failed to reproduce the problem here. Is it
> > possible to provide a detailed test case or even a test
> > script for use to run to reproduce the problem?
> >
> > Thanks and regards,
> > Hung
> > <Pieter Coene> wrote in message
> > > news:45065560.668a.1681692777@sybase.com... Hi Jeff,
> > >
> > > our server language options are this:
> > >
> > > Language: English
> > > Char Set: cp850
> > > Sort Order: noaccent
> > >
> > > We connect with different tools (Powerbuilder, SQL
> > > Advantage, Sybase Central, ...) and never had problems
> > > with cp850.
> > >
> > > We tested Sybase Workspace and we like the product.
> > > But this is crucial for us...
> > >
> > > Can you help me?
> > >
> > > Pieter
> > >
> > >
> > > > Jeff Tallman suggests:
> > > >
> > > > Have them check the default char set for the
> > > > server...it might be cp432 (the
> > > > old default for NT) - in which case the character
> > > > isn't mappable directly to
> > > > cp850.
> > > >
> > > > jeff.tallman@sybase.com
> > > >
> >
> >
>
>


Mike Crocker Posted on 2006-09-26 18:38:05.0Z
From: "Mike Crocker" <crocker@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <4511937b.88d.1681692777@sybase.com> <451237fc.1630.1681692777@sybase.com>
Subject: Re: JDBC Charset cp850 problem
Lines: 178
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: crockerxp.sybase.com
Message-ID: <4519731b$2@forums-2-dub>
X-Original-Trace: 26 Sep 2006 11:36:11 -0700, crockerxp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Sep 2006 11:36:12 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Sep 2006 11:38:05 -0700
X-Trace: forums-1-dub 1159295885 10.22.108.75 (26 Sep 2006 11:38:05 -0700)
X-Original-Trace: 26 Sep 2006 11:38:05 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:210
Article PK: 1087875

Pieter,

We are still dedicated to reproducing and solving this issue. Would it be
possible for us to contact you in a conference call?

Please email me at crocker@sybase.com.

thank you,
mike


<Pieter Coene> wrote in message news:451237fc.1630.1681692777@sybase.com...
Hi,

Here my settings:

Parameter Name Default Memory Used
Config Value Run Value Unit Type
-------------- ------- -----------
------------ --------- ---- ----
default character set id 2 0
2 2 id static
default language id 0 0
0 0 id dynamic
default sortorder id 50 0
44 44 id static
disable character set conversi 0 0
0 0 switch static
enable unicode conversions 0 0
0 0 switch dynamic

The only difference is that 'enable unicode conversions' is
default '0'. I changed the run value to '1' and reconnected
with WS, but it didn't help. Now my settings are exactly the
same as you described...

We are located in Belgium, is it possible that 'regional and
language settings' could influence this? Our current
settings for Language is: 'Dutch (Belgium)' (and Code Page
Conversion table 850 is selected)

Greetz
Pieter

> HI Pieter,
>
> I tried the same scenario but am not able to re-produce
> the problem. I think the problem could be the sort order
> id for CP850 should be 44 not 54.
>
> Please do
> >sp_configure Languages
> >go
>
> Here is how mine looks. Please make sure this is how yours
> is configures
>
>
> 1> sp_configure Languages
> 2> go
>
> Group: Languages
>
> Parameter Name Default Memory Used
> Config value
> Run Value Unit Type
> ------------------------------ ----------- -----------
> ------------
> ------------ -------------------- ----------
> default character set id 2 0
>
> 2
> 2 id static
> default language id 0 0
>
> 0
> 0 id dynamic
> default sortorder id 50 0
>
> 44
> 44 id static
> disable character set conversi 0 0
>
> 0
> 0 switch static
> enable unicode conversions 1 0
>
> 1
> 1 switch dynamic
>
> Thanks a lot. Please let us know what you find.
> Shobha Srinivasa
> > Pieter,
> >
> > Thanks for the info., we'll try to reproduce it again.
> >
> > Regards,
> > Hung
> >
> > <Pieter Coene> wrote in message
> > news:4507d0da.12af.1681692777@sybase.com... Hi,
> >
> > i don't know how to make a test case, cause it's
> > something that always occurs... If I select a column in
> > our db in WS 1.5, the 'special' chars aren't displaying
> correct. >
> > example: we have a table 'contacten'. If I do:
> >
> > "select con_naam from contacten", i get for the 'é'
> this:
> > 'Ú'.
> > example: 'Ann Pierlé' would display 'Ann PierlÚ'
> >
> > What i can give you are our specs.
> >
> > - ASE 12.5.3 EBF 13331 ESD#7 (running on Win2003 Server)
> > Language: English
> > Char Set: cp850
> > Sort Order: noaccent
> > - Workspace 1.5 (Build id: 2006051914)
> > - "CHARSET=cp850" as property of my db-connection
> >
> > when i export my result in Worspace, i can choose a
> > output encoding. There i can choose cp850. When i save
> > it to a file, the display is correct (é is shown)
> >
> > Greetz,
> > Pieter
> >
> > ps: i hope i didn't post this multiple times, cause
> > sometimes my posts aren't coming through...
> >
> > > Pieter,
> > >
> > > My team failed to reproduce the problem here. Is it
> > > possible to provide a detailed test case or even a
> > > test script for use to run to reproduce the problem?
> > >
> > > Thanks and regards,
> > > Hung
> > > <Pieter Coene> wrote in message
> > > > news:45065560.668a.1681692777@sybase.com... Hi Jeff,
> > > >
> > > > our server language options are this:
> > > >
> > > > Language: English
> > > > Char Set: cp850
> > > > Sort Order: noaccent
> > > >
> > > > We connect with different tools (Powerbuilder, SQL
> > > > Advantage, Sybase Central, ...) and never had
> > > > problems with cp850.
> > > >
> > > > We tested Sybase Workspace and we like the product.
> > > > But this is crucial for us...
> > > >
> > > > Can you help me?
> > > >
> > > > Pieter
> > > >
> > > >
> > > > > Jeff Tallman suggests:
> > > > >
> > > > > Have them check the default char set for the
> > > > > server...it might be cp432 (the
> > > > > old default for NT) - in which case the character
> > > > > isn't mappable directly to
> > > > > cp850.
> > > > >
> > > > > jeff.tallman@sybase.com
> > > > >
> > >
> > >
> >
> >


courtney.blatherwick Posted on 2006-09-11 13:41:58.0Z
From: courtney.blatherwick@sybase.com
Subject: Re: JDBC Charset cp850 problem
Newsgroups: sybase.public.workspace.general
MIME-Version: 1.0
References: <44feaa2d.6cc9.1681692777@sybase.com>
X-Newsreader: Lotus Notes Release 6.5 September 26, 2003
X-MIMETrack: Serialize by Notes Client on Courtney Blatherwick/SYBASE(Release 6.5|September 26, 2003) at 09/11/2006 07:38:25 AM, Serialize complete at 09/11/2006 07:38:25 AM
Content-Type: multipart/alternative; boundary="=_alternative 004AEDBC872571E6_="
X-Original-NNTP-Posting-Host: cblatherxp1.sybase.com
Message-ID: <45056791$1@forums-2-dub>
X-Original-Trace: 11 Sep 2006 06:41:37 -0700, cblatherxp1.sybase.com
Lines: 29
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Sep 2006 06:41:38 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Sep 2006 06:41:58 -0700
X-Trace: forums-1-dub 1157982118 10.22.108.75 (11 Sep 2006 06:41:58 -0700)
X-Original-Trace: 11 Sep 2006 06:41:58 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:177
Article PK: 1087815


Jeff Tallman suggests:

Have them check the default char set for the server...it might be cp432 (the
old default for NT) - in which case the character isn't mappable directly to
cp850.

jeff.tallman@sybase.com