french character

  • if I insert some french character into the database like.

    insert into names (fname, lname) values( 'wei','Québec' );

    it always complains:

    PostgreSQL query failed: ERROR: Invalid UNICODE character sequence found (0xe96265)

    how to solve this problem.

  • Do you have unicode enabled on PostgreSQL? I don't work with Postgre but I beliueve UTF8 has to be enabled to be able to insert unicode values otherwise ASCII is encforced. Also post these type items in the "Anything that is NOT about SQL!" as this site is about MS SQL Server. You might also try dbfourms.com.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

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