| Subject | Re: ODP: FB 3 issues with String from FB 2.54 |
|---|---|
| Author | Fabian Ernesto Chocron |
| Post date | 2016-05-24T15:58:02Z |
liviuslivius liviuslivius <at> poczta.onet.pl [firebird-support]
<firebird-support <at> yahoogroups.com> writes:
yahoogroups.com> Data: 23.05.2016 03:45 (GMT+01:00) Do: firebird-
support <at> yahoogroups.com Temat: [firebird-support] FB 3 issues with
String from FB 2.54
point where I do understand the issue, but I don't know how to solve it.
The issue is pretty simple, the FB 2.54 DB contains a few characters
that are not allowed into the FB 3 database, one example of a character
causing an error during the restore was "Mcgarrity’s" (note the ’) as it
appears to be outside the scope of the FB3 string domain, I have trying
creating a new FB3 DB with many different charsets but none works. The
other string causing issues is for example "΢ÈíÑźÚ", I have many
records with this type of strings because the DB contains raw emails
received by the system, stored into Varchars, and apparently some emails
contain very weird characters, all were handled by FB2.54 but FB3
rejects the records. I have been able to isolate all recrods with issues
using IBExpert's table data comparer function, as it created a script
with all recrods from all tables from FB2.54 and when running the script
against FB3.0 it singles out all the offending records.
After playing with the problem for a while I noticed the definition of
the field was Varchar (8192) charset ASCII collate ASCII, so that was
probably causing the problem. I changed the domain settings to be
Charset NONE, Collate NONE, and that fixed the issue!
Cheers,
Fabian
<firebird-support <at> yahoogroups.com> writes:
>octets...
>
>
>
>
>
> hi,
>
> will be good to know which charsets did you tried. utf8, none,
>itbizolutions.com.au [firebird-support]" <firebird-support <at>
> but remember to connet to db also with this charset settings
>
> regards,
> Karol Bieniaszewski
> -------- Oryginalna wiadomość --------Od: "fabianch <at>
yahoogroups.com> Data: 23.05.2016 03:45 (GMT+01:00) Do: firebird-
support <at> yahoogroups.com Temat: [firebird-support] FB 3 issues with
String from FB 2.54
>and after hitting a string related error for some time i have got to the
>
>
>
>
>
>
> Hi All
>
> I have been trying to migrate from FB2.54 into FB 3 for a few weeks,
point where I do understand the issue, but I don't know how to solve it.
The issue is pretty simple, the FB 2.54 DB contains a few characters
that are not allowed into the FB 3 database, one example of a character
causing an error during the restore was "Mcgarrity’s" (note the ’) as it
appears to be outside the scope of the FB3 string domain, I have trying
creating a new FB3 DB with many different charsets but none works. The
other string causing issues is for example "΢ÈíÑźÚ", I have many
records with this type of strings because the DB contains raw emails
received by the system, stored into Varchars, and apparently some emails
contain very weird characters, all were handled by FB2.54 but FB3
rejects the records. I have been able to isolate all recrods with issues
using IBExpert's table data comparer function, as it created a script
with all recrods from all tables from FB2.54 and when running the script
against FB3.0 it singles out all the offending records.
>accept any stuff into string fields?
> Can anyone advise what options I have available to force FB3.0 to
>Hi Karol
>
> Thanks in advanced
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
After playing with the problem for a while I noticed the definition of
the field was Varchar (8192) charset ASCII collate ASCII, so that was
probably causing the problem. I changed the domain settings to be
Charset NONE, Collate NONE, and that fixed the issue!
Cheers,
Fabian