Re: Reading £ character from DB is displaying œ character

Here is what I get:

testdb=> set client_encoding='DOS437';
ERROR:  invalid value for parameter "client_encoding": "DOS437"
testdb=> set client_encoding='CP437';
ERROR:  invalid value for parameter "client_encoding": "CP437"

The other question I have is if I am setting the
server_encoding/client_encodng to UTF8, then saving the £ character into DB
should save £ and be able to see the same in the table. I am still not clear
as to why it gets gibbersh characters... its much confusing as to believe if
it saved the right characters. Not sure what's missing peice here??





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Reading-character-from-DB-is-displaying-character-tp5771897p5772142.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.