This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I like to use MEDIUMTEXT or LONGTEXT with a MySQL database. The designer seems to support "string" with a length of 65535 only, which is the TEXT equivalent in MySQL. MEDIUMTEXT holds up to 16,777,215 bytes and LONGTEXT holds up to 4,294,977,295 bytes. TEXT, MEDIUMTEXT and LONGTEXT are non-binary types, which I like to use. Or is BLOG (binary type) the only way the designer supports for this case over all database types? Thanks! |
|
|
|
|
Beginning with the next nightly build, if you specify a string length (using the validation box) that is greater than 65535, we will emit a MEDIUMTEXT or LONGTEXT according to the maximum permitted length. We are open to alternative suggestions for how to represent this so give it a go and let us have your feedback (and of course let us know if you run into any bugs)! |
|
|
|
|
Hi, I need to come back to this topic, because it seems that your announced enhancement is not implemented yet, or I updated the designer in a wrong way (or the files in my project outdated - if so, how do I update the files in the Lib dir?) If I use "String" in the Designer, it can't be greater than 65K. If I set a greater Size, I get the Message to use TEXT or BLOB, but TEXT isn't available, only BLOB. So my question is, how do I handle these Blobs within my code if I want to save a large string to a blog and to read the text from the blob again? Thanks! |
|
|
|
|
This has been implemented. I am not quite clear on where the error message you are reporting is coming from though - can you elaborate on this or post a screenshot of where this is appearing? Here is an example of the SQL we are generating when changing the string length from 50K to 70K (which crosses the 65K boundary where we switch to MEDIUMTEXT): If the field length is no specified then we use TEXT - if it is set to less than 65K then we use a VARCHAR(n). If it is > 65K then we use MEDIUM text up until 16777215 characters where we switch to using LONGTEXT.
|
|
|
|
|
I'm trying to set a very long string so in designer I set <= 1048576000 When I hit "Update Database" menu item, I get "Column length too big for column 'Immagine' (max=65535); use BLOB or TEXT instead" Blob was my first attempt, but it has the 65535 limit too. So, how can I use MEDIUMTEXT, LONGTEXT or LONGBLOB with MySql? |
|
|
|
