I am getting the following error and I'm not sure how to fix it. I am trying to use Flask-SQLAlchemy and Flask-Migrate to help with managing a mysql database. I set up a database on pythonanywhere.
After running
flask db migrate
flask db upgrade
I get the following error.
sqlalchemy.exc.ProgrammingError: (mysql.connector.errors.ProgrammingError) Character set '255' unsupported
(Background on this error at: https://sqlalche.me/e/14/f405)
I am using a virtual environment I created on PythonAnywhere (Python 3.9.13) with the following relevant packages installed:
alembic==1.9.0
Flask==2.2.2
Flask-Migrate==4.0.0
Flask-SQLAlchemy==3.0.2
mysql==0.0.3
mysql-connector-python==8.0.31
mysqlclient==2.1.1
python-dotenv==0.21.0
SQLAlchemy==1.4.45
I tried to setup my database in the way described by this tutorial: https://blog.pythonanywhere.com/121/
Thanks in advance!