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?

Denis Otkidach · Accepted Answer · 2011-04-21 12:20:57Z

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, 2011 at 12:20

Denis Otkidach

33.5k8 gold badges86 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PersianGulf Over a year ago

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.

Matthew Moisen · Accepted Answer · 2016-09-10 03:09:29Z

0

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

edited Sep 10, 2016 at 3:09

Matthew Moisen

18.6k32 gold badges148 silver badges253 bronze badges

answered Sep 6, 2013 at 6:14

PersianGulf

2,8877 gold badges52 silver badges72 bronze badges

Collectives™ on Stack Overflow

Proper Way to Insert Strings to a SQLAlchemy Unicode Column

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related