Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.mixmin.net!feed.xsnews.nl!border-1.ams.xsnews.nl!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <anilkumar.dannina@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.039
X-Spam-Evidence: '*H*': 0.92; '*S*': 0.00; 'python': 0.09; 'subject:characters': 0.09; 'to:addr:comp.lang.python': 0.09; 'cc:addr:python-list': 0.10; 'subject:python': 0.11; 'library': 0.15; 'wrote:': 0.17; 'jan': 0.18; 'module': 0.19; 'wednesday,': 0.22; 'cc:no real name:2**0': 0.24; 'cc:2**1': 0.24; 'cc:addr:python.org': 0.25; 'header:In-Reply-To:1': 0.25; 'header :User-Agent:1': 0.26; 'am,': 0.27; 'cc:addr:gmail.com': 0.27; 'module.': 0.27; 'chris': 0.28; 'facing': 0.29; 'that.': 0.30; 'ubuntu': 0.33; 'received:google.com': 0.34; 'server': 0.35; 'received:209.85': 0.35; 'characters': 0.36; 'received:209': 0.37; 'data': 0.37; 'subject:: ': 0.38; 'perform': 0.38; 'help': 0.40; 'from:no real name:2**0': 0.60; 'taking': 0.65; 'gathering': 0.71; 'special': 0.73; '2013': 0.84; 'on?': 0.91; 'subject:Special': 0.93
Newsgroups: comp.lang.python
Date: Tue, 1 Jan 2013 20:46:56 -0800 (PST)
In-Reply-To: <mailman.1527.1357065016.29569.python-list@python.org>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=115.111.146.130; posting-account=IZMJowoAAABEA6DKWCCjJGUk0PjpfxWN
References: <b1b99ce0-6088-4c80-9e43-ac12e7799b92@googlegroups.com> <mailman.1527.1357065016.29569.python-list@python.org>
User-Agent: G2/1.0
X-Google-Web-Client: true
X-Google-IP: 115.111.146.130
MIME-Version: 1.0
Subject: Re: Handling Special characters in python
From: anilkumar.dannina@gmail.com
To: comp.lang.python@googlegroups.com
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Cc: anilkumar.dannina@gmail.com, Python <python-list@python.org>
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Message-ID: <mailman.1549.1357102018.29569.python-list@python.org>
Lines: 23
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1357102018 news.xs4all.nl 6842 [2001:888:2000:d::a6]:43734
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:35958

On Wednesday, January 2, 2013 12:00:06 AM UTC+5:30, Chris Rebert wrote:
> On Jan 1, 2013 3:41 AM, <anilkuma...@gmail.com> wrote:
>=20
> >
>=20
> > I am facing one issue in my module. I am gathering data from sql server=
 database. In the data that I got from db contains special characters like =
"endash". Python was taking it as "\x96". I require the same character(enda=
sh). How can I perform that. Can you please help me in resolving this issue=
.
>=20
>=20
> 1. What library are you using to access the database?
>=20
> 2. To confirm, it's a Microsoft SQL Server database?
>=20
> 3. What OS are you on?



1. I am using "pymssql" module to access the database.
2. Yes, It is a SQL server database.
3. I am on Ubuntu 11.10