Search Postgresql Archives

Re: not valid character for Unicode

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




>> 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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux