Re: [GENERAL] utf8 encoding problem with plperlu

2015-07-16 Thread Ronald Peterson
Still trying to figure this out, still confused, but like most frustrating programming problems, I think I may be looking in the wrong place for the source of this error. Perhaps. On Wed, Jul 15, 2015 at 11:25 PM, Tom Lane wrote: > Ronald Peterson writes: > > This does work for strings that do

Re: [GENERAL] utf8 encoding problem with plperlu

2015-07-15 Thread Tom Lane
Ronald Peterson writes: > This does work for strings that don't contain consecutive zeroes. I'm not > really passing the string to PostgreSQL, but to Net::LDAP, but it must hit > PostgreSQL anyway? Active Directory requires this encoding, so I'm not > sure what to do here. Hm, well, the concret

Re: [GENERAL] utf8 encoding problem with plperlu

2015-07-15 Thread Ronald Peterson
Thanks Pavel, this looks promising. I didn't know about the Data::Peek module - that might help me figure out what is going on. On Wed, Jul 15, 2015 at 2:28 PM, Pavel Stehule wrote: > > > 2015-07-15 20:20 GMT+02:00 Ronald Peterson : > >> That's interesting. What I'm really doing, instead of th

Re: [GENERAL] utf8 encoding problem with plperlu

2015-07-15 Thread Pavel Stehule
2015-07-15 20:20 GMT+02:00 Ronald Peterson : > That's interesting. What I'm really doing, instead of the second elog > statement, is this: > > $ret = $ldap->modify( $dn, > replace => { > unicodePwd => $mspass > } ); > > This does wo

Re: [GENERAL] utf8 encoding problem with plperlu

2015-07-15 Thread Ronald Peterson
That's interesting. What I'm really doing, instead of the second elog statement, is this: $ret = $ldap->modify( $dn, replace => { unicodePwd => $mspass } ); This does work for strings that don't contain consecutive zeroes. I'm not

Re: [GENERAL] utf8 encoding problem with plperlu

2015-07-15 Thread Daniel Verite
Ronald Peterson wrote: > # select * from doublezero(); > INFO: double00 > CONTEXT: PL/Perl function "doublezero" > ERROR: invalid byte sequence for encoding "UTF8": 0x00 at line 8, > line 558. > CONTEXT: PL/Perl function "doublezero" > > I don't understand this. I need to pass $mspa

Re: [GENERAL] utf8 encoding problem with plperlu

2015-07-15 Thread Adrian Klaver
On 07/15/2015 07:14 AM, Ronald Peterson wrote: The following short function illustrates a problem I'm having with the plperlu module. CREATE OR REPLACE FUNCTION doublezero () RETURNS VOID AS $$ use Encode qw/encode decode/; $pass = "double00"; elog( INFO, "$pass" ); $mspass = encode( 'UTF-16LE',

[GENERAL] utf8 encoding problem with plperlu

2015-07-15 Thread Ronald Peterson
The following short function illustrates a problem I'm having with the plperlu module. CREATE OR REPLACE FUNCTION doublezero () RETURNS VOID AS $$ use Encode qw/encode decode/; $pass = "double00"; elog( INFO, "$pass" ); $mspass = encode( 'UTF-16LE', qq("$pass") ); elog( INFO, "$mspass" ); $$ LANGU