#573 ✓resolved

Text length can be too long for any RDBMS

Reported by Jonas | September 25th, 2008 @ 11:04 AM

The Text type has been defined as String (Varchar) of 65535. But MySQL can have problems:

"Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions. The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used."

Comments and changes to this ticket

  • Jonas

    Jonas September 25th, 2008 @ 11:33 AM

    This same problem can affect to Csv type since that has been defined so too.

    And I think that woul be best define it using the Text primitive (because it's repeating the same definition of Text).

  • Dan Kubb (dkubb)

    Dan Kubb (dkubb) January 8th, 2009 @ 02:20 PM

    • Tag changed from dm-core, mysql, types to dm-core, mysql, types
    • State changed from “new” to “unconfirmed”
    • Assigned user cleared.
  • Dan Kubb (dkubb)

    Dan Kubb (dkubb) January 8th, 2009 @ 03:09 PM

    • State changed from “unconfirmed” to “resolved”
    • Assigned user set to “Dan Kubb (dkubb)”

    This should be resolved in dkubb/dm-core. The DM::Types::Text object maps to a TEXT field inside the DO adapter.

    Also, the Cvs and Yaml types have been updated to inherit from DM::Types::Text too, so they should also use the TEXT field type.

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

People watching this ticket