Re: [sqlalchemy] MySQL “charset introducer” how-to?

2018-03-11 Thread jens . troeger
Thank you Mike! I hoped that we can do without all the details, but I guess not. This warning has been (quite literally) bugging me for days. I’m very tempted to ignore it because the warning seems to be a recent regression (see below) and also because we’re moving to PostgreSQL very soon…

Re: [sqlalchemy] MySQL “charset introducer” how-to?

2018-03-11 Thread jens . troeger
Well that’s good news then, thanks Mike 邏 On Monday, March 12, 2018 at 11:08:28 AM UTC+10, Mike Bayer wrote: > > the issue is Python 3 only and reproduces with PyMySQL 0.8.0 and not > with 0.7.1.Hopefully this is a PyMySQL bug that can be resolved > quickly (note I might recall seeing this

Re: [sqlalchemy] SQLlite: enforce a unique constraint on a relation?

2018-03-11 Thread Mike Bayer
On Sun, Mar 11, 2018 at 6:42 PM, Ryan Holmes wrote: > (cross posted from https://stackoverflow.com/questions/49225846/) > > Lets say I have 3 tables: parent, child, and a linker table for the two for > a many-to-many relationship, `parentChildren`. Each parent can have

[sqlalchemy] SQLlite: enforce a unique constraint on a relation?

2018-03-11 Thread Ryan Holmes
(cross posted from https://stackoverflow.com/questions/49225846/) Lets say I have 3 tables: parent, child, and a linker table for the two for a many-to-many relationship, `parentChildren`. Each parent can have multiple children, and each child can have multiple parents. If parent 1 already has

Re: [sqlalchemy] MySQL “charset introducer” how-to?

2018-03-11 Thread Mike Bayer
On Sun, Mar 11, 2018 at 4:32 PM, wrote: > Thank you Mike! > > I hoped that we can do without all the details, but I guess not. This > warning has been (quite literally) bugging me for days. I’m very tempted to > ignore it because the warning seems to be a recent

[sqlalchemy] MySQL “charset introducer” how-to?

2018-03-11 Thread jens . troeger
Hello, I ran into a warning (1300, "Invalid utf8mb4 character string: 'C3D545'") when inserting or updating a `blob` and apparently that’s expected behavior as per MySQL bug 79317 . However, according to one of the comments

Re: [sqlalchemy] MySQL “charset introducer” how-to?

2018-03-11 Thread Mike Bayer
On Sun, Mar 11, 2018 at 8:25 AM, wrote: > Hello, > > I ran into a warning (1300, "Invalid utf8mb4 character string: 'C3D545'") > when inserting or updating a `blob` and apparently that’s expected behavior > as per MySQL bug 79317. However, according to one of the comments