115 reputation
113
bio website
location London, United Kingdom
age
visits member for 2 years, 9 months
seen Sep 25 at 20:32

Sep
25
awarded  Popular Question
Aug
18
accepted Stored procedures, binlog and SUPER privilege
Aug
18
awarded  Popular Question
Jul
2
awarded  Curious
Apr
22
comment InnoDB primary key efficiency
Excellent explanation, thank you!
Apr
22
accepted InnoDB primary key efficiency
Apr
22
asked InnoDB primary key efficiency
Mar
26
comment Is there any danger using binary data over an UTF-8 MySQL connection?
I'm quite comfortable with Unicode and UTF-8 actually, and the effects of charsets on table fields. But I'm very confused by how MySQL handles charsets while the data is being transmitted over the wire. What I precisely fail to understand is, why the hell the client & connection have a charset, and how this affects the data being transmitted to and from my app! I feel like there's some magic charset conversion happening on-the-fly, and this idea scares me. If the field contains UTF-8, I want my app to receive a UTF-8 string; if it contains binary, I want to get binary back, full stop!
Mar
25
comment Is there any danger using binary data over an UTF-8 MySQL connection?
I'm still confused by this, but you reassure me a little :)
Mar
25
asked Is there any danger using binary data over an UTF-8 MySQL connection?
Nov
5
accepted Check all MySQL tables at once
Nov
5
asked Check all MySQL tables at once
Oct
4
answered Stored procedures, binlog and SUPER privilege
Oct
4
awarded  Commentator
Oct
4
comment Stored procedures, binlog and SUPER privilege
Also, I've rewritten my code to use stored procedures since, and it seems to work! I will detail that in an answer.
Oct
4
comment Stored procedures, binlog and SUPER privilege
Just tried with DETERMINISTIC and MySQL still fails with the same error on RDS, so I assume you mean I need log_bin_trust_function_creators + DETERMINISTIC then!
Oct
4
revised Stored procedures, binlog and SUPER privilege
added 8 characters in body
Oct
4
revised Stored procedures, binlog and SUPER privilege
deleted 16 characters in body
Oct
4
asked Stored procedures, binlog and SUPER privilege
Sep
24
comment Does it make a difference to add the DEFAULT keyword in CREATE TABLE?
Thanks @ypercube, do you have any source to back this up? I'd accept that as an answer, by the way ;)