Re: [SQL] UNICODE and PL/PGSQL
Yes, I tried and it didn't work. PostgreSQL surely makes something of it, but not the right characters. Unless Markus can make his idea using "decode" work, this might be something pl/pgsql cannot do. >>> Richard Huxton 2006-11-27 17:34 >>> Bart Degryse wrote: > As the manual says : Character with the given ASCII code > I need characters outside the ASCII range. Something like > charset := charset || '\xC2\x' || to_hex(i)'; Well, if you've tried it for characters > 127 and it didn't work then I don't know that it is possible at all. You *did* try the function? -- Richard Huxton Archonet Ltd
Re: [SQL] UNICODE and PL/PGSQL
Basically, I agree with your viewpoint on developer's permissions, but any annoyance can be fixed with a large enough paycheck... >>> Markus Schaber <[EMAIL PROTECTED]> 2006-11-27 17:34 >>> Hi, Bart, Bart Degryse wrote: > I haven't got enough permissions to install new programs. Big brother... ;-) A developer doesn't get the permissions to use the tools he need for his work? Developers absolutely _must_ have root / admin permissions on their own workstations, that's a prerequirement for them to fulfil their job. Time to search a new employer, honest! > I get the error in a plpgsql function Ah, I just saw that the "decode" function returns bytea, not text. I'll need a further look into this... Sorry, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org
Re: [SQL] UNICODE and PL/PGSQL
On þri, 2006-11-28 at 09:14 +0100, Bart Degryse wrote: > Yes, I tried and it didn't work. PostgreSQL surely makes something of > it, but not the right characters. maybe you should show us exacly what you did, and what you got, and what you expected > Unless Markus can make his idea using "decode" work, this might be > something pl/pgsql cannot do. did you try the function I posted yesterday elsewhere in this thread? gnari ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
