can someone help me what this error all about? RRS feed

  • Question

  • hi everyone, im on this project that extracts data from the xml file and then stores this data to a postgres database. i'm using c# to do this and my "link" to c# and the database is a microsoft odbc driver...

    now my problem is, everytime i update my database with a query involving data with japanese or extended latin characters, i always encounters this error...(below)

    Microsoft.Data.Odbc.OdbcException: ERROR [22021] ERROR: invalid byte value for encoding "SQL_ASCII": 0xb1;
    Error while executing the query

    note: if i try to execute a query in the database itself, the query will work. yet if i use c#, cast the query as a string, then pass the string to the ExecuteQuery method, then the error will come out... :(

    up until now, i still haven't got a clue on how to fix this. help me please
    • Moved by jack 321 Monday, June 9, 2008 7:22 AM off topic for C# general
    Thursday, June 5, 2008 12:47 AM


All replies