search

dbcodeio / public

The Power of Databases, The Convenience of VS Code: All in One Place
29 stars 1 forks source link

mysql introspection error #24

Closed devpkr1 closed 1 month ago

devpkr1 commented 1 month ago

Error: Illegal mix of collations (utf8mb4_0900_ai_ci,COERCIBLE) and (utf8mb4_unicode_ci,COERCIBLE) for operation '='

VSCode Version: 1.93.1 Extension Version: 1.2.8 OS: win32 Arch: x64

mikeburgh commented 1 month ago

Interesting.. would you mind running the following query and sharing the results ? Also which version of MySQL are you using ? (I need to get that information added to the default ticket template)

SELECT 
    TABLE_SCHEMA
    , TABLE_NAME
    , TABLE_COLLATION 
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'information_schema'
devpkr1 commented 1 month ago

Result of the query is attached as CSV file

and the MySQL version : - MySQL 9.0.1

On Mon, Sep 30, 2024 at 6:29 AM mikeburgh @.***> wrote:

Interesting.. would you mind running the following query and sharing the results ? Also which version of MySQL are you using ? (I need to get that information added to the default ticket template)

SELECT TABLE_SCHEMA , TABLE_NAME , TABLE_COLLATION FROM INFORMATION_SCHEMA.TABLESWHERE TABLE_SCHEMA = 'information_schema'

— Reply to this email directly, view it on GitHub https://github.com/dbcodeio/public/issues/24#issuecomment-2381800224, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHX3Z5OUKGHK5W3R3TIYXSLZZCO6PAVCNFSM6AAAAABPBUHN5OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGOBRHAYDAMRSGQ . You are receiving this because you authored the thread.Message ID: @.***>

mikeburgh commented 1 month ago

Looks like github did not pick the attachment up.. you can email it to help@dbcode.io and I can get it from there.

mikeburgh commented 1 month ago

Thanks, I got the file. I was not expecting the collation columns to be null.. interesting.

I just pushed a pre release version, can you switch to it and see if it fixes the issue for you ?

devpkr1 commented 1 month ago

Hi mikeburgh,

Yes it fixes the issue , it's working for me now.

Thanks for your kind support.

Regards, Pradeep Kumar

On Wed, Oct 2, 2024 at 2:38 AM mikeburgh @.***> wrote:

Thanks, I got the file. I was not expecting the collation columns to be null.. interesting.

I just pushed a pre release version, can you switch to it and see if it fixes the issue for you ?

— Reply to this email directly, view it on GitHub https://github.com/dbcodeio/public/issues/24#issuecomment-2387079299, or unsubscribe https://github.com/notifications/unsubscribe-auth/BHX3Z5I7ZLYEGQUOZX43FGDZZMFMLAVCNFSM6AAAAABPBUHN5OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGOBXGA3TSMRZHE . You are receiving this because you authored the thread.Message ID: @.***>

mikeburgh commented 1 month ago

Great, will close this ticket now.. a regular release will be out later this week which will include this fix.