>> I have to replace fields with this in it with a valid string that will >> load into 8.1, do you know who i would do the conversion? > > The database will do it for you. Note that the client encoding affects > input *and* output. So if you set it to latin1, the database will > convert all strings to latin1 before sending them to you... ok, so my current database (7.4.12) is UNICODE, but from psql when i run this show client_encoding; client_encoding ----------------- UNICODE SELECT identifier from dba_data_base where bioassay_id = 1291 and identifier ilike '%G@S%'; identifier -------------- BG@S (0A11) so the mu chatacter is not showing up. So im not sure if the database is converting the output? (sorry, i am probably sounding very dim here!) thanks again for your help adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
