plpython_error_2.outPython 2.2, 2.3, 2.4

plpython_error.outPython 2.5, 2.6

plpython_unicode.outany version, when server encoding != SQL_ASCII; else ...

plpython_unicode.outany version, when server encoding != SQL_ASCII and client encoding = UTF8; else ...

plpython_unicode_0.outany version, when server encoding != SQL_ASCII and client encoding != UTF8; else ...

plpython_unicode_2.outPython 2.2

plpython_unicode_3.outPython 2.3, 2.4

plpython_unicode_5.outPython 2.5, 2.6

--

-- Unicode handling

--

CREATE TABLE unicode_test (

testvalue text NOT NULL

);

CREATE FUNCTION unicode_return() RETURNS text AS E'

return u"\\x80"

' LANGUAGE plpythonu;

CREATE FUNCTION unicode_trigger() RETURNS trigger AS E'

TD["new"]["testvalue"] = u"\\x80"

return "MODIFY"

' LANGUAGE plpythonu;

CREATE TRIGGER unicode_test_bi BEFORE INSERT ON unicode_test

FOR EACH ROW EXECUTE PROCEDURE unicode_trigger();

CREATE FUNCTION unicode_plan1() RETURNS text AS E'

plan = plpy.prepare("SELECT $1 AS testvalue", ["text"])

rv = plpy.execute(plan, [u"\\x80"], 1)

return rv[0]["testvalue"]

' LANGUAGE plpythonu;

CREATE FUNCTION unicode_plan2() RETURNS text AS E'

plan = plpy.prepare("SELECT $1 || $2 AS testvalue", ["text", u"text"])

rv = plpy.execute(plan, ["foo", "bar"], 1)

return rv[0]["testvalue"]

' LANGUAGE plpythonu;

SELECT unicode_return();

unicode_return

----------------

(1 row)

INSERT INTO unicode_test (testvalue) VALUES ('test');

SELECT * FROM unicode_test;

testvalue

-----------

(1 row)

SELECT unicode_plan1();

unicode_plan1

---------------

(1 row)

SELECT unicode_plan2();

unicode_plan2

---------------

foobar

(1 row)