William-
If you wanted to have all your varchar columns be specified as
"varchar(SIZE) COLLATE French_CI_AS", you could specify the property:
openjpa.jdbc.DBDictionary: VarcharTypeName="varchar{0} COLLATE
French_CI_AS"
On Jan 31, 2007, at 12:39 AM, William Cai wrote:
Marc,
In SQL Server, we specify Collation with below code. Therefore, we
can't set
the option in "type-name". In our project, there are hundreds of
columns
need case-sensitive collation support. It's really painful to set
all of
them in generated script. The best solution is custom
SQLServerDictionary.
I'll try it. Perhaps we need improve SQLServerDictionary at a
point. :-)
Thanks a lot for your help.
CREATE TABLE MyTable
(PrimaryKey int PRIMARY KEY,
CharCol varchar(10) COLLATE French_CI_AS NOT NULL
)
GO
On 1/31/07, Marc Prud'hommeaux <[EMAIL PROTECTED]> wrote:
William-
I don't know how you specify collation, but if it is expressible via
the column type name, you could always set the "type-name" of the
column in the schema file (e.g., setting the type-name to be "VARCHAR
WITH ASCII COLLATION").
If it needs to be specific in the "CREATE TABLE" part, then the
schematool doesn't have any built-in way to alter that. However, you
can always make a custom subclass of the SQLServerDictionary and
override the "public String[] getCreateTableSQL(Table table)" method,
and make it do whatever you want.
Lastly, you could always use the default SQL generated by the
schematool, and then just follow up with some custom SQL that issues
"ALTER TABLE" statements that change whatever attributes of the
tables you want.
On Jan 30, 2007, at 10:48 PM, William Cai wrote:
> Folks,
> I used SchemaTool to create tables in MS SQL Server, but the schema
> file
> structure is pretty simple, so some SQL Server specific setting
> can't be set
> with SchemaTool. Does SchemaTool allow custom extension so that I
> can create
> a table with collation setting in MS SQL?
>
> Thanks,
> William
