Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!goblin2!goblin.stu.neva.ru!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.024 X-Spam-Evidence: '*H*': 0.95; '*S*': 0.00; 'received:209.85.223': 0.03; 'python': 0.09; 'subject:characters': 0.09; 'cc:addr:python- list': 0.10; 'subject:python': 0.11; 'library': 0.15; 'wrote:': 0.17; 'jan': 0.18; 'email addr:gmail.com>': 0.20; 'issue.': 0.20; 'from:addr:chris': 0.22; 'cc:2**0': 0.23; '>': 0.23; 'cc:addr:python.org': 0.25; 'header:In-Reply-To:1': 0.25; 'am,': 0.27; 'module.': 0.27; 'message-id:@mail.gmail.com': 0.27; 'facing': 0.29; 'skip:& 10': 0.29; 'that.': 0.30; '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; 'taking': 0.65; 'gathering': 0.71; 'special': 0.73; '2013': 0.84; 'on?': 0.91; 'subject:Special': 0.93 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=rebertia.com; s=google; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=6x2LW5r5aWqTCutvj1XwXV35vMU2enHRTo5eHpR0CD8=; b=FVzwaQq9UjUYdTKyUD9p3cGBQ1jh5qpRj1H9JlOTBDG/8IH0jnOPb/M8vsblauV9oS yXuBj+3zssC0LZ5NDbr71xD38MudE2xNnwxoPhuhyPRrjPSaGZ+DFE07l/3Z1oths+SX x1exVzo45NNu9WTsUpkPEmNozgzzKV9AgQICI= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:x-gm-message-state; bh=6x2LW5r5aWqTCutvj1XwXV35vMU2enHRTo5eHpR0CD8=; b=XxlHhkVrJit4mAj62QLRMAtQlbomJX0Hd4+A51QA3VLEAj0dJyH3P/EHLkQE0j3Zef PdX8XPhUax/XDh/ZvNNZNuA0HQS0TuluCIZl6iiJUGjnoZtlXwl3LSr6dbVthEC54eS6 oE7sPPhoAwle7vjrGQUVmlMbzM9I1h7MvhveKdaEKq3z5VhXvojUPHaG9pX0lv91SxqR VZf6uWS68d7t4lpzFq5djP9aI1FKJu8UInkxnHj6mE17zcdZddcp00kupEvYCgykiUgq 8rbk2jBuB2MY4QKdhx5gzEamePfFIIoXWT57rY9T3jfvTAURaEcY4sznNxtq0xsM4hVc A54g== MIME-Version: 1.0 In-Reply-To: References: Date: Tue, 1 Jan 2013 10:30:06 -0800 Subject: Re: Handling Special characters in python From: Chris Rebert To: anilkumar.dannina@gmail.com Content-Type: multipart/alternative; boundary=14dae934103bb260a304d23e51ac X-Gm-Message-State: ALoCoQn+cMAcwbej2jmlKCAXdlpO0i5UVnpFn3WJIeyESNJZOtZYN8g7npEKJDPtCxw1tGw7x5SN Cc: Python X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 33 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1357065016 news.xs4all.nl 6882 [2001:888:2000:d::a6]:40767 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:35906 --14dae934103bb260a304d23e51ac Content-Type: text/plain; charset=UTF-8 On Jan 1, 2013 3:41 AM, wrote: > > 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(endash). How can I perform that. Can you please help me in resolving this issue. 1. What library are you using to access the database? 2. To confirm, it's a Microsoft SQL Server database? 3. What OS are you on? --14dae934103bb260a304d23e51ac Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

On Jan 1, 2013 3:41 AM, <anilkumar.dannina@gmail.com> wrote:
>
> I am facing one issue in my module. I am gathering data from sql serve= r database. In the data that I got from db contains special characters like= "endash". Python was taking it as "\x96". I require th= e same character(endash). How can I perform that. Can you please help me in= resolving this issue.

1. What library are you using to access the database?
2. To confirm, it's a Microsoft SQL Server database?
3. What OS are you on?

--14dae934103bb260a304d23e51ac--