Eclipse Community Forums: EclipseLink » DatabasePlatform: convert varchar to nvarchar for ms sql server

Home » Eclipse Projects » EclipseLink » DatabasePlatform: convert varchar to nvarchar for ms sql server(by default, when creating database on sql server, varchar type is created, but in order to support unicode, need nvarchar)

Show: Today's Messages :: Show Polls :: Message Navigator

DatabasePlatform: convert varchar to nvarchar for ms sql server [message #825298]

Tue, 20 March 2012 17:46

Keith Chen

Messages: 2
Registered: March 2012

Junior Member

need help. I am working on a project to use Eclipselink/JPA to create databases across different database platforms. The requirement is that the created database needs to support Unicode. my code runs well on Oracle, Derby, and other types, but on MS sql server, a varchar type is created by Eclipselink by default. In order to support Unicode, I need nvarchar rather than varchar.

I am not very sure how to implement to intervene Eclipselink's default behavior. I am looking at the org.eclipse.persistence.platform.database.MySQLPlatform, and want to override it, but don't know how to do.

Please give some help!

Report message to a moderator

Re: DatabasePlatform: convert varchar to nvarchar for ms sql server [message #829634 is a reply to message #825298]

Mon, 26 March 2012 15:23

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

In the buildFieldTypes() method change String to map to NVARCHAR instead of VARCHAR.
You can subclass MySQLPlatform with your own class and specify it as your target-database in your persistence.xml.

You could also specify the columnDefinition on your JPA @Column annotation.

James : Wiki : Book : Blog : Twitter

Report message to a moderator