Post reply

column collation for Spanish and for French

  • December 17, 2014 at 12:33 pm

    #313176

    Hi All

    I have a developer that would like to store a column of data in Spanish and another column of data in French. What collation should I set for each column?

    Thanks

    Kathy

  • December 17, 2014 at 12:58 pm

    #1765269

    The developer is trying to load data from an xml file and he is getting an error of "invalid character was found in text content" The character data that is attempting to be loaded is accented data. I thought by changing the column collation from cs to ci and as to ai would get around this error but he is still getting the same error message.

    Any input --

    Thanks

    Kathy

  • December 17, 2014 at 1:22 pm

    #1765272

    Are you sure the problem is with the column collation and not the XML encoding? I have experienced XML imports from people who banged a bunch of text together and added encoding="UTF-8" to the XML prolog as though it was some kind of magic incantation. They neglected to actually apply UTF-8 encoding to the accented characters.

    Try just doing a SELECT from the XML data and see if you get the error. If so, the error is in the XML.

    If the error does not occur until you try to INSERT, then the target column collation is really the issue. (And no, I don't know what collation to suggest.)

  • December 18, 2014 at 9:15 am

    #1765505

    What we discovered for a solution: We change the default encoding of UTF-8 to UTF-16 and then in the insert code change the varchar to nvarchar. That worked and I didn't need to change collation.

    Thanks

    Kathy

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply