Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    83

    Thumbs down Unanswered: SQL Server equivalent of character set

    Hello MSSQL professionals,

    Please tell me the equavalent of the below MySQL query in SQL Server.

    create table temp1(variable1 varchar(24) character set latin1 not null default '')
    Immediate help will be highly appreciated

  2. #2
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    24
    create table temp1(variable1 varchar(24) COLLATE Latin1_General_CI_AS not null default ''))

    cheers,
    riaz

    Quote Originally Posted by krReddy
    Hello MSSQL professionals,

    Please tell me the equavalent of the below MySQL query in SQL Server.

    create table temp1(variable1 varchar(24) character set latin1 not null default '')
    Immediate help will be highly appreciated

  3. #3
    Join Date
    Oct 2006
    Posts
    83
    Thanks a lot RIAZ

Posting Permissions

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