osql and accents

• Corobori

  Ten Centuries

  Points: 1316

  More actions

  January 6, 2004 at 11:51 am

  #65372

  Hi,

  I am using osql to work on MSDE SQL Server database.

  I created a .bat file that my user need to run once it looks like this:

  osql -S (local)\dbinstance -U username -P userpwd -i C:\SodiData\Createtbl.sql -o c:\SodiData\logosql.txt

  I am having a problem when running the Createtbl.sql file. That file contains a bunch of SQL statement to create views, alter tables, etc. The problem I am having is that some table's names and column's names contains accents (I now it's pretty silly but I never do it but that's the way I got it) and it seems that osql does not consider them so I am getting message such as

  Msg 207, Niveau 16, tat 3, Serveur KALGOORLIE\SODICLIENT, Proc‚dure vwRacinesCarte, Ligne 5

  'EchUanceCarte' : nom de colonne incorrect.

  Where the real name of the column is EchéanceCarte

  To me the collation name looks ok, its SQL_Latin1_General_CP1_CI_AS

  In my SQL file I added

  USE mydb_1

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  SET LANGUAGE french

  GO

  But it didn't change.

  What else could I do ?

  jean-luc

  
  Jean-Luc
  www.corobori.com
  

• Corobori

  Ten Centuries

  Points: 1316

  More actions

  January 6, 2004 at 2:36 pm

  #488867

  Solved: from the Query Analyzer I had to save my .sql file into a Unicode file using the Save As and changing the File Format from ANSI to Unicode !

  Found the answer here: http://groups.google.com/groups?q=osql+collation&hl=en&lr=&ie=UTF-8&oe=utf-8&safe=off&selm=17cd601c22e7c%24f751a2a0%2436ef2ecf%40tkmsftngxa12&rnum=3

  If somebody knows a guy called Erland Sommarskog just thank him for his post !

  
  Jean-Luc
  www.corobori.com