Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #102631
| From | Dietmar Schwertberger <maillist@schwertberger.de> |
|---|---|
| Newsgroups | comp.lang.python |
| Subject | Re: What's the best/neatest way to get Unicode data from a database into a grid cell? |
| Date | 2016-02-07 16:06 +0100 |
| Message-ID | <mailman.74.1454861303.2317.python-list@python.org> (permalink) |
| References | <tqljoc-nad.ln1@esprimo.zbmc.eu> |
On 07.02.2016 12:19, cl@isbd.net wrote:
> However my database has quite a lot of Unicode data as there are
> French (and other) names with accents etc. What's the right way to
> handle this reasonably neatly? At the moment it traps an error at
> line 37:-
> self.SetCellValue(row_num, i, str(cells[i]))
The unicode versions of wxPython should have no problems with handling
unicode strings.
The problem that you see here is that str(...) tries to convert your
unicode data into a non-unicode string, which of course fails.
Do something like:
value = cells[i]
if not isinstance(value, basestring):
value = str(value)
self.SetCellValue(row_num, i, value)
Once you switch to Python 3 and Phoenix you have to modify this
slightly, e.g. by adding this to the top of your code:
try:
basestring
except:
basestring = (bytes,str)
Regards,
Dietmar
Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
What's the best/neatest way to get Unicode data from a database into a grid cell? cl@isbd.net - 2016-02-07 11:19 +0000
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? Chris Angelico <rosuav@gmail.com> - 2016-02-07 22:56 +1100
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? cl@isbd.net - 2016-02-07 12:42 +0000
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? Chris Angelico <rosuav@gmail.com> - 2016-02-08 00:11 +1100
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? cl@isbd.net - 2016-02-07 13:59 +0000
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? Dietmar Schwertberger <maillist@schwertberger.de> - 2016-02-07 16:06 +0100
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? cl@isbd.net - 2016-02-08 10:22 +0000
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? Chris Angelico <rosuav@gmail.com> - 2016-02-08 21:57 +1100
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? Vlastimil Brom <vlastimil.brom@gmail.com> - 2016-02-07 19:22 +0100
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? cl@isbd.net - 2016-02-08 10:42 +0000
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? Chris Angelico <rosuav@gmail.com> - 2016-02-08 21:55 +1100
Re: What's the best/neatest way to get Unicode data from a database into a grid cell? Vlastimil Brom <vlastimil.brom@gmail.com> - 2016-02-08 16:00 +0100
csiph-web