[firebird-support] Re: Converting of an ISO8859_1 database to UTF8

2012-11-05 Thread patrick_marten
Hello Martijn, > >> > Regarding 3.1.4 and 3.2.4: I've found this example on how to change the > >> > blob type: > >> > UPDATE RDB$FIELDS SET RDB$FIELD_SUB_TYPE = 0 > >> > WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS > >> > WHERE RDB$FIELD_NAME='SOME_TEXT_BLOB_FIELD' AND

Re: [firebird-support] Re: Converting of an ISO8859_1 database to UTF8

2012-11-05 Thread Martijn Tonies
Hello Patrick, >> > 3.3 Doing everything manually >> > Means probably the most work, but appears to be the safest way at the >> > moment. >> > 3.3.1 I could start with the final UTF8 database, i.e. with all the >> > structure changes etc. included >> > 3.3.2 The source database would be accessed b

[firebird-support] Re: Converting of an ISO8859_1 database to UTF8

2012-11-05 Thread patrick_marten
--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote: > > Hi, > Hi Martijn, thanks for your reply. > > 3.3 Doing everything manually > > Means probably the most work, but appears to be the safest way at the > > moment. > > 3.3.1 I could start with the final UTF8 database, i.e. with

[firebird-support] Re: Converting of an ISO8859_1 database to UTF8

2012-11-05 Thread patrick_marten
--- In firebird-support@yahoogroups.com, "Pierre Y." wrote: > > Not sure but FBClone (via > http://code.google.com/p/fbclone/wiki/ConvertBadEncodedFirebirdDatabases) > could help. > > I embedded its code into my application to provide automagic ISO8859_1 to > UTF8 conversion for my application (i