Wow~~~ You're the man, Marc! The problem is resolved!
On 1/31/07, Marc Prud'hommeaux <[EMAIL PROTECTED]> wrote:
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
>>
>>
