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

2008-11-17 Thread J. Cliff Dyer
On Mon, 2008-11-17 at 15:55 +, Darren Mansell wrote: > 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 . Thi

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 selecting the data back (e.g. using SQL management

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

2008-11-17 Thread J. Cliff Dyer
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 management > studio) the £ symbol is repla

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

2008-11-17 Thread Tim Golden
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 management studio) the £ symbol is replaced with £ (latin capital letter A with circumf

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

2008-11-17 Thread Darren Mansell
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 management studio) the £ symbol is replaced with £ (latin capital letter A with circumflex). I can reproduce i