The following bug has been logged online: Bug reference: 2149 Logged by: Abigail Corrigan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.1 Operating system: linux Description: can not enter µM into a varchar field in version 8.1.1 Details:
I get an error when trying to insert µM into a varchar field in version 8.1.1 but it was working in version 7.4. The error leads me to think that there is a different encoding on the dose_units field in the new database. How do we encode the special character "µ" into a varchar field for version 8.1.1? The error message is as follows: Invalid UTF-8 byte sequence detected near byte 0xb5 Thanks! ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq