Re: [google-cloud-sql-discuss] Google Cloud Second Generation Utf8Mb4 Problem

Hey Lee S.

Quick moment of your time please.

Wondering if  (character_set_client and collation_connection) can be set at the session level yet?

Thank you,

John

On Wednesday, August 10, 2016 at 9:10:27 AM UTC-6, Lee S. wrote:

On Wed, Aug 10, 2016 at 7:58 AM, Tolga Tanrıverdi <tolgata...@gmail.com> wrote:

We are using Google Cloud Sql Second Generation with our AppEngine application. However today we've discovered some problem, we cannot insert emoji characters to our database because we cannot change some server flags to utf8mb4 character encoding.

We've changed character_set_server flag to utf8mb4 but it wasnt enough

We have to change: character_set_system character_set_client collaction_connection

The mysql docs (for 5.6 and 5.7) say "character_set_system  The character set used by the server for storing identifiers. The value is always utf8."  You don't need to set this one to store utf8mb4 values (if you want to use emoji for your column names, you're out of luck ;)).

The other two (character_set_client and collation_connection) can be set at the session level.  I'll look into making these settable.

 

flags to utf8mb4 also, but second generation db is not allowing root user to change those flags. What can we do to solve this problem

Does anyone have any idea about that?

Thanks

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/96ffa068-077c-4677-9aea-7a26d2f3c471%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Lee Schumacher | Software Engineer | lschu...@google.com | (650) 336-5330

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/29732c14-869e-4929-ae12-36eb595056b8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.