bug #21323 [Cache] [PdoAdapter] Fix MySQL 1170 error (blob as primary key) (akeeman)
bug #21323 [Cache] [PdoAdapter] Fix MySQL 1170 error (blob as primary key) (akeeman)

This PR was submitted for the master branch but it was merged into the 3.2 branch instead (closes #21323).

Discussion
----------

[Cache] [PdoAdapter] Fix MySQL 1170 error (blob as primary key)

| Q             | A
| ------------- | ---
| Branch?       | 3.2
| Bug fix?      | yes
| New feature?  | no
| BC breaks?    | no
| Deprecations? | no
| Tests pass?   | n/a
| Fixed tickets | n/a
| License       | MIT
| Doc PR        | n/a

When using a Doctrine\DBAL\Connection to initialize the PdoAdapter, PdoAdapter::createTable tries to create a table using a blob field as primary key. [This is not an option for MySQL](https://techjourney.net/mysql-error-1170-42000-blobtext-column-used-in-key-specification-without-a-key-length/), resulting in an exeption: `Syntax error or access violation: 1170 BLOB/TEXT column 'item_id' used in key specification without a key length`. This commit supplies a way to act like the non-Connection way creates the table does.

Commits
-------

08c6a650b9 [Cache] [PdoAdapter] Fix MySQL 1170 error (blob as primary key)

ajgarlag/symfony,ogizanagi/symfony,MatTheCat/symfony,gencer/symfony,andreia/symfony,jjanvier/symfony,zorn-v/symfony,michaelperrin/symfony,nicolas-grekas/symfony,voronkovich/symfony,ro0NL/symfony,vincentaubert/symfony,yceruto/symfony,Amo/symfony,jjanvier/symfony,zorn-v/symfony,jderusse/symfony,nasimnabavi/symfony,bendavies/symfony,voronkovich/symfony,ro0NL/symfony,d-ph/symfony,sstok/symfony,fabpot/symfony,damienalexandre/symfony,Slamdunk/symfony,zerkms/symfony,ro0NL/symfony,Nyholm/symfony,dzuelke/symfony,Tobion/symfony,oleg-andreyev/symfony,sgehrig/symfony,chrisguitarguy/symfony,jvasseur/symfony,chrisguitarguy/symfony,Engerim/symfony,ragboyjr/symfony,Taluu/symfony,Strate/symfony,arjenm/symfony,dzuelke/symfony,Triiistan/symfony,bendavies/symfony,klandaika/symfony,okdana/symfony,weaverryan/symfony,docteurklein/symfony,pierredup/symfony,Nyholm/symfony,lstrojny/symfony,michaelperrin/symfony,lepiaf/symfony,tucksaun/symfony,Triiistan/symfony,lstrojny/symfony,lyrixx/symfony,hason/symfony,e-moe/symfony,zcodes/symfony,DavidGarciaCat/symfony,derrabus/symfony,romaricdrigon/symfony,csarrazi/symfony,jzawadzki/symfony,jean-gui/symfony,tgalopin/symfony,frankdejonge/symfony,zerkms/symfony,aeoris/symfony,aeoris/symfony,frankdejonge/symfony,sgehrig/symfony,Koc/symfony,ragboyjr/symfony,vincentaubert/symfony,codeclimate-testing/symfony,hhamon/symfony,jvasseur/symfony,klandaika/symfony,josephdpurcell/symfony,jderusse/symfony,pyrech/symfony,gimler/symfony,1ed/symfony,chrisguitarguy/symfony,dmaicher/symfony,iltar/symfony,iltar/symfony,Aliance/symfony,Strate/symfony,vincentaubert/symfony,HeahDude/symfony,dunglas/symfony,Amo/symfony,jderusse/symfony,gonzalovilaseca/symfony,lyrixx/symfony,paradajozsef/symfony,pyrech/symfony,phramz/symfony,oleg-andreyev/symfony,deguif/symfony,klandaika/symfony,shieldo/symfony,kbond/symfony,zcodes/symfony,nasimnabavi/symfony,symfony/symfony,gnat42/symfony,jjanvier/symfony,joelwurtz/symfony,joelwurtz/symfony,mweimerskirch/symfony,shieldo/symfony,csarrazi/symfony,mpdude/symfony,jean-gui/symfony,OskarStark/symfony,Simperfit/symfony,alekitto/symfony,codeclimate-testing/symfony,Triiistan/symfony,c960657/symfony,chalasr/symfony,Tobion/symfony,josephdpurcell/symfony,gnat42/symfony,dzuelke/symfony,localheinz/symfony,joelwurtz/symfony,neemzy/symfony,hhamon/symfony,gonzalovilaseca/symfony,codeclimate-testing/symfony,pamil/symfony,bendavies/symfony,gencer/symfony,nasimnabavi/symfony,nasimnabavi/symfony,hacfi/symfony,Pierstoval/symfony,lepiaf/symfony,jzawadzki/symfony,OskarStark/symfony,michaelperrin/symfony,chalasr/symfony,xabbuh/symfony,alekitto/symfony,ogizanagi/symfony,mnapoli/symfony,sroze/symfony,Nyholm/symfony,pierredup/symfony,Koc/symfony,Nyholm/symfony,derrabus/symfony,xabbuh/symfony,frankdejonge/symfony,deguif/symfony,arjenm/symfony,andrerom/symfony,WhiteEagle88/symfony,oleg-andreyev/symfony,sstok/symfony,mpdude/symfony,jjanvier/symfony,curry684/symfony,docteurklein/symfony,csarrazi/symfony,zerkms/symfony,andreia/symfony,Deamon/symfony,weaverryan/symfony,chalasr/symfony,ajgarlag/symfony,apfelbox/symfony,hason/symfony,DavidGarciaCat/symfony,voronkovich/symfony,apfelbox/symfony,tucksaun/symfony,alekitto/symfony,lyrixx/symfony,ogizanagi/symfony,xabbuh/symfony,Simperfit/symfony,DavidGarciaCat/symfony,stof/symfony,jakzal/symfony,apetitpa/symfony,WhiteEagle88/symfony,MatTheCat/symfony,mweimerskirch/symfony,ogizanagi/symfony,gonzalovilaseca/symfony,phramz/symfony,mnapoli/symfony,apfelbox/symfony,backbone87/symfony,docteurklein/symfony,Engerim/symfony,docteurklein/symfony,jvasseur/symfony,dunglas/symfony,d-ph/symfony,zcodes/symfony,sstok/symfony,pierredup/symfony,apetitpa/symfony,bendavies/symfony,teohhanhui/symfony,d-ph/symfony,arjenm/symfony,tucksaun/symfony,zorn-v/symfony,fabpot/symfony,backbone87/symfony,mnapoli/symfony,apetitpa/symfony,okdana/symfony,Taluu/symfony,shieldo/symfony,HeahDude/symfony,Simperfit/symfony,pamil/symfony,smatyas/symfony,apfelbox/symfony,smatyas/symfony,ragboyjr/symfony,e-moe/symfony,Einenlum/symfony,lstrojny/symfony,sgehrig/symfony,apfelbox/symfony,romainneutron/symfony,OskarStark/symfony,neemzy/symfony,garak/symfony,c960657/symfony,c960657/symfony,gonzalovilaseca/symfony,tgalopin/symfony,WhiteEagle88/symfony,Amo/symfony,symfony/symfony,pyrech/symfony,romaricdrigon/symfony,lepiaf/symfony,Deamon/symfony,localheinz/symfony,Deamon/symfony,tgalopin/symfony,dzuelke/symfony,Koc/symfony,andrerom/symfony,ajgarlag/symfony,Pierstoval/symfony,c960657/symfony,oleg-andreyev/symfony,HeahDude/symfony,tgalopin/symfony,alekitto/symfony,apetitpa/symfony,sgehrig/symfony,Deamon/symfony,symfony/symfony,romainneutron/symfony,romainneutron/symfony,Triiistan/symfony,OskarStark/symfony,Pierstoval/symfony,Deamon/symfony,backbone87/symfony,romaricdrigon/symfony,pyrech/symfony,HeahDude/symfony,okdana/symfony,shieldo/symfony,damienalexandre/symfony,localheinz/symfony,ro0NL/symfony,deguif/symfony,gnat42/symfony,mpdude/symfony,andrerom/symfony,jvasseur/symfony,stof/symfony,klandaika/symfony,Triiistan/symfony,gnat42/symfony,zorn-v/symfony,smatyas/symfony,sroze/symfony,Einenlum/symfony,mpdude/symfony,andreia/symfony,yceruto/symfony,Einenlum/symfony,1ed/symfony,dmaicher/symfony,hason/symfony,e-moe/symfony,tucksaun/symfony,jderusse/symfony,1ed/symfony,ragboyjr/symfony,phramz/symfony,Tobion/symfony,nicolas-grekas/symfony,kbond/symfony,Tobion/symfony,derrabus/symfony,Engerim/symfony,weaverryan/symfony,Pierstoval/symfony,damienalexandre/symfony,curry684/symfony,voronkovich/symfony,gencer/symfony,mweimerskirch/symfony,curry684/symfony,josephdpurcell/symfony,gimler/symfony,MatTheCat/symfony,michaelperrin/symfony,docteurklein/symfony,dunglas/symfony,gimler/symfony,romainneutron/symfony,maidmaid/symfony,zcodes/symfony,maidmaid/symfony,arjenm/symfony,klandaika/symfony,dmaicher/symfony,pamil/symfony,dmaicher/symfony,hhamon/symfony,sstok/symfony,romaricdrigon/symfony,e-moe/symfony,sroze/symfony,localheinz/symfony,mnapoli/symfony,Taluu/symfony,aeoris/symfony,paradajozsef/symfony,jzawadzki/symfony,paradajozsef/symfony,jakzal/symfony,Aliance/symfony,weaverryan/symfony,vincentaubert/symfony,kbond/symfony,fabpot/symfony,d-ph/symfony,frankdejonge/symfony,smatyas/symfony,derrabus/symfony,Slamdunk/symfony,Simperfit/symfony,MatTheCat/symfony,gimler/symfony,ajgarlag/symfony,jakzal/symfony,Einenlum/symfony,curry684/symfony,chrisguitarguy/symfony,stof/symfony,stof/symfony,jean-gui/symfony,maidmaid/symfony,nicolas-grekas/symfony,yceruto/symfony,Simperfit/symfony,Taluu/symfony,iltar/symfony,pierredup/symfony,maidmaid/symfony,damienalexandre/symfony,nicolas-grekas/symfony,Amo/symfony,mweimerskirch/symfony,1ed/symfony,dzuelke/symfony,teohhanhui/symfony,jean-gui/symfony,Slamdunk/symfony,yceruto/symfony,fabpot/symfony,mweimerskirch/symfony,zerkms/symfony,teohhanhui/symfony,sroze/symfony,neemzy/symfony,paradajozsef/symfony,garak/symfony,hacfi/symfony,symfony/symfony,mnapoli/symfony,Slamdunk/symfony,Aliance/symfony,romainneutron/symfony,phramz/symfony,chrisguitarguy/symfony,hhamon/symfony,chalasr/symfony,teohhanhui/symfony,pamil/symfony,Koc/symfony,joelwurtz/symfony,andrerom/symfony,xabbuh/symfony,Amo/symfony,kbond/symfony,iltar/symfony,hacfi/symfony,deguif/symfony,lyrixx/symfony,smatyas/symfony,jjanvier/symfony,jakzal/symfony,sstok/symfony,garak/symfony,Strate/symfony,andreia/symfony,codeclimate-testing/symfony,garak/symfony