StringCol(char_binary=True) breaks if DBMS!=MySQL
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
StringCol(char_binary=True) is required by MySQL to
allow case-sensitive comparisons for that column.
However, for instance for SQLite this is not required.
In the latter case "char_binary=True" should be
ignored, but instead an exception is trown:
ValueError: SQLite does not support binary character
columns
Logged In: YES
user_id=4799
"char_binary" was a somwhat experimental feature that I now
very much recommend againts. "char_binary" in MySQL doesn't
mean "case sensitive", it means "non-locale aware", which is
very much different thing.