• 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?


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/