borng / wwwsqldesigner

Automatically exported from code.google.com/p/wwwsqldesigner
BSD 3-Clause "New" or "Revised" License
1 stars 0 forks source link

Big database schemas may not fit into database table (text-column) when saved. #117

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. I reverse engineered a database with lots of tables
2. Saved schema into database
3. Load again fails ... there are only 65.535 characters in text-column. 

What is the expected output? What do you see instead?
No error reported on the GUI about that. Loading that schema just returns a 
blank workarea.

What version of the product are you using? On what operating system?
2.5

Please provide any additional information below.

Solution I'd see:
instead of using a TEXT-datatype (65.535, 2^16 – 1 bytes) use a MEDIUMTEXT  
datatype (16.777.215, 2^24 – 1 bytes)

cheers,
Marcel

Original issue reported on code.google.com by Marcel...@gmail.com on 4 Feb 2011 at 9:47

GoogleCodeExporter commented 9 years ago
Ooops, sorry .... 

I had version 2.4 installed previously and just replaced files to 2.5.
Just saw that in 2.5 the datatype _IS_ already mediumtext.

This is obsolete then :(( Sorry...

Original comment by Marcel...@gmail.com on 4 Feb 2011 at 9:50

GoogleCodeExporter commented 9 years ago

Original comment by ondrej.zara on 4 Feb 2011 at 2:53