[Bug 1236297] Re: Unicode errors with PostgreSQL and RawStr fields

[Aurélien Bompard]

I found why! In "mailman/src/mailman/database/schema/postgres.sql", the moderator_password field is of type "TEXT" instead of being "BYTEA". As a result, the psycopg2 driver converts it to an unicode string.
This is coherent with the Storm manual which states that RawStr types should be set as BYTEA types in PostgreSQL:
https://storm.canonical.com/Manual#Table_of_properties_vs._python_vs._database_types

I believe a schema migration script will be needed.

-- 
You received this bug notification because you are a member of Mailman
Coders, which is subscribed to GNU Mailman.
https://bugs.launchpad.net/bugs/1236297

Title:
  Unicode errors with PostgreSQL and RawStr fields

To manage notifications about this bug go to:
https://bugs.launchpad.net/mailman/+bug/1236297/+subscriptions