Hi

we have a problem where different clients are not seeing
the character for a particular text code value

ie
client 1 sees code value as £
client 2 sees code value as accented u

any ideas on how to resolve so that the server to client
character mapping is the same - changing locale setting
does not appear to resolve the problem

thanks

Sounds like collation inconsistencies to me.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"liferily" <liferily (AT) liferily (DOT) net> wrote

Hi

we have a problem where different clients are not seeing
the character for a particular text code value

ie
client 1 sees code value as £
client 2 sees code value as accented u

any ideas on how to resolve so that the server to client
character mapping is the same - changing locale setting
does not appear to resolve the problem

thanks