> Could you run the following queries and compare with my results: > > test=> select ascii(c) from chartest; > ascii > ------- > 225 > (1 row) > > test=> select encode(convert_to(c,'LATIN9'),'hex') from chartest; > encode > -------- > e1 > (1 row) > > test=> select ascii(to_ascii(encode(convert_to(c,'LATIN9'),'escape'),'LATIN9')) from chartest; > ascii > ------- > 97 > (1 row) It gives me: ascii ------- 225 encode -------- e1 ascii ------- 92 So the last command have different output. Strange. regards Pavel