2 files changed, 66 insertions, 0 deletions

diff --git a/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/CachingCollationMetadataProvider.php b/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/CachingCollationMetadataProvider.php
new file mode 100644
index 0000000..0c99aa3
--- /dev/null
+++ b/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/CachingCollationMetadataProvider.php
@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\Platforms\MySQL\CollationMetadataProvider;
+
+use Doctrine\DBAL\Platforms\MySQL\CollationMetadataProvider;
+
+use function array_key_exists;
+
+/** @internal */
+final class CachingCollationMetadataProvider implements CollationMetadataProvider
+{
+    /** @var array<string,?string> */
+    private array $cache = [];
+
+    public function __construct(private readonly CollationMetadataProvider $collationMetadataProvider)
+    {
+    }
+
+    public function getCollationCharset(string $collation): ?string
+    {
+        if (array_key_exists($collation, $this->cache)) {
+            return $this->cache[$collation];
+        }
+
+        return $this->cache[$collation] = $this->collationMetadataProvider->getCollationCharset($collation);
+    }
+}
diff --git a/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/ConnectionCollationMetadataProvider.php b/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/ConnectionCollationMetadataProvider.php
new file mode 100644
index 0000000..fcd9995
--- /dev/null
+++ b/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/ConnectionCollationMetadataProvider.php
@@ -0,0 +1,37 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\Platforms\MySQL\CollationMetadataProvider;
+
+use Doctrine\DBAL\Connection;
+use Doctrine\DBAL\Exception;
+use Doctrine\DBAL\Platforms\MySQL\CollationMetadataProvider;
+
+/** @internal */
+final class ConnectionCollationMetadataProvider implements CollationMetadataProvider
+{
+    public function __construct(private readonly Connection $connection)
+    {
+    }
+
+    /** @throws Exception */
+    public function getCollationCharset(string $collation): ?string
+    {
+        $charset = $this->connection->fetchOne(
+            <<<'SQL'
+SELECT CHARACTER_SET_NAME
+FROM information_schema.COLLATIONS
+WHERE COLLATION_NAME = ?;
+SQL
+            ,
+            [$collation],
+        );
+
+        if ($charset !== false) {
+            return $charset;
+        }
+
+        return null;
+    }
+}