utf8mb3_tolower_ci not implemented

[mikelee666]

utf8mb3_tolower_ci not implemented

[timsehn]

We don't have that collation yet. @Hydrocharged will implement it today and get a release.

[bpf120]

@mikelee666 We'd love to learn about your use case too. Feel free to email me or swing by our Discord if you want to chat.

[mikelee666]

I'm using dolt for replication for mysql8

[timsehn]

Great! We think the replication use case is a great one.

[mikelee666]

another Question: did the dolt which use as replication of mysql support api interface ?

[timsehn]

So you're Dolt replica is a MySQL compatible server. It can answer SQL queries from any MySQL client. That is an "API interface"

If you want a web-based API, you have to push the database to DoltHub or DoltLab.

https://docs.dolthub.com/products/dolthub/dolthub-api

Those act as a remote (in the Git context):

https://docs.dolthub.com/concepts/dolt/git/remotes

You can set up your replica to "push on write" to a remote:

https://docs.dolthub.com/sql-reference/server/replication#configuring-a-primary

[mikelee666]

Mysql also have UTF8MB4_GENERAL_CI, UTF8MB4_0900_AI_CI and so on, did the new release version implemented those?

[mikelee666]

So you're Dolt replica is a MySQL compatible server. It can answer SQL queries from any MySQL client. That is an "API interface"

If you want a web-based API, you have to push the database to DoltHub or DoltLab.

Can I use DoltLab as a replication for mysql?

[timsehn]

Mysql also have UTF8MB4_GENERAL_CI, UTF8MB4_0900_AI_CI and so on, did the new release version implemented those?

These are the current supported collations: https://docs.dolthub.com/sql-reference/sql-support/miscellaneous#collations-and-character-sets

Can I use DoltLab as a replication for mysql?

No. DoltLab's Dolt is offline. You need a running Dolt to act as a replica.

[mikelee666]

Mysql also have UTF8MB4_GENERAL_CI, UTF8MB4_0900_AI_CI and so on, did the new release version implemented those?

These are the current supported collations: https://docs.dolthub.com/sql-reference/sql-support/miscellaneous#collations-and-character-sets

Could I miss database "mysql" by setting REPLICATE_IGNORE_TABLE, what side effect may happen?

[timsehn]

Mysql also have UTF8MB4_GENERAL_CI, UTF8MB4_0900_AI_CI and so on, did the new release version implemented those?

These are the current supported collations: https://docs.dolthub.com/sql-reference/sql-support/miscellaneous#collations-and-character-sets

Could I miss database "mysql" by setting REPLICATE_IGNORE_TABLE, what side effect may happen?

I don't think by default the mysql database is replicated.

[timsehn]

This collation is in the 1.1.0 release.

[mikelee666]

This collation is in the 1.1.0 release.

thx