support nvarchar in sql sync

gettes
ok - well - i tried grabbing a table that has "nvarchar" data type in it and I got the following error from sql sync:
java.lang.RuntimeException: finalLog: true, state: init, sync: sqlTableSync, provisionerName: adpersons_sync, syncType: fullSyncFull, exception: java.lang.RuntimeException: java.lang.RuntimeException: Type not supported: -9, nvarchar,
sql: select * from dbo.ADPersons where 1!=1, ,
Error finding metadata for 'select * from dbo.ADPersons where 1!=1' in database: 'MSIAM'
at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2362)
at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveQueryMetadataFromDatabase(GcTableSyncTableMetadata.java:309)
at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveQueryMetadataFromDatabase(GcTableSyncTableMetadata.java:255)
at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveTableMetadataFromDatabase(GcTableSyncTableMetadata.java:243)
at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveTableMetadataFromCacheOrDatabase(GcTableSyncTableMetadata.java:225)
at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableBean.configureMetadata(GcTableSyncTableBean.java:58)
at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync.sync(GcTableSync.java:308)
at edu.internet2.middleware.grouper.app.tableSync.TableSyncOtherJob.run(TableSyncOtherJob.java:69)
at edu.internet2.middleware.grouper.app.loader.OtherJobBase$2.callback(OtherJobBase.java:439)
at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1000)
at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1069)
at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1036)
at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:392)
at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:376)
at edu.internet2.middleware.grouper.app.loader.GrouperDaemonJob.execute(GrouperDaemonJob.java:57)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: java.lang.RuntimeException: Type not supported: -9, nvarchar,
sql: select * from dbo.ADPersons where 1!=1,
at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata$1.callback(GcTableSyncTableMetadata.java:370)
at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2358)
... 16 more
, queryCount: 2, tookMillis: 188, took: 0:00:00.188
at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync.sync(GcTableSync.java:578)
at edu.internet2.middleware.grouper.app.tableSync.TableSyncOtherJob.run(TableSyncOtherJob.java:69)
at edu.internet2.middleware.grouper.app.loader.OtherJobBase$2.callback(OtherJobBase.java:439)
at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1000)
at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1069)
at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1036)
at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:392)
at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:376)
at edu.internet2.middleware.grouper.app.loader.GrouperDaemonJob.execute(GrouperDaemonJob.java:57)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
5:54
if this ends up being hard to fix - lemme know.  i will find another way.  i will put the DDL below.
5:54
CREATE TABLE [dbo].[ADPersons] (
    [Id] int IDENTITY(1,1) NOT NULL,
    [BUT_LID] nvarchar(max)  NOT NULL,
    [cn] nvarchar(max)  NOT NULL,
    [co] nvarchar(max)  NULL,
    [department] nvarchar(max)  NULL,
    [description] nvarchar(max)  NULL,
    [displayName] nvarchar(max)  NULL,
    [employeeID] int  NULL,
    [employeeType] nvarchar(max)  NULL,
    [givenName] nvarchar(max)  NULL,
    [initials] nvarchar(max)  NULL,
    [l] nvarchar(max)  NULL,
    [manager] nvarchar(max)  NULL,
    [mailNickname] nvarchar(max)  NULL,
    [ADObjectType] nvarchar(max)  NULL,
    [objectSid] nvarchar(max)  NULL,
    [jpegPhoto] nvarchar(max)  NULL,
    [thumbnailPhoto] nvarchar(max)  NULL,
    [physicalDeliveryOfficeName] nvarchar(max)  NULL,
    [postalCode] nvarchar(max)  NULL,
    [proxyAddressCollection] nvarchar(max)  NULL,
    [sn] nvarchar(max)  NULL,
    [st] nvarchar(max)  NULL,
    [streetAddress] nvarchar(max)  NULL,
    [telephoneNumber] nvarchar(max)  NULL,
    [title] nvarchar(max)  NULL,
    [uidNumber] bigint  NULL,
    [WINBUT_UUID] int  NULL,
    [EXCHBUT_UUID] int  NULL,
    [MAILBUT_UUIDs] nvarchar(max)  NULL,
    [BUT_SID] int  NULL,
    [targetAddress] nvarchar(max)  NULL,
    [HAS_EXCHANGE] nvarchar(max)  NULL,
    [departmentNumber] int  NULL,
    [company] nvarchar(max)  NULL,
    [OWNER_EMAIL] nvarchar(max)  NULL,
    [buildingName] nvarchar(max)  NULL,
    [roomNumber] nvarchar(max)  NULL,
    [gidNumber] bigint  NULL,
    [HAS_UNIX] bit  NULL
);
Today