[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-1184) Using SQLServerDialect, the DDL generated has wrong length(..) for strings! Defaults char(255)!

[Colbert Philippe (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-1184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=42424#action_42424 ] 

Colbert Philippe commented on HBX-1184:
---------------------------------------

The test case is rather simple.

1)  Create a simple class with 4 different strings of different lengthes. 
Let's say 16, 32, 64, 128

2) Using the dialect org.hibernate.dialect.SQLServerDialect, generate the 
DDL for that single class.

Look at the length of the strings for that class in the DDL.

Based on my results either the string length does not appear or it appears 
with length = 255.

This problem occurs in Hibernate Core version 3.6.4

I was using the MySQL dialect previously and I did not experience this problem.

> Using SQLServerDialect, the DDL generated has wrong length(..) for strings!  Defaults char(255)!
> ------------------------------------------------------------------------------------------------
>
>                 Key: HBX-1184
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1184
>             Project: Hibernate Tools
>          Issue Type: Bug
>         Environment: Windows 7
>            Reporter: Colbert Philippe
>            Assignee: Hardy Ferentschik
>
> I am using Microsoft SQL Azure as database, which is Microsoft SQL Server.   I use the dialect class org.hibernate.dialect.SQLServerDialect as indicated in the manual.
> I have carefully specified the length (attribute length()) of my strings in each hbm.xml file of my project.   However, I noticed that the database uses a default 255 length for all strings in all classes of my project.   That's wrong!    
> I tried creating a class with a string attribute by hand, that works.   The string has the proper length that I specified in my DDL.
> Clearly there is an error in the generation of my DDL from class org.hibernate.dialect.SQLServerDialect..   It's a major error.

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira