Comments (1)
I have another UTF-8 problem with MySQL and Python2.7 and db.py 0.4.0
As far as I can tell my database that I connect to is UTF-8:
mysql> SELECT default_character_set_name FROM information_schema.SCHEMATA S
-> WHERE schema_name = "schema_name";
+----------------------------+
| default_character_set_name |
+----------------------------+
| utf8 |
+----------------------------+
df = database.tables.table.all()
get me data as str rather than Unicode. I will then do a unicode(cell, 'iso8859')
, which so far seems to work. cell.decode('utf-8')
as @hantusk does not work for me.
Update: I suppose that cell.decode('unicode_escape')
is - in my case - better than unicode(cell, 'iso8859')
.
from db.py.
Related Issues (20)
- Is db.py dead?
- question about the template engine pybars HOT 1
- example from twitter apparently doesn't work on Python3 HOT 1
- DB.query_from_file limit doesn't work
- Name conflict between column name and Table property HOT 1
- Connection Issue: AttributeError "Can't set attribute" /DataBase Error "Server closed the connection unexpectedly"
- postgres: AttributeError: can't set attribute. HOT 2
- Generate schema based on regex
- Executing set time_zone queries returns with an error
- 'DB' object has no attribute 'driver' when loading MSSQL profile HOT 1
- db.tables error HOT 1
- Postgres/Psycopg2 DatabaseErrror
- Handlebars partial support
- Ask for SSL over Postgres/RDS
- UnicodeEncodeError with Unicode query parameter
- Silence logging messages
- name 'ColumnSet' is not defined
- print "var", var HOT 1
- MSSQL / _gen_tables_from_col_tuples failed - Missing schema HOT 1
- Documentation enhancement
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from db.py.