Pound character

• Ananth-431739

  Ten Centuries

  Points: 1185

  More actions

  November 26, 2007 at 2:30 am

  #95515

  I'm running set of insert statements in SQL server2000 from .bat file. I need to insert the pound currency (£) in the table. When i run the insert statement directly in the sql server, it is inserted. But when i run thr' the batch file it is not inserting the pound currency. I think some code page has to be installed in my PC??????? Any solution pls....

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738612

  More actions

  November 28, 2007 at 7:32 pm

  #755209

  Use the Unicode character instead?

  Directly pick the character using CHAR(xxx) where xxx is the right code.

• SQL_ABD

  SSCertifiable

  Points: 5832

  More actions

  November 28, 2007 at 8:45 pm

  #755228

  he means char(163)

  Regards,

  Ahmed