black diamond with question mark to string variable RRS feed

  • Question

  • Hello, 

    I use excel to get data from a small table and update it. 

    Now, the table on SQL have some diamonds with question mark. 

    I got the information from the dba, that it was an error on the importing process regarding ANSI and Unicode. and the table have those invalid characters. 

    Now, when I load the data, I got the same symbol from the table, but when trying to update, when creating the query as a STRING value, it replace this simbol with a quotation mark, and since it was used like: " where data = value", it does not find any data with that value, and the update fail. 

    Could somebody point me to a way to avoid this conversion ?

    Gilberto H.

    Thursday, September 19, 2013 5:29 PM