You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Thomas Dudziak (JIRA)" <ji...@apache.org> on 2006/05/17 11:27:06 UTC
[jira] Commented: (DDLUTILS-108) Unicode text fields (NTEXT,
NVARCHAR, and NCHAR) for MSSQL
[ 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