Martijn van Oosterhout wrote: > So your implemntation is simply: > 1. Take number and make UTF-8 string > 2. Convert it to database encoding.
Aah, now I can spot where the misunderstanding is. That's not what I mean. I mean that chr() should simply 'typecast' to "char". So when the database encoding is UTF8, I want chr(14844588) to return a Euro sign, and when the encoding is LATIN9, then chr(14844588) should either yield the 'not' sign (UNICODE 0xAC) or an error message, depending on whether we want chr() to operate mod 256 like Oracle has it for single byte character sets or not, while chr(164) should return the Euro sign for LATIN9 database encoding. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster