in reply to Re: Problem with larger files (and s/)
in thread Problem with larger files (and s/)
I was certain that the file was ASCII. Correction, I was absolutely certain that it was ASCII.
It wasn't.
There are two ways of generating scripts in SQL Server 2000's Enterprise Manager. The script generator can save them to a file, or preview them and you can copy/paste into whatever you want. This is the route that I normally go. I did not notice that the final option screen let you specify OEM, ANSI or Unicode, and it defaults to Unicode.
*facepalm*
*bang head against wall*
*rinse, repeat*
I couldn't find a hex mode in TextPad, turns out that you specify a binary file type in the Open dialog, and then it quite obviously was Unicode.
In Section
Seekers of Perl Wisdom