[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: SQL Files are treated as binary

From: Andy Levy <andy.levy_at_gmail.com>
Date: Thu, 7 Oct 2010 12:32:07 -0400

On Thu, Oct 7, 2010 at 12:29, Bob Archer <Bob.Archer_at_amsi.com> wrote:
>> I've got the problem that some of my .sql files are treated as
>> binary. I've added the mime type text/plain property, but with the
>> same result.
>>
>> On the mailing list there was the same issuea already:
>> http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=4061&dsMe
>> ssageId=947993#
>> However it's not only the blame functionality which doesn't work,
>> but also the svn:keywords which are not replaced in the file.
>> I understand that those aren't replaced if the file is binary, but
>> i've set the text/plain mimetype manually and would expect that
>> this overrides any form of internal mimetype.
>>
>> The odd thing is that some of my .sql files work correctly, their
>> svn:keywords are replaced and i can blame them (they've got no
>> mime-type property) and all my newer files don't work.
>
> I'm guessing that you are using SSMS to generate your .sql script files? Yes, for some reason svn sees them as non-text when you do an add. Whenever I add these files I always remove the svn:mimetype property before I commit it. Once I do that it handles them properly as text merging them without issue. I have no idea why it sees them as binary.

I've found that SSMS gives the files either strange EOLs or an
unconventional encoding; I usually take them into Notepad++ & convert
them to ASCII or UTF-8.

------------------------------------------------------
http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=4061&dsMessageId=2668993

To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_tortoisesvn.tigris.org].
Received on 2010-10-07 18:33:01 CEST

This is an archived mail posted to the TortoiseSVN Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.