20.02.2018 16:36, dco...@sympatico.ca [firebird-support] wrote: > I've Googled a lot about this and that -FIX_FSS_DATA option seems to only > really be > relevant when restoring DBs from much earlier versions of FB - but this is > from the same > version!
Version of engine doesn't matter in this case. ODS does. ODS used in 2.0.1 allowed malformed string literals in stored objects and data tables, ODS for 2.5 prohibit that. If you see this error, it means that you'd better migrate database between version by creation of brand new database from script and then pump data from old database. During this process you'll encounter errors that you must fix by changing script or source database. -FIX_* switches must be used very carefully by experienced DBA only. In wrong hands they will lead to data corruption beyond recovery. -- WBR, SD. ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/