diff options
Diffstat (limited to 'src/pl/plpython/expected/plpython_unicode.out')
-rw-r--r-- | src/pl/plpython/expected/plpython_unicode.out | 17 |
1 files changed, 11 insertions, 6 deletions
diff --git a/src/pl/plpython/expected/plpython_unicode.out b/src/pl/plpython/expected/plpython_unicode.out index 859edbbbaa8..c7546dd4587 100644 --- a/src/pl/plpython/expected/plpython_unicode.out +++ b/src/pl/plpython/expected/plpython_unicode.out @@ -1,22 +1,27 @@ -- -- Unicode handling -- +-- Note: this test case is known to fail if the database encoding is +-- EUC_CN, EUC_JP, EUC_KR, or EUC_TW, for lack of any equivalent to +-- U+00A0 (no-break space) in those encodings. However, testing with +-- plain ASCII data would be rather useless, so we must live with that. +-- SET client_encoding TO UTF8; CREATE TABLE unicode_test ( testvalue text NOT NULL ); CREATE FUNCTION unicode_return() RETURNS text AS E' -return u"\\x80" +return u"\\xA0" ' LANGUAGE plpythonu; CREATE FUNCTION unicode_trigger() RETURNS trigger AS E' -TD["new"]["testvalue"] = u"\\x80" +TD["new"]["testvalue"] = u"\\xA0" 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) +rv = plpy.execute(plan, [u"\\xA0"], 1) return rv[0]["testvalue"] ' LANGUAGE plpythonu; CREATE FUNCTION unicode_plan2() RETURNS text AS E' @@ -27,20 +32,20 @@ return rv[0]["testvalue"] SELECT unicode_return(); unicode_return ---------------- - \u0080 + (1 row) INSERT INTO unicode_test (testvalue) VALUES ('test'); SELECT * FROM unicode_test; testvalue ----------- - \u0080 + (1 row) SELECT unicode_plan1(); unicode_plan1 --------------- - \u0080 + (1 row) SELECT unicode_plan2(); |