• Hugo Kornelis (4/29/2010)


    stewartc-708166 (4/29/2010)


    Hugo Kornelis (4/29/2010)


    I got it right, because of elimination, but I don't understand the entire scenario.

    Since the destination column is NVARCHAR(26), how can a value be outside the codepage range? I though codepages were relevant for non-Unicode data only?

    in the situation that gave rise to this question, CODEPOINT identified the value of the character as 65533.

    As far as I am aware, there is no charater (in any character set, albeit unicode or non-unicode) with that value.

    So that was a bug in the mainframe program that exportet the file, then?

    that is correct.

    identifying the record and referring it to the custodian facilitated the extract to be rectified.

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”