I'm converting a database from ANSI to Unicode and did the Reverse
Engineer, adding in ANSI => UNI collation conversion.  The resulting
SQL, while creating correct table create statements, did not convert
any ANSI collation specifications for function or procedure parameters.


--
David Cornelius
CorneliusConcepts.com

David,

<< I'm converting a database from ANSI to Unicode and did the Reverse
Engineer, adding in ANSI => UNI collation conversion.  The resulting SQL,
while creating correct table create statements, did not convert any ANSI
collation specifications for function or procedure parameters. >>

I'll make sure that this is corrected for the next build.

--
Tim Young
Elevate Software
www.elevatesoft.com

> I'll make sure that this is corrected for the next build.

Cool.  Thanks.

I also noticed that Views end up in the SQL before functions.  I
suppose a function could call a view, but I had four views calling a
function!

It wasn't hard to fix for my small database.

--
David Cornelius
CorneliusConcepts.com

David,

<< I also noticed that Views end up in the SQL before functions.  I suppose
a function could call a view, but I had four views calling a function! >>

Yeah, that's a catch-22, and the only way to solve it is to have the
reverse-engineering do a very deep dependency check.  However, this is very
difficult to do "from the outside", so I have to add dependencies to the
catalog tables for this.

--
Tim Young
Elevate Software
www.elevatesoft.com