How to special Characterslike '►' in database

• Swamy Magam

  Ten Centuries

  Points: 1096

  More actions

  December 17, 2008 at 4:59 am

  #204196

  Hi

  friends

  I have table like tEmp columns Empno(int),data(varchar(50))

  i am inserting data like

  Insert into tEmp values(1,'FONT-FAMILY: Arial">► ')

  (1) row inserted sucessfully

  but arrowmark symbol is saved like ? this is my problem.

  i want save like ► or []

  please help me.

  Thanks in advance

  Regards

  venkat

• Ronald H

  SSCarpal Tunnel

  Points: 4053

  More actions

  December 17, 2008 at 6:01 am

  #913751

  First of all, the name of your table shows a bit funny to me, since temp is often used differently. Dropping a temp table sounds a bit too logical to me, I would rename it if I were you.

  Your ? character isn't included in the ascii table (the up and down arrow are btw). nvarchar doesn't provide a solution also, so I would think there's not any easy way to store those characters. Based on how much you want it (and how many odd characters you need), you can make a table of a characterset to store these non ascii chars, and you need to think of a solution how to implement this in your base table. Also you would need to adjust the delivering system to format the characters as implemented in your characterset table.

  Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2

• Swamy Magam

  Ten Centuries

  Points: 1096

  More actions

  December 17, 2008 at 6:17 am

  #913767

  thank u for u r replay

  .

  my table name tEmployee i write shortly tEmp.ok.

  one more thing , my problem solved.

  when i am inserting time i passed like nvarchar value

  ex:

  Insert into tEmp values(1,N'FONT-FAMILY: Arial">? ')

  if i a pass like N'FONT-FAMILY: Arial">? '

  it is saved properly.

  thanks

  regards

  Venkat.