how to store and retrieve special symbols like alpha beta and gama in sql RSS

• • Reply
  

  rupeshs

  Member

  9 Points

  31 Posts

  how to store and retrieve special symbols like alpha beta and gama in sql

  Jun 11, 2009 06:42 AM|LINK

  how to store and retrieve special symbols like alpha beta and gama in sql

  • Moved by jimmy q on Jun 11, 2009 09:04 AM
• • Reply
  

  Niikola

  Contributor

  3996 Points

  761 Posts

  Re: how to store and retrieve special symbols like alpha beta and gama in sql

  Jun 11, 2009 10:31 AM|LINK

    

  Declare @t table( id int, txt nvarchar(20))
  Insert Into @t Values (1, N'αβγδ')
  Insert Into @t Values (2, nchar(945)+nchar(946)+nchar(947)+nchar(948))
  
  
  Select * from @t

   
  Smile...tomorrow will be worse
  • Marked as answer by Jian Kang - MSFT on Jun 17, 2009 05:47 AM
• • Reply
  

  eralper

  Contributor

  6048 Points

  971 Posts

  Re: how to store and retrieve special symbols like alpha beta and gama in sql

  Jun 11, 2009 10:59 AM|LINK

  As Niikola has given the script for inserting special characters, what you will give pay attention is the data type.

  You should use the nvarchar() and nchar() data types not varchar() or char()

   

  Eralper

  ASP.NET, T-SQL Programming

  T-SQL programming SQL Server Tutorials
  SQL Server 2012
  
  • Marked as answer by Jian Kang - MSFT on Jun 17, 2009 05:47 AM