Hibernate version: 3.1

I'm curious about SchemaExport. I have my own hand developed scripts for the different db's we support so it's just curiousity and not necessity.

We store strings in Unicode columns. The different db's have various representations for what to call these. For example, in SQL Server it's NVARCHAR but in Sybase ASA its VARCHAR but the db is created in a different way to store UTF-8 (outside the realm of the create statements).

I realize that I can specify the sql-type in the mapping file but that appears to lock you in to a particular vendor. That is, I don't think that Hibernate interprets the string to do the right thing for a particular db. I believe the assumption is that if you are specifying the sql-type then you want Hibernate to just use it.

Is that correct?

Is there a smart way to do this with Hibernate that I don't understand? I could certainly write something that would stuff the right thing in the mapping files depending upon a dialect that someone gives me but I was wondering what more experienced Hibernate developers might do.

Thank you.

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

I suggest you not to bother with SchemaExport
http://forum.hibernate.org/viewtopic.ph ... highlight=

http://forum.hibernate.org/viewtopic.ph ... highlight=