Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
reverse engineer collation conversion |
Sun, Nov 22 2009 8:46 PM | Permanent Link |
"David Cornelius" | 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 |
Sun, Nov 22 2009 9:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.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 |
Sun, Nov 22 2009 11:14 PM | Permanent Link |
"David Cornelius" | > 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 |
Mon, Nov 23 2009 3:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |