MySQL and VARCHAR > 255 character

[awi]

Hi
I try to create a VARCHAR-field in a db-model. I selected as db-type MySQL and now I can create only VARCHAR <= 255 character. But I want create a VARCHAR-field with 1000 character.
I found in the www that older MySQL-versions could max. 255 character, but newer versions over 65thousand.
Have somebody a idee what I can do that EA acept more then 255 character?
Thanks for any help.
andreas

[Paolo F Cantoni]

Hi Awi,

I'd export the datatypes using Tools|Export Reference Data.  Then I'd edit the relevant portion of the XML.  Finally I'd re-import the changed XML.

If you feel braver, you can edit the t_datatypes table directly.

HTH,
Paolo

[awi]

Hi Paolo

Thank you very much. That works fine!  
I changed the xml and after restart EA it was ok.

Andreas