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
