Hi,

I have not tried this on Informix, but on Sybase, Oracle and MS-SQL.

Remedy counts bytes, so the 255-byte character field will still be 255
bytes long.

The problem is when you migrate your data, where a 255-character string
will not allways fit in 255-bytes. In 99% of the cases, the string will
probably fit, but you will have problems with some data.

In this case you can choose to either truncate your data, or extend the
field length sligthly.

If you go from cp-1257, I think that most of the characters above code 127
will fit in two bytes. When I have converted Swedish systems, very few
records has needed more than 10% extra space.

The strategy I have most commonly used, on custom applications, is the
following:
1. Character fields > 128 characters or so, truncate the data in the
source database before transfer
2. Character fields < 128 characters, extend the target field size by 1
byte when the merge-operation fails for certain records, and merge again

        Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> Hi,
>
> I've got the question about Remedy (7.5) and Informix (utf8).
> We are going to migrate the workflow and data from Remedy 7.1 (Informix
> cp-1257) to Remedy 7.5 (Informix utf8).
> As far as I know the ARS 7.5 allows to set the Length Unit to Characters
> (not Bytes). What will happen with data if the Length Unit will be changed
> to Characters?
> For example, if the character field's lenght in ARS 7.1 was 255 and it was
> possible to include this field in the query's qualification, does it mean
> that the field's length in ARS 7.5 automatically will be 255*4 and the
> search will not be allowed without FTS?
>
> Best regards,
> Irina
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Reply via email to