Can insert ≥ symbol but..it shows ≥ as = sign....can't get ≥ sign

• SQL Dev-938873

  Ten Centuries

  Points: 1280

  More actions

  June 12, 2009 at 12:34 am

  #99762

  hi friends,

  I Can insert ≥ symbol into table but..it shows ≥ as = sign....

  when i retrieve values from that table can't get ≥ sign..its showing =..

  can anybody hav idea about this issue

  thanks in advance

  Gani

  GaNeSH

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  June 12, 2009 at 1:19 am

  #1008418

  First of all you column must be a nchar or nvarchar column.

  When you can do like this:

  CREATE TABLE t1( c1 NVARCHAR(10))

  GO

  INSERT INTO t1

  VALUES(NCHAR(8805))

  GO

  SELECT * FROM t1

  GO

  DROP TABLE t1

  [font="Verdana"]Markus Bohse[/font]

• SQL Dev-938873

  Ten Centuries

  Points: 1280

  More actions

  June 12, 2009 at 2:37 am

  #1008441

  ThanQ very much Markus Bohse

  GaNeSH