Re: Problems Writing £ (pound sterling) To MS SQLServer using pymssql

2008-11-27 Thread Darren Mansell
On Mon, 2008-11-17 at 14:52 +, Darren Mansell wrote: > Hi. > > I'm relatively new to python so please be gentle :) > > I'm trying to write a £ symbol to an MS SQL server using pymsssql . This > works but when selecting the data back (e.g. using SQL manageme

Re: Problems Writing £ (pound sterling) To MS SQL Server using pymssql

2008-11-17 Thread Darren Mansell
On Mon, 2008-11-17 at 15:24 +, Tim Golden wrote: > Darren Mansell wrote: > > Hi. > > > > I'm relatively new to python so please be gentle :) > > > > I'm trying to write a £ symbol to an MS SQL server using pymsssql . This > > works but when s

Problems Writing £ (pound sterling) To MS SQL Server using pymssql

2008-11-17 Thread Darren Mansell
If I insert a £ symbol in using SQL management studio then select it back from Python I get this: [('\xc2\xa3',), ('1',), ('\xa3',)] If I look in SQL management studio it says this: £ for the inserts I do through Python/pymssql. Does anyone have any ideas whats happening and how to fix it? Thanks -- Darren Mansell <[EMAIL PROTECTED]> -- http://mail.python.org/mailman/listinfo/python-list