I finally found the source of the problem.  It's Microsoft SQL Server
Management Studio.  When it creates .sql files, for some reason Trac thinks
they're binary because it encodes them as "Little-endian UTF-16 Unicode c
program text, with CRLF, CR line terminators" instead of "ASCII c program
text, with CRLF line terminators".  Here are two files that
were committed to svn.  The first with M$ SSMS and the second with notepad.
 The second one you can diff fine in Trac, the first one you can't.
 They're both "text" files and I can diff them either from the Linux
command line's svn or from TortoiseSVN, so this seems like it's a bug in
Trac since it won't let me diff anything encoded with "Little-endian UTF-16
Unicode c program text, with CRLF, CR line terminators"

dbo.Proc_xxxx.sql:         Little-endian UTF-16 Unicode c program text,
with CRLF, CR line terminators
dbo.Proc_yyyy.sql:                 ASCII c program text, with CRLF line
terminators


Matthew Shields
Owner
BeanTown Host - Web Hosting, Domain Names, Dedicated Servers, Colocation,
Managed Services
www.beantownhost.com
www.sysadminvalley.com
www.jeeprally.com
Like us on Facebook <http://www.facebook.com/beantownhost>
Follow us on Twitter <https://twitter.com/#!/beantownhost>


On Mon, Dec 19, 2011 at 6:02 AM, jtb <[email protected]>wrote:

> I've got to get the same thing done.
> In the need to suppress auto-merging many projects at our server uses the
> svn auto-prop to set the mime-type marking files as binaries. And trac
> doesn't diff these anymore...
> Got no satisfying clue until now.
>
> 2011/12/15 Matt Shields <[email protected]>
>
>> Anyone have a solution for this?
>>
>>
>> Matthew Shields
>> Owner
>> BeanTown Host - Web Hosting, Domain Names, Dedicated Servers, Colocation,
>> Managed Services
>> www.beantownhost.com
>> www.sysadminvalley.com
>> www.jeeprally.com
>> Like us on Facebook <http://www.facebook.com/beantownhost>
>> Follow us on Twitter <https://twitter.com/#!/beantownhost>
>>
>>
>> On Wed, Nov 30, 2011 at 3:48 PM, Matt Shields <[email protected]>wrote:
>>
>>> I've got some developers who committed their changes in svn using the
>>> wrong mime-type.  We could manually update all the mime-types of all the
>>> files in our repo but this would take forever.  Instead, is there a way to
>>> tell trac to ignore the mime-type when you try to look at the
>>> changeset/diffs?
>>>
>>> Matthew Shields
>>> Owner
>>> BeanTown Host - Web Hosting, Domain Names, Dedicated Servers,
>>> Colocation, Managed Services
>>> www.beantownhost.com
>>> www.sysadminvalley.com
>>> www.jeeprally.com
>>> Like us on Facebook <http://www.facebook.com/beantownhost>
>>> Follow us on Twitter <https://twitter.com/#!/beantownhost>
>>>
>>
>>  --
>> You received this message because you are subscribed to the Google Groups
>> "Trac Users" group.
>> To post to this group, send email to [email protected].
>> To unsubscribe from this group, send email to
>> [email protected].
>> For more options, visit this group at
>> http://groups.google.com/group/trac-users?hl=en.
>>
>
>  --
> You received this message because you are subscribed to the Google Groups
> "Trac Users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/trac-users?hl=en.
>

-- 
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en.

Reply via email to