Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Canada
    Posts
    45

    Red face Unanswered: osql and carc.:יאט

    I run a script with Osql and got no error but the accent caracter (french message) are modified.

    the script is
    Code:
    CREATE PROCEDURE dbo.AccentTest
    AS
           Print('י א ט מ ן ש')
    GO
    and come
    Code:
    CREATE PROCEDURE dbo.AccentTest
    AS
           Print('Θ α Φ ε ∩ ∙')
    GO

    This is very bad! Can someone can help me?
    Any suggestion?
    PLease.....


    osql.exe -S MyServer -U username-P pwd-d TestDB -n -o "C:\Dev\osql_test.log" -i "C:\Dev\AccentTest.sql" :
    Franky
    FBoucheros@hotmail.com

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    What's the default language of the database? I don't have a lot of experience here, but I would start there. Also take a look at varchar and nvarchar.

    [Edit: I should note that I have a default install of SQL Server 2000 (SP4). I created the proc as shown above and executed it and it printed the characters correctly.]

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •