Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    India
    Posts
    15

    Unanswered: Collation Problem

    HI


    I am facing a problem with SqlServer 2000,

    create table test123 (
    [Description] [varchar] (50) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL
    )
    go
    insert into test123 ( [Description] ) values ('Prøve')

    The insert statement works fine from SQL query Analyzer.

    However when I populate the table using osql, the collation is going wrong.. I am not getting the same string in the table.

    Regards

    \Joe

  2. #2
    Join Date
    Mar 2002
    Location
    Edinburgh
    Posts
    8
    Try and this and see if it works

    create table test1234 (
    [Description] [varchar] (50) COLLATE Latin1_General_CI_AS
    )
    go
    insert into test1234 ( [Description] ) values ('Prøve')

    That should do it.

    Tell me if it works?

Posting Permissions

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