Proper Way to Insert Strings to a SQLAlchemy Unicode Column

Question

I have a SQLAlchemy model with a Unicode column. I sometimes insert unicode values to it (u'Value'), but also sometimes insert ASCII strings. What is the best way to go about this? When I insert ASCII strings with special characters I get this warning:

SAWarning: Unicode type received non-unicode bind param value ...

How do I avoid this? What is the proper way to insert my different types of strings?

score 5 · Answer 1 · answered Apr 21 '11 at 12:20

5

Thre are several options:

Disable all SQLAlchemy warnings with warnings.simplefilter('ignore', sqlalchemy.exc.SAWarning).
Disable only this warning with more specific filter spec by module and lineno or message, e.g. warnings.filterwarnings('ignore', '^Unicode type received non-unicode bind param value', sqlalchemy.exc.SAWarning).
Use String(convert_unicode=True) instead of Unicode type.
Rethink the problem and change your code to use unicode even for ASCII strings.

answered Apr 21 '11 at 12:20

Denis Otkidach

28,521
8
72
93

3

You attemping delete problem instead of solving it.About number 3: Official documentation of `sqlalchemy` say use `Unicode type` but you say use `String(convert_unicode=True)` , i have same problem , but i don't think sqlalchemy solve with `disable warning` because it has `clean code` not `dirty`. – PersianGulf Sep 06 '13 at 05:59

score 0 · Answer 2 · edited Sep 10 '16 at 03:09

You should define your table class and constructor as such:

class User(declarative_base()):
    _tablename__ = 'user'
    name = Column(Unicode(200, convert_unicode=False))
    textfield = Column(UnicodeText(convert_unicode=False))

user = Table('user', MetaData(),
Column('name', Unicode(200, convert_unicode=False), nullable=False),
Column('textfield', UnicodeText(convert_unicode=False), nullable=False),
)

Of course, you should not forget to attach URI+"charset=utf8" for create_engine function

Proper Way to Insert Strings to a SQLAlchemy Unicode Column

2 Answers2