db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-108) Unicode text fields (NTEXT, NVARCHAR, and NCHAR) for MSSQL
Date Wed, 17 May 2006 09:27:06 GMT
    [ http://issues.apache.org/jira/browse/DDLUTILS-108?page=comments#action_12412129 ] 

Thomas Dudziak commented on DDLUTILS-108:
-----------------------------------------

There are several ways to support N* datatypes for Oracle, Sql Server etc.:

* A DdlUtils-wide useUnicodeDatatypes (or a similar name) setting, which directs DdlUtils
to use the N* variant for CHAR/VARCHAR/LONGVARCHAR/CLOB wherever possible.

* A type override mechanism that allows to user to specify the native type. With this, you
could specify NTEXT for a specific column.

* A encoding attribute for columns which may contain values like DEFAULT, UNICODE, but also
specific encodings like LATIN1. The first two would have the same effect as the first solution
above, but limited to this column. The other values might be used by databases that support
setting the collation locale on the column level.

The first one can be implemented without much hassle (no need to create patch, I have it largely
worked out on paper), but the other two require a change in the DTD and the model, and thus
I won't be implementing them in the 1.0.

> Unicode text fields (NTEXT, NVARCHAR, and NCHAR) for MSSQL
> ----------------------------------------------------------
>
>          Key: DDLUTILS-108
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-108
>      Project: DdlUtils
>         Type: Improvement

>   Components: Core
>  Environment: Microsoft SQL Server
>     Reporter: Christoffer Hammarström
>     Assignee: Thomas Dudziak

>
> I need to be able to store (for example) the contents of http://www.cl.cam.ac.uk/~mgk25/ucs/examples/UTF-8-demo.txt
in an NTEXT field in an SQL Server database generated with ddlutils.
> I'll try to make a patch.
> Hibernate does it using another "dialect", which is analogous to a ddlutils "platform",
if i understand correctly: http://confluence.atlassian.com/display/DOC/MSSQL+Tips#MSSQLTips-MSSQLandUnicode.
> I'm thinking of two possibilites: either a new platform like hibernate called something
like "unicodemssql" (?), or some way to send a parameter into the MSSqlPlatform or MSSqlBuilder.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message