3 ms·

No one talks about the downsides of changing. Moving from 255 max characters to 191 or 192 max means a lot of your data needs to be moved into a text fields wh

by ipaddr 5y ago

No one talks about the downsides of changing. Moving from 255 max characters to 191 or 192 max means a lot of your data needs to be moved into a text fields which means things like this field can't be a primary key.

Pxtl 5y ago
I'm used to mssql where nvarchar (the UTF-16 datatype) supports basically unlimited length... you can't make long PKs in mysql?
- ipaddr 5y ago
  You are limited by smaller types ints, dates and chars.
- cerved 5y ago
  friends don't let friends pk on variable length columns
cerved 5y ago
non numeric primary keys are generally a bad idea can't you specify collation by column?