Diffing and viewing .SQL files

JPrime · Post by **JPrime** » Wed Mar 15, 2006 3:04 pm

We're using Vault 3.0.7.

We use VS 2005 to generate scripts of stored procedures, which we then place into vault. Whenever we try and compare revisions of one of these files, they are displayed 1 character per line, which isn't very helpful. Is this something to do with the file (when I open it in notepad, it seems fine), or is it a Vault setting?

Jonas

JPrime · Post by **JPrime** » Wed Mar 15, 2006 3:30 pm

Update:

It looks like the .SQL files generated by VS2005 are UTF-16 encoded. Is there a way to get SGDM to recognize both ANSI and UNICODE files (so I don't have to swap that option back and forth?)

lbauer · Post by **lbauer** » Thu Mar 16, 2006 10:04 am

Not in the current version. We have a feature request logged for the Diff/Merge tool to detect the encoding automatically. I'll add your "vote."

Post by **jclausius** » Thu Mar 16, 2006 11:35 am

Are there extended ASCII characters in your file? If not, there is no reason you need to switch back and forth.

ANSI's encoding for symbols 0 - 127 are mapped to the same symbols in UTF-8. Using UNICODE settings (with utf-8) should still work for both 2 byte Unicode as well an ANSI file as long as no characters are in the extended character set.

jfennell · Post by **jfennell** » Tue Jan 16, 2007 3:35 pm

Is there any word on whether this issue has been or will be addressed in Vault? We're running Server & Client 3.5.1 and still seeing this behavior.

Unfortunately, I didn't notice it until after loading my 59 functions and 301 stored procedure scripts. Does anyone have any ideas other than regenerating all of the scripts as ANSI encoded instead of the default UNICODE?

Thanks in advance,

Jim Fennell

lbauer · Post by **lbauer** » Tue Jan 16, 2007 4:01 pm

Have you tried changing the setting in Diff/Merge options to Unicode?
Do you still have the problem?

jfennell · Post by **jfennell** » Tue Jan 16, 2007 5:03 pm

Thanks. That appears to work. Couldn't find that setting before. Sure saves a lot of work!

Peace,

Jim Fennell

pdelco · Post by **pdelco** » Fri Apr 13, 2007 7:40 am

I'm having the same problem with the diff/merge utility using Vault client 3.5.1. I looked under options to change the setting described above but could not find it. Can you please tell me where I can find this option and what I need to do to change it?

Thanks

lbauer · Post by **lbauer** » Fri Apr 13, 2007 9:14 am

This setting is in the diff/merge tool under Tools->Options->Character encodings.

SourceGear Support

Diffing and viewing .SQL files

Diffing and viewing .SQL files

Any Updates on Unicode Support for Diffs?

That Did The Trick