french character

• crab7

  Mr or Mrs. 500

  Points: 548

  More actions

  June 20, 2002 at 12:32 pm

  #58081

  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.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 20, 2002 at 5:02 pm

  #431318

  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)