MySQL and VARCHAR limitation

[eloudsa]

Hello,

I am a brand new user of EA.

I am designing a database model with EA 7.0.817.

The target database for this database model is MySQL 5.0.41.

I would like to define columns with a VARCHAR greater than 255 characters.

Is someone can help me how to configure EA to remove the limitation of 255 characters?

Thanks

Said

[hd]

Save the following code as an xml file....

Code: [Select]

<?xml version="1.0" encoding="UTF-8"?>
<EAPatch>
   <EAPatch.content>
       <PatchDescription>This patch will allow a maximum length of 65,535 for the MySQL VARCHAR datatype.</PatchDescription>
       <PatchQuery> SELECT Count(*) AS NumRecords FROM t_datatypes WHERE Type = 'DDL' AND ProductName = 'MySql' AND DataType = 'VARCHAR';
       </PatchQuery>
       <PatchSQL> UPDATE t_datatypes SET MaxLen = 65535 WHERE Type = 'DDL' AND ProductName = 'MySql' AND DataType = 'VARCHAR'
       </PatchSQL>
   </EAPatch.content>
</EAPatch>

Open your model and run the patch from Tools | Run Patch...

HTH

[«Midnight»]

Thanks Henk,

Will this be handled by an update in the next build or so?

David

[eloudsa]

Thank you very much Henk.

The patch works properly.

As David, I guess that this patch will be delivered in a future update of EA?

Said