[BUG]: Unable to create MySQL foreign string keys

[ElPrudi]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.40.0

What version of drizzle-kit are you using?

0.35.0

Other packages

mysql2 3.13.0

Describe the Bug

While number foreign keys work (int().autoincrement()...), applying the same thing to char, varchar or text will result in this error:

Error: Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'Note_user_id_User_id_fk' are incompatible.
    at PromiseConnection.execute (<project>/node_modules/.pnpm/mysql2@3.13.0/node_modules/mysql2/lib/promise/connection.js:47:22)
    at Object.query (<project>/node_modules/.pnpm/drizzle-kit@0.30.5/node_modules/drizzle-kit/bin.cjs:78651:40)
    at mysqlPush (<project>/node_modules/.pnpm/drizzle-kit@0.30.5/node_modules/drizzle-kit/bin.cjs:81763:22)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async Object.handler (<project>/node_modules/.pnpm/drizzle-kit@0.30.5/node_modules/drizzle-kit/bin.cjs:92124:9)
    at async run (<project>/node_modules/.pnpm/drizzle-kit@0.30.5/node_modules/drizzle-kit/bin.cjs:91395:7) {
  code: 'ER_FK_INCOMPATIBLE_COLUMNS',
  errno: 3780,
  sql: 'ALTER TABLE `Note` MODIFY COLUMN `user_id` varchar(24) COLLATE ascii_bin NOT NULL;',
  sqlState: 'HY000',
  sqlMessage: "Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'Note_user_id_User_id_fk' are incompatible."
}

My drizzle schemas:

import { mysqlTable char } from 'drizzle-orm/mysql-core'
import { createId } from '@paralleldrive/cuid2'

function id() {
  return char('id', { length: 24 }).primaryKey().$defaultFn(createId)
}

export const user = mysqlTable(
  'User',
  {
    id: id()
  }
)

export const note = mysqlTable(
  'Note',
  {
    id: id(),
    userId: char('user_id', { length: 24 }).references(() => user.id).notNull()
  }
)

The generated SQL also gives no clue on why it fails, because all values are char(24) NOT NULL. I tried collating found here, but this also didn't work.