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.

strange characters appeared

2 posts in Windows NT Last posting was on 2000-11-14 09:33:54.0Z
v_cuccino Posted on 2000-11-08 14:57:01.0Z
From: v_cuccino@intercap.com.br
Date: Wed, 8 Nov 2000 09:57:01 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: strange characters appeared
Message-ID: <1FED60ACE976ECEE00521FF085256991.00521FFD85256991@webforums>
Lines: 20
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1507
Article PK: 1088987

I'm running SQL Server 11.0.3.3 on a NT 4.0 server. The SQL server and the
open clients
are configured to run with the us_english language and cp850.
Everything had been working fine until last Wednesday, when, suddenly,
characters such as "Ç", "À", "É",
"Ó", etc... where "changed" and strange characters appeared in their
places.
These changes didn't occur in all databases. One of our system analysts
said that there weren't inserts or
updates in all the "wrong" lines of the databases. So we don't know what
could be happened.
Does anyone have an idea? (I think it's not a SQL Server problem but could
be a workstation running with a character set
diferent from cp850, but, by the other hand, how could it be if the systems
analyst said that there weren't inserts or
updates in the "wrong" databases?) Please help because we are totally lost.

Thanks in advance.


Vagner


Niels Andersen Posted on 2000-11-14 09:33:54.0Z
From: "Niels Andersen" <Niels.Andersen@simcorp.com>
References: <1FED60ACE976ECEE00521FF085256991.00521FFD85256991@webforums>
Subject: Re: strange characters appeared
Date: Tue, 14 Nov 2000 09:33:54 -0000
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <sqWV0$hTAHA.275@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: no-dns-yet.demon.co.uk 212.240.210.162
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1493
Article PK: 1088972

This could be a client problem. The 11.1.1 version of the client had the
default codepage changed from cp850 to iso_1 this basically means that
characters in the upper 128 range will appear wrong, and in some cases cant
be accessed.

The setting that was changed is in locales.dat in the locales directory on
the client.

[NT]
locale = enu, us_english, iso_1 'changed from cp850

i'm not sure this is your problem, but its worth a try


<v_cuccino@intercap.com.br> wrote in message
news:1FED60ACE976ECEE00521FF085256991.00521FFD85256991@webforums...
I'm running SQL Server 11.0.3.3 on a NT 4.0 server. The SQL server and the
open clients
are configured to run with the us_english language and cp850.
Everything had been working fine until last Wednesday, when, suddenly,
characters such as "Ç", "À", "É",
"Ó", etc... where "changed" and strange characters appeared in their
places.
These changes didn't occur in all databases. One of our system analysts
said that there weren't inserts or
updates in all the "wrong" lines of the databases. So we don't know what
could be happened.
Does anyone have an idea? (I think it's not a SQL Server problem but could
be a workstation running with a character set
diferent from cp850, but, by the other hand, how could it be if the systems
analyst said that there weren't inserts or
updates in the "wrong" databases?) Please help because we are totally lost.

Thanks in advance.


Vagner