Re: Unicode encoding with SQL Management Studio

Thank you Andrew, Paul, and Erland, for the tips and information.

<<CP850? Do you like to hurt yourself? Stay away from that. Or do you
need compatibility with the 6.5 tools as well?>> Right you are. I
meant Code Page 1252.

Regards,

Tom


On Fri, 30 Jun 2006 22:43:59 +0000 (UTC), Erland Sommarskog
<esquel@xxxxxxxxxxxxx> wrote:

Tom Huguelet (tomhug@xxxxxxxxxxxxxxxxx) writes:
We have an environment that is a mixture of SQL 2000 and 2005. Most of
my developers are switching over to use SQL Management Studio for both
SQL 2005 and SQL 2000 (Relational Engine).

We also use Visual Source Safe 6.0 for source code control. We're
encountering problems with SQL Management Studio re-encoding documents
to Unicode. We still need to retain backwards compatibility with VSS
6.0 and with the SQL 2000 tools.

The SQL 2000 tools can read Unicode files.

And as Paul Shapiro said, so can SourceSafe 2005. What I like to add is
that VSS 2005 is compatible with VSS 6. You probably need VSS 2005 to
Add and Check in the file, or else it gets listed as binary. But VSS 6
can still read the database, as the format for the SoruceSafe database
hasn't changed.

How can I use the SQL Management Studio but have it leave the encoding
schemes of the SQL source code files in the original form MS-DOS/Code
Page 850?

CP850? Do you like to hurt yourself? Stay away from that. Or do you need
compatibility with the 6.5 tools as well?

Any say, as Andrew said, you can use Save With Encoding to resolve this.
But I guess that if you open a CP850 file in Mgmt Studio, it will think
it's ANSI, and you will get a mess...
.

Relevant Pages

  • Re: Unicode encoding with SQL Management Studio
    ... my developers are switching over to use SQL Management Studio for both ... SQL 2005 and SQL 2000. ... We also use Visual Source Safe 6.0 for source code control. ... We still need to retain backwards compatibility with VSS ...
    (microsoft.public.sqlserver.tools)
  • Re: VSS event 6013
    ... I am experiencing a similar issue where VSS tries to access my SQL ... Server every time I perform a system state backup. ...
    (microsoft.public.windows.server.sbs)
  • Re: VSS corruption on SBS2003 R2 Premium
    ... REM re-register VSS ... regsvr32 /i swprv.dll ... REM Re-register SQL .dll file ... echo Run list writers command ...
    (microsoft.public.windows.server.sbs)
  • Re: Compatibility Level
    ... on SQL 2000. ... Books online says "Even when the database ... compatibility level is set to 60 or 65, applications gain almost all of the ...
    (microsoft.public.sqlserver.programming)
  • Re: How VSS Works with NTBackup
    ... I can't point you to a document, but my understanding is that SQL 2000 + SPx ... VSS interaction is now integrated into SQL Server so VSS can request SQL ... updates until VSS is able to take a db snapshot. ... a consistent backup of a running system. ...
    (microsoft.public.windows.server.sbs)
Loading