Malcolm, I've just got a DBAdmin program called Navicat that allows you to look at blob fields as long as they are .JPG's which we have and I can see the .JPG's in the old database but not in the restored one. The weird thing is that the size of the two databases is exactly the same and if you look at the binary data it is exact on each record....original database and restored database so now I'm lead to say that it can't be the ODBC client software that is causing it as Navicat uses its own internal drivers.
This is driving me around the bend and if I have to it will mean putting the old database back on line but that means a weekend opf lost time and another database backup and load up another day but its 2 TB in size so the backup is a major factor... I agree though, it looks like some kind of encoding setting in the SQL server itself or the base O/S but I have checked all the localisation settings etc in SQL and in the server (M$2008) and can't find a single difference... Grrrrrrrrrrrrrr Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Malcolm Greene Sent: 13 February 2012 15:44 To: [email protected] Subject: Re: [NF] Urgent M$SQL help Dave, A SWAG: could there be a char encoding issue where your 2 database connections assume different character encodings? Can you create a blob field with just standard text (no ASCII chars less than 32 except for tabs, CR, and LF's) and see if these values can be read via your ODBC connection? Worst case, can you try a 3rd party commercial ODBC driver vs. the default (free) ODBC drivers from Microsoft? Malcolm [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
