[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c...
]
Alexandra Wamb commented on HHH-3240:
-------------------------------------
I still don't get why TEXT is mapped to LONGVARCHAR. The derby reference in regard to
LONGVARCHAR says that it is restricted to 32,700 characters
(
http://db.apache.org/derby/docs/10.5/ref/rrefsqlj15147.html).
To my knowledge TEXT in the domain of SQL allows two giga of characters. And this is
exactly the amount of characters that CLOB in derby offers
(
http://db.apache.org/derby/docs/10.5/ref/rrefclob.html).
So is there any reason why TEXT is mapped to LONGVARCHAR and not CLOB?
Thanks
In Derby field type 'text' is converted to CLOB(255)
----------------------------------------------------
Key: HHH-3240
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1
Environment: Hibernate 3.1, Derby 10.3.2.1
Reporter: Aleksander Rozman
Fix For: 3.5.0.Beta-1, 3.5.0-Beta-2, 3.5
When using type 'text' this is incorectly converted to CLOB(255). Derby has
several long var char types which could be used instead, but instead it's defaulted to
clob(255).
I have taken a look at source from 3.1 and 3.2.6 (latest) and this code is still the
same... I think that just little fix in DerbyDialect would be enough... I would try this
myself but I am currently lacking time and resources.
I hope this will be taken care of as soon as it gets...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira