From: "Frankie Lam" <frankie@ucr.com.hk>
Subject: Re: PLPGSQL with Multibyte Issue
Date: Tue, 18 Mar 2003 16:35:16 +0800
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 43
Message-ID: <b56ll9$815$1@news.hub.org>
References: <b56hgd$2o8i$1@news.hub.org>
To: pgsql-sql@postgresql.org

At the beginning, I used the SQL_ASCII database encoding and found it is not
working
now, I'm using the EUC_TW as the database encoding,
and using ODBC to connect to the database, excute the plpgsql functions.
(and I'm having
SET CLIENT_ENCODING TO 'BIG5' in the connection string).

everything seems to be fine now,
but I'm still worrying if there's any loopholes there... :-(
(Too scarey to find another `truth' about the shortcoming of plpgsql)

So if anyone has similar experience, please let me know.

Thanks so much.

BTW, if I want to insert a single slash character, `\' , do I have to use
'\\\\' (that's totally 4 slashes)
inorder to  `EXCUTE' DYNAMIC plpgsql query? (sorry for my poor explanation)
e.g.
    str := '' insert into test values(''''\\\\'''');'' -- I've tried putting
\\, it doesn't work, how come it is so?
    excute str;


"Frankie Lam" <frankie@ucr.com.hk> wrote in message
news:b56hgd$2o8i$1@news.hub.org...
> Hi all,
>
> I'm experiencing some problem with using multibyte character issues in
> PLPGSQL. It seems
> that some double characters to have value of '0x5c' in the lower byte,
> making PLPGSQL to
> think that the statement is a unterminatated string. And this drives me
> crazy :( .
>
> Hope someone could kindly shed some light on this.
>
> Regards,
> Frankie Lam
>
>