AshutoshSrivastavaDev commented on issue #50815:
URL: https://github.com/apache/airflow/issues/50815#issuecomment-2896713386

   @rawwar 
   Would it be appropriate to add collation="utf8_bin" explicitly to the name 
column in the DagTag model to make both parts of the primary key behave 
consistently?
   
   
   `name = Column(String(TAG_MAX_LEN, collation="utf8_bin"), primary_key=True)`
   
   
   Prevent silent primary key conflicts due to casing changes
   
   Make the behavior more predictable
   
   Only affect MySQL/MariaDB (PostgreSQL ignores collation at the column level)
   
   Let me know if this sounds like a safe improvement or if there are edge 
cases to consider.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to