Skip to content

Instantly share code, notes, and snippets.

@dzarezenko
Forked from vgrichina/SQLServerDialect.java
Created November 4, 2009 00:20
Show Gist options
  • Save dzarezenko/225621 to your computer and use it in GitHub Desktop.
Save dzarezenko/225621 to your computer and use it in GitHub Desktop.
/*
* Copyright © 2009, Componentix. All rights reserved.
*/
package com.componentix.hibernate.dialect;
import java.sql.Types;
/**
* A proper dialect for Microsoft SQL Server 2000 and 2005.
*
* @author Yuri Sakhno (George1)
*/
public class SQLServerDialect extends org.hibernate.dialect.SQLServerDialect {
/**
* Initializes a new instance of the {@link SQLServerDialect} class.
*/
public SQLServerDialect() {
registerColumnType(Types.BIGINT, "bigint");
registerColumnType(Types.BIT, "bit");
registerColumnType(Types.CHAR, "nchar(1)");
registerColumnType(Types.VARCHAR, 4000, "nvarchar($l)");
registerColumnType(Types.VARCHAR, "nvarchar(max)");
registerColumnType(Types.VARBINARY, 4000, "nvarbinary($1)");
registerColumnType(Types.VARBINARY, "nvarbinary(max)");
registerColumnType(Types.BLOB, "nvarbinary(max)");
registerColumnType(Types.CLOB, "nvarchar(max)");
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment