RE: SQL Server varchar not liking HTML entities?

2004-08-02 Thread Dave Watts
> Within the Enterprise Manager itself. This is via RDS from > my Mac to the Windows server. I would recommend you try running the query through Query Analyzer instead. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Mess

Re: SQL Server varchar not liking HTML entities?

2004-08-02 Thread Damien McKenna
On Jul 31, 2004, at 3:04 PM, Dave Watts wrote: > When you say you're doing this from Enterprise Manager, do you mean > you're > using the Query Analyzer application? Or are you actually editing the > table's contents from Enterprise Manager itself? Within the Enterprise Manager itself.  This is v

RE: SQL Server varchar not liking HTML entities?

2004-07-31 Thread Dave Watts
> I'm trying to clean up some old data where they have e.g. the > TM symbol embedded in the data.  The odd thing is that in the > Enterprise Manager when I am editing the field (after doing a > show-all) and I change the TM to ™ I am told: > > The value you entered is not consistent with the da

SQL Server varchar not liking HTML entities?

2004-07-30 Thread Damien McKenna
I'm trying to clean up some old data where they have e.g. the TM symbol embedded in the data.  The odd thing is that in the Enterprise Manager when I am editing the field (after doing a show-all) and I change the TM to ™ I am told: The value you entered is not consistent with the data type or l