Path: csiph.com!usenet.pasdenom.info!gegeweb.org!usenet-fr.net!nerim.net!novso.com!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!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.002 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'insert': 0.05; 'explicit': 0.07; 'postgresql': 0.07; 'ambiguity': 0.09; 'cursor': 0.09; 'name?': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'variable,': 0.09; 'python': 0.11; 'finney': 0.16; 'goebel': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'rejection': 0.16; 'sqlite': 0.16; 'subject:values': 0.16; 'unicode,': 0.16; 'all,': 0.19; 'select': 0.22; 'header:User- Agent:1': 0.23; 'bytes': 0.24; 'text.': 0.24; 'handling': 0.26; 'this:': 0.26; 'gets': 0.27; 'header:X-Complaints-To:1': 0.27; 'characters': 0.30; 'statement': 0.30; 'especially': 0.30; 'writes:': 0.31; 'table': 0.34; 'subject:with': 0.35; 'german': 0.35; 'prepare': 0.35; 'version': 0.36; 'object,': 0.36; 'sometimes': 0.38; 'ben': 0.38; 'to:addr:python-list': 0.38; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'name': 0.63; 'face': 0.64; 'more': 0.64; 'different': 0.65; 'skip:\xe2 10': 0.65; 'between': 0.67; 'biggest': 0.67; '8bit%:40': 0.68; 'improvements': 0.68; 'statement,': 0.68; 'results': 0.69; 'special': 0.74; '\xe2\x80\x9cthe': 0.91 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Ben Finney Subject: Re: Trouble with utf-8 values Date: Tue, 05 Nov 2013 12:36:02 +1100 References: <5278496E.2000203@fam-goebel.de> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Gmane-NNTP-Posting-Host: rasputin.madmonks.org X-Public-Key-ID: 0xAC128405 X-Public-Key-Fingerprint: 517C F14B B2F3 98B0 CB35 4855 B8B2 4C06 AC12 8405 X-Public-Key-URL: http://www.benfinney.id.au/contact/bfinney-gpg.asc X-Post-From: Ben Finney User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) Cancel-Lock: sha1:K2XfV4dW94uHBx8SIy1PDS1uMok= 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: 32 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1383615379 news.xs4all.nl 15869 [2001:888:2000:d::a6]:60628 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:58475 Ulrich Goebel writes: > I have an object (a variable) name This confuses me. Is it an object, a variable, or a name? > which gets its value from a PostgreSQL database via a SELECT > statement, an it sometimes has german special characters as ß, ä, ö... What is the type of that object? You can interrogate Python for the answer, by using ‘type(foo)’ which will return the type of the object named by “foo”. > Then I would like to insert that value into a table in a SQLite > database. So I make a cursor cur on the table and prepare a SQL > statement like this: > > sql = 'insert into tbl values(?)' > cur.execute(sql, (name,)) What version of Python are you running? Do you get different results in Python 2 versus Python 3? One of the biggest improvements in Python 3 is the proper handling of Unicode, with more explicit rejection of ambiguity between bytes versus text. -- \ “The face of a child can say it all, especially the mouth part | `\ of the face.” —Jack Handey | _o__) | Ben Finney