I get the following message when I try to register a SQL Server in EM.
Warning - The client and server codepages do not match. Some ANSI character mappings may not be possible.

This is not an issue that is going affect my work, but just want to know how to fix it. Using rebuildm I changed the Collation setting from default to Binary Sort order for 850 multilingual character set. But the client tools were installed long time back with the default Collation setting.

Any thoughts on this.

Thanks,

I've never heard of any issues with it. The mismatch is due
to the connecting client's operating system using a
different code page than the SQL instance you are connecting
to. The error is raised when comparing the OS code page and
the SQL Server code page of the instance. The warning won't
prevent you from connecting or doing anything. The warning
is just to tell you that some characters, data in the
database may not display correctly if they can't be
translated to the OS code page when coming back to the
client. The data will be returned - it just looks like
garbage.

-Sue

On Tue, 6 Apr 2004 13:31:10 -0700, Dave Spencer
[quoted text, click to view]