Mysql database - I can not anymore create database since Portal azure

Question

Mysql database - I can not anymore create database since Portal azure

David M 236

On portal azure, in may mysql resource, i click "Databases / add" button.
I choose "xoops" name, UTF8_GENERAL_CI, Latin1 and i Save.
The progression bar is finish and i have the message "Ok created".
But there is not in list.

If i choose "UTF8" instead of "Latin1", it works 0_0

There is a bug ?

GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator

2022-03-12T03:25:47.253+00:00

HI, @David M Thanks for the ask and using the Microsoft Q&A platform.
As we understand the ask here you are trying to create a database with the name, UTF8_GENERAL_CI, Latin1 and it does not show up in the list.
I have tried to create with the above-mentioned details and I also see the same behavior, I am checking with the internal product team and comeback to you once I get the update.

Regards
Geetha

2 answers

Your answer

GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator

2022-03-12T03:25:47.253+00:00

HI, @David M Thanks for the ask and using the Microsoft Q&A platform.
As we understand the ask here you are trying to create a database with the name, UTF8_GENERAL_CI, Latin1 and it does not show up in the list.
I have tried to create with the above-mentioned details and I also see the same behavior, I am checking with the internal product team and comeback to you once I get the update.

Regards
Geetha

Answer 1

GeethaThatipatri-MSFT 29,547 Microsoft Employee Moderator

HI, @David M For now we would recommend selecting the correct set and collation...the collation name first part (Before _ ) explains which character set it support.... We are making the required changes in the UI in the portal to select the character set and show only supported collation which should mostly fly in the next portal deployment

The solution would look something like this

Regards
Geetha

GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator

2022-03-18T18:37:57.433+00:00

HI, @David M We haven't heard back from you. Just wanted to check if you are still facing the issue? please let us know if the above collection showed worked for you.

Regards
Geetha

Answer 2

David M 236

Hello,

In urgence , I used another configuration.
I don't need to do this anymore.

Regards

GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator

2022-03-21T12:22:18.707+00:00

Hi, @David M Thanks for the confirmation that it worked for you with other configurations.

Thank you for visiting Microsoft QA forums! Have a great day!

Regards
Geetha

Share via

Mysql database - I can not anymore create database since Portal azure

2 answers

Your answer