I'm trying to run a bunch of SQL scripts from the command line using SQL
Server 2000:
isql -a 512 -S localhost -U sa -P "pass" -n -d SOME_DB -i "C:\test.sql"
Previously, I was using osql but from what I googled, osql is not
capable of turning off automatic ansi to oem translation like isql is.
However, what I can't find out is how to turn it off in isql... I have a
character set like so:
Ă…land Islands
Obviously that first looking A symbol is the character I'm referring to
if it actually comes across in the email here. When that's run with my
current command above, the character gets replaced with garbage.
Can somebody tell me how to turn off this translation using isql?
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------