08.02.04.00 Updating column with Unicode

08.02.04.00 Updating column with Unicode

am 03.04.2011 13:50:44 von Josef Springer

This is a multi-part message in MIME format.
--------------060806030809000802030206
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

Hello everybody,

I have detected some strange behavior updating columns with Unicodes=20
strings.

Environment:
PostgreSQL 8.2.5
Database encoding: UTF8
ODBC: PostgreSQL Unicode Version 08.02.04.00

I am updating via ODBC a column (character varying nnn) of a record to=20
an unicoded string.

Updating by using the command as one parameterblock
'UPDATE adresse SET company =3D ''Seifert und Partner KG EUR ??'' WHERE i=
d=20
=3D 1'
works right. (the whole parameterblock is encoded to UTF8)

Updating the record by using the command 'UPDATE adresse SET company=3D?=20
WHERE record.id=3D?'
and providing the arguments for ? UTF8-encoded in an extra buffer=20
destroys the columns content.

If i update the column with an UTF8 encoded character in the default=20
range (the EURO Sign EUR), it works.

Can anybody give me some hints ?

mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)

Postal
Address
_Josef.Springer@joops.com_
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
Phone
Office
+49 (0)89 600 6920
=09
=09
Phone Fax
+49 (0)89 600 69220
=09
=09
Web
Web
http://www.joops.com
=09
=09

JOOPS
(HRB München 86239)

*-- the software company --*


--------------060806030809000802030206
Content-Type: multipart/related;
boundary="------------060409090106010406040606"


--------------060409090106010406040606
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit






Hello everybody,



I have detected some strange behavior updating columns with Unicodes
strings.



Environment:

PostgreSQL 8.2.5

Database encoding: UTF8

ODBC: PostgreSQL Unicode Version 08.02.04.00



I am updating via ODBC a column (character varying nnn) of a record to
an unicoded string.



Updating by using the command as one parameterblock

'UPDATE adresse SET company = ''Seifert und Partner KG € 文件'' WHERE id
= 1'

works right. (the whole parameterblock is encoded to UTF8)



Updating the record by using the command 'UPDATE adresse SET company=?
WHERE record.id=?'

and providing the arguments for ? UTF8-encoded in an extra buffer
destroys the columns content.



If i update the column with an UTF8 encoded character in the default
range (the EURO Sign €), it works.



Can anybody give me some hints ?


Signature

mit freundlichen Grüßen / best regards,

Josef Springer

(Geschäftsleitung/Management)

































Postal height="16" vspace="2" width="17">

Address

color="#cc0000">

Orlando-di-Lasso Str. 2

D-85640 Putzbrunn

src="cid:part2.05090903.01050508@joops.com" alt="Phone" height="15"
vspace="2" width="13">

Office color="#000099">

+49 (0)89
600 6920






alt="Phone" height="15" vspace="2" width="13"> Fax color="#000099">

+49 (0)89 600 69220





alt="Web" height="15" vspace="2" width="15">

Web color="#000099">















alt="JOOPS" align="left" height="61" hspace="0" width="220">

(HRB München 86239)



-- the software company --






--------------060409090106010406040606
Content-Type: image/jpeg;
name="Postal.jpg"
Content-Transfer-Encoding: base64
Content-ID:
Content-Disposition: inline;
filename="Postal.jpg"

/9j/4AAQSkZJRgABAQEBLAEsAAD/2wBDAAUDBAQEAwUEBAQFBQUGBwwIBwcH Bw8LCwkMEQ8S
EhEPERETFhwXExQaFRERGCEYGh0dHx8fExciJCIeJBweHx7/2wBDAQUFBQcG Bw4ICA4eFBEU
Hh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4e Hh4eHh7/wAAR
CAAQABEDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcI CQoL/8QAtRAA
AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS 0fAkM2JyggkK
FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1 dnd4eXqDhIWG
h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW 19jZ2uHi4+Tl
5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcI CQoL/8QAtREA
AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMz UvAVYnLRChYk
NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0 dXZ3eHl6goOE
hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU 1dbX2Nna4uPk
5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD6y1zXtP0iM/aZFEuAViwc 8kgE4BwvB59j
16VjaZ4202TxXa+HZtRsrm6vojJbtbBlJK+ZuQqSTjETkPnB2MMAgbqvj+x1 m51GZLDSNSu7
ae1jjke0nt4+Q0uVYSyKejgggfjWd4B8DazZSaPearqYii06/u7yCwaDfMnn eeqq8/mNuwk3
596AR6Xx6CilooA//9k=
--------------060409090106010406040606
Content-Type: image/jpeg;
name="Phone.jpg"
Content-Transfer-Encoding: base64
Content-ID:
Content-Disposition: inline;
filename="Phone.jpg"

/9j/4AAQSkZJRgABAQEBLAEsAAD/2wBDAAUDBAQEAwUEBAQFBQUGBwwIBwcH Bw8LCwkMEQ8S
EhEPERETFhwXExQaFRERGCEYGh0dHx8fExciJCIeJBweHx7/2wBDAQUFBQcG Bw4ICA4eFBEU
Hh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4e Hh4eHh7/wAAR
CAAPAA0DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcI CQoL/8QAtRAA
AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS 0fAkM2JyggkK
FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1 dnd4eXqDhIWG
h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW 19jZ2uHi4+Tl
5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcI CQoL/8QAtREA
AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMz UvAVYnLRChYk
NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0 dXZ3eHl6goOE
hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU 1dbX2Nna4uPk
5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1z4o/HW58FfEibwjL4OnS 1Sxe6j1jUnuo
ba6aONZZlgFvaztIscbBnf5Qu2QHGAW7P4HePbj4keAoPE194V1Lw1LLKVW2 vQSJY9quk0Ll
V8yJldcNtAyGAyBuOL8UvgloHxC8Y2/iy78TeLNFv4LGGyVtGvkt1KRzm4jJ zGzbhIVcc4BR
CACua634W+DNJ+HngXT/AAbo1xe3Fhpxl8qS8kVpT5kjSncVVR1c4wBxigD/ 2Q==
--------------060409090106010406040606
Content-Type: image/jpeg;
name="Web.jpg"
Content-Transfer-Encoding: base64
Content-ID:
Content-Disposition: inline;
filename="Web.jpg"

/9j/4AAQSkZJRgABAQEBLAEsAAD/2wBDAAUDBAQEAwUEBAQFBQUGBwwIBwcH Bw8LCwkMEQ8S
EhEPERETFhwXExQaFRERGCEYGh0dHx8fExciJCIeJBweHx7/2wBDAQUFBQcG Bw4ICA4eFBEU
Hh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4e Hh4eHh7/wAAR
CAAPAA8DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcI CQoL/8QAtRAA
AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS 0fAkM2JyggkK
FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1 dnd4eXqDhIWG
h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW 19jZ2uHi4+Tl
5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcI CQoL/8QAtREA
AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMz UvAVYnLRChYk
NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0 dXZ3eHl6goOE
hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU 1dbX2Nna4uPk
5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2z4nfGe38MeKLjwxpVol/ qtpFG81uIpJJ
ZJJFLRxRRqPmO0bmYkBVIwGJwOi+CvxCX4ieE31N9PfT7+0uGtL62YHCSqAT tJAOMMOCMg5H
bJ434rfBubxL8QbTx54X1mfQNdhXy7mRrdJ4bhQpQNsLjB25U5zkY4BGa6f4 J+DdV8FafrVl
q11BfS3+pPfG9SLynnZ0QMXUMQpypAC8bQPXA3xHsVGn7J6219TGEKrnJya5 VsurP//Z
--------------060409090106010406040606
Content-Type: image/jpeg;
name="Image120.jpg"
Content-Transfer-Encoding: base64
Content-ID:
Content-Disposition: inline;
filename="Image120.jpg"

/9j/4AAQSkZJRgABAQEAxgDGAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEB AQEBAQEBAQEB
AQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQH/2wBDAQEBAQEB AQEBAQEBAQEB
AQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEB AQEBAQH/wAAR
CAA9ANwDASIAAhEBAxEB/8QAHQAAAwADAQEBAQAAAAAAAAAAAAgJBgcKBQQD Av/EADgQAAEE
AgECAgcIAgICAwEAAAUDBAYHAggJAAFY2RIWGBl4mJkKERMUFTm31iK5NjcX ISQydrb/xAAU
AQEAAAAAAAAAAAAAAAAAAAAA/8QAFBEBAAAAAAAAAAAAAAAAAAAAAP/aAAwD AQACEQMRAD8A
fTQTQTRKZaJaVS+X6ValSqWSrUrXGSSiUSTXGnTkikkiOU7DSZs8fNk4a6JG DRgk6ckShQi5
cPiD5wu7drrOFlFMm193Bx4eAzTD5XKP/o3Rxwft4aF/Bhq5/B8G6c/oEw93 Bx4eAzTD5XKP
/o3R7uDjw8BmmHyuUf8A0bqaXPwzs2kNOJvthQF/7C0xZ8VnVZtS6UHvSzhk KOx+QlBkBXGp
12rIXsKArJZPBZXu6igaNLvX7YgSLLkn5J7m7b/iXh551pXrleNhW9eVyWtc 1NRibzKTWxcF
gzQf2cTJBpJO40HCSshWggFEJ2zQFjyoyNN5GuxRVwIGXfZ67wUDd3u4OPDw GaYfK5R/9G6U
qG6CaJOt7djog50q1KcRMHqVpVJAkXX1xp1aOh5FKri37GSg8LCKQ3IaPNSQ bDYgOPlGjZF8
YYxWNtCK7huDGJtbCdJhBv3D9o/gw0L/AJw5H+gPdwceHgM0w+Vyj/6N0e7g 48PAZph8rlH/
ANG6ZC1bQg1J1rOrdsw+0i9f1xFjMxlx9737/gjgYJks/eq4JYdu6zt2omj+ XHj2uCr0k/Wb
D2KC7xygjnBvTmz9peZgnOthZJaFo6laAx6YmoNStQ0XKHNdXVd5CPZt0yk3 tK6gaXaXBY22
/NKjVIzWRwAxcHe70EoTc5QpzIZiFVPdwceHgM0w+Vyj/wCjdHu4OPDwGaYf K5R/9G6VK5uN
ewoLDzE10D2x2jpO9o2N7lYjGLH2Dsm/aLsYyMao5Yxyx4JfZ+xWSKUl7tVG OElEOR6sbdlF
CKbF6Oa4CO3ocTHJ8I5E6ulguZxdKsdn6MfsotfVY9uzhuzRKqKPh6MvijUg qqTQjpYmHLMX
oQgq6Kw42zXBlHj9uoGNmg8ffvQTRKG6Jbqy+IaValRWWRXUrY6SReURvXGn QcijciB07MiY
Q8BNjIa1JBzQck1bERZQc5bvh75ug7aLouEU1MW193Bx4eAzTD5XKP8A6N0c j/7eG+nwYbR/
wfOenP6BMPdwceHgM0w+Vyj/AOjdHu4OPDwGaYfK5R/9G6ULlV5OSumS1Ra6 a+xQVaG7W0Js
PF6WhJnNTONRZtI5EhEBs7mrdq5avXbR/I11AsVDpuWLcuRHnH78kgNjT5mR zeBcZz+VRNgX
3K2v2t2Cu0sx/OSw3Ddi7eoKqY0ff9k1yDGqqro+S1rFwoAct6bJg6NCCJUq 3TwdkU2mHdmJ
Fgw3u4OPDwGaYfK5R/8ARuj3cHHh4DNMPlco/wDo3UhdmtgtlOEm2Kjmk/t+ 29vuOO6JUrAJ
NjcpNKdbBa7TlduuYbOA9qLs2RyxQpIGyLlwIGYuyDx6wisgBZPhJbswkpno qikpjs5i8bm0
QMMJFE5gADymLyAWvi5GHY7IBzYsEMDnOP8Ai4YExrts9aL4/wCKrddNTt/6 y7dBJqG6CaJO
t7djog50q1KcRMHqVpVJAkXX1xp1aOh5FKri37GSg8LCKQ3IaPNSQbDYgOPl GjZF8YYxWNtC
K7huDGJtW193Bx4eAzTD5XKP/o3RBv3D9o/gw0L/AJw5H+nP6BMPdwceHgM0 w+Vyj/6N0e7g
48PAZph8rlH/ANG658ftBEhvjT2W6jSPWXa3aeqRl7zKwonYUXZbBWtJA2bo Y+gDsUcjqcxl
UgXjyqSUoONXIlg4wAdkcBGA4UOwZr4u3r240g3Q1s1+sO8tNOSndaU2nUMV M2IvAdkpXW95
RKxgsOHOzJuPjxr+rBOAeSOwyBDuJ7ZNSwowTQGilRwxVz+uswpH7uDjw8Bm mHyuUf8A0bpS
t1dBNEorTsNJxfSrUqNknW2ugkbckQOuNOh3ziOzLe3XGIS8Cu7HQ1u4WCyq JnDcXkgtRTJi
cjpgoEJoOhpB22W/jhe5NCHJXredk87joyMXbT8gHwu1GsfwURjMgzKjcyUZ m8fYruHboQ1k
TVqSavwrhy57MTQUnmyX7jHLFFBuN9P+j4N8Z/HB/sP1c6A93Bx4eAzTD5XK P/o3R7uDjw8B
mmHyuUf/AEbpz+p/coO5jvQnSi39jggcbIZrH24OM12DMZqYiHs6mpxjHAbo skgq3cPBUf7P
nUoKDWrlo5Kjgboa3esFXeL1uGZe7g48PAZph8rlH/0bo93Bx4eAzTD5XKP/ AKN0kOtHH2Qv
ShaqvfY7dDcyyL4t+vojaj2eVhs7YdRwWCvJ7Hh8nbBqfr+sSgCuxsYCIk0W 7Fd/HC6R7NFQ
m4aoMnyYdp4uo8S3Wpjk+nVE7FbKzfY+iwumxiY62yiXC4uDNKCylx14HkrK xfVEKCazGzow
sMYi3swMJP3j2PvxhQf3C5yU4GSB+PdwceHgM0w+Vyj/AOjdN5w81vXdR5cj 9e1RAoXWMAj+
/wCF/QYPXsWBwuHhP1bjq4+ThT9IjMbYjQo39SNEiJch+SZI/nChB6QcfiO3 S6ynp9ZDxd/8
x5N/j/iv+tbjr6BD+OD9vDQv4MNXP4Pg3Tn9Jhxwft4aF/Bhq5/B8G6bg+fC RQCblEmLDwMc
jYgkfkB0s7RYCgoQOzWIlSxN85zTbsh45g2cPHrtdTBFu2RVWVzxwwyy7BEX 7R3+05en/wCz
pH+XIj05/FJ+2ro18MdR/wD8iO6mjznX/S2yHC7b1p0XZcTs+vzdhVCKGyaK k03jJUqJt+LJ
kxKyWfZF4xKseyOazgY+bNnybXuk87t/yi6KylYuOaCSCstBtNIHLGLoVKI1 rPS7GRiHzfu1
fBTmcBBuioN8h3UU/DehXzhcW7/z79snDRTPtjh2y7YYg53SYQb9w/aP4MNC /wCcOR/pz+kw
g37h+0fwYaF/zhyP9BLr7TdOJFEeMQmFBuXDZjZN7VRB5V2b+l27OI63Tk8+ xbOM8Vku+DdS
QwaP5Z/4uMVMsMEc0fQVyWRcbhLBjI9xWaXMBLbBq1cVe9OKpJ44Y45k5PNp VJTTnv2wxwx7
5vDBZ+8Uy79u+eai+eamWamWWeWRcumnJfebQy56RiCKC1ltmoqxapScZ4JJ vJ9AXuJpiBxV
VURboLTEPibhLZ47WSZj3EjSIus8UGinfpMvs6eyg2ztER2uMkVXDXhp5K5V VVjQc4muwlQo
G+lchOwsmQDPE0nQ9q3SdFoFm3Wx7OGpmBFkHaLbLJviqF+euJzRN+5qj7T1 tNBoYrmOjdmS
fZhhKh2P4eKDtsZD4XS6SxSRTSRwwSnAVk8afcn+Ig3w7o91FO+auavZ5NZp E64iEnn87kAu
KQuGAiknlUlNOsGYkEACs1iBQoQcqf4otWTNBVdXL7ssu+OHo4Y555Y49+VL g1oeXbOb3bj8
u0wAEAdZWVN7ZjmuKRtDJJ6fRmM0yyJn2WK+X5rsygkIDDoB3f4p4sCZc7IW DPLBaNvmyIdA
vI/+3hvp8GG0f8Hznpz+kw5H/wBvDfT4MNo/4PnPTn9BxQuDD62PtaAATOO+ JQXBJETDxMau
mnm1DMa+0ukk0jnZompk59DLCYpryvJTvn+JiXIOnKGLLv8AgoNu17rjr5Wa wO8e/MZq5yuJ
iiS2v1izWEx655IIav1cYRJkIS4p+bNnyA/BfLHGS0r6Uij7dLDDOTmAcyHq N+6yeTh/2AhD
YeShREjjpUedj58WwNgjYh43ICjAcq0SfjCox+0UVavh5Bkug7ZPGyqjdy2W SWRUzTzxy7hF
T7RZGBB/iS2NKkkPxnsJkNFyePqfcl3/ACpd3eleQxZf71ElM8fSAy421+9H JFX/AOT93dXu
j3VRV9r7PjNpBN+J7WhaRvcyLqMLWlCR7xbv3yX7x+M2vM2MdZK9/wD1j6AY N+SBsu2GOHbE
cNZ45+mtiqqouX2jy5nBDVyA6JVc1cTjYfci1q9BxqrY/wBsXclIQqISlrK8 zWTXHLti0aOr
AAQ0IwcEc2jNz6Rt7g67No4WUbVm49tV0dKdM6B1o/NtSJet4X6MvJsu+ebI jPpUWJTSfO2C
quOK6wvOYyI0mHzXxxW7CE2KeaaXodksA/ODfuH7R/BhoX/OHI/05/SYQb9w /aP4MNC/5w5H
+nP6Dkk+1RL4tm3HY5yTXVxb3DaC+STZFRy5UxSTqVTum3bo45qrr59sfRSR SxyUVU744YY5
ZZdu3el28/JFg515tCrdX9adx7p2Os2FSCuovA1tNNnYGwhRSagVRGUrnZqx 6piYXuEjTIsq
ZySAvzKBdVkggq+GAnyklZzV+1Nqpp+7k/EUww+65bNV7+nnjj9yaf8A4i/E U7+l37fdgn6e
Pp5//XD0sfS79vv7ff1r9BCLgL44rO4/dZJs7vVBuGui/JYHl0lhTMi1KJwK MRkS4GRCMlXo
9w8FO5R+KVkRk6sJduWLZMsND9l1nQlysrQ7fT/o+DfGfxwf7D9XOnP6TDfT /o+DfGfxwf7D
9XOgc/pTt4tSITvNq7a2sc8IugQuxRDLsKlDBtg8fxGWx4sxkkRk7Zpku0/P YCZCKYLERfZ4
x7Gg/ciFUetUSKq2DY9JLv8AbT9tNKGE3w+XYNYqEu/X+NWK9INcneA6sJ3b 0Rh1ilWqOGWG
f6kIiJosVG98cu33vmaGGX+GeXfsHJPX+0PKz9n0OjKY2PrjLYTTLAw5Hwcn iSIO4Ug1cr93
GXapLawFuyEAfufRVfd6usILmz7Z9ijoNGRmZB1JV+pzRzevTLkbbMLyoYui 6tOv4kah8hh8
vaog7drGOT8rFDR0IbBtyD5k8j8hNQGLOUJEDeno67fR/BqwMpvkSrHB4zIW vbggbkOfFQ6z
6ysCPo/mhpVmGmUHmkWNtUnTfJVq6TIgpCCKslUHTfPLB2wet1EXCWSieWGf fj/heo0Z0e+0
nUVWem+ZIVW1jVKfs+zIAIfrkQtbRGURS0mcrhBlZdw4XbRbsXhsQm8aHnXG WY4pJIawF91M
kY/goHZn1kPF3/zHk3+P+K/61uOvrHush4u/+Y8m/wAf8V/1rcdfQIfxwft4 aF/Bhq5/B8G6
aibQyL2NDJdXs3DNZFC55GD8Ml8ffd1sWR2LygU7CHwzzu3VQcdmpMU+dsnH dBZFbskvn3SV
Tz9HPtKLQSG72utEtKnMQ2O1KBxNxqVrivFwkk0quKVSIPHVqdhqgQWflAzf uGjZIaHjcmzQ
oeHRCKsTD5Fci0jYNu4TGNW19RuQ/wAUemHyGXh5j/QJbr7wYam6/Nl4ezsH YizKK7W8LvQf
rXaE6ipalELMAskmcfkRcJHoDGJFLP0LFuy7Ng8mk5OOF0hILtLwsndiUXud oekw9RuQ/wAU
emHyGXh5j/R6jch/ij0w+Qy8PMf6Bz+kwg37h+0fwYaF/wA4cj/R6jch/ij0 w+Qy8PMf61iK
1v3tD3NPbxbbX6lKSyxKxqSqDY5fRS4so61jtMyq7JfF3otonyHJEkDT8lfE vQPuHZd8xdMR
sbSHDhbhmTcmAo71Py8+NXXO5rcQ2Kj7uzdctk00OzN5sDrNN8qvsaQjfwUG +YuaoKi5BBZ+
yWRZsEF8ZzC5Eus0HshyjjIah2Z9809RuQ/xR6YfIZeHmP8AR6jch/ij0w+Q y8PMf6DRki4t
IHb6odrtjs1tvt7CwhLEq2qO3rDhMVp4g/ZvlXYZ9KILQ9a0+jNXgvH8t2Tx mRA8MzXRXzRG
NGT90OzpVHo7H4iCDxeKAw8YjMeGswwCOx4YyCggYgchg1Hig4gag2HjBrFq km2ZsWTdBq1Q
TwRQSwTwxx7KR6jch/ij0w+Qy8PMf6PUbkP8UemHyGXh5j/QHI/+3hvp8GG0 f8Hznpz+pxXZ
rfvbfFNW3R0v2v1KGxO5qxntUSgjG9FLiZyJhHbEipWIG3oF2T5DjA1qaajT DlcW4IiCjFB8
mgq7HPm+KjZXZ3qNyH+KPTD5DLw8x/oGdsKu4JbMKkdcWdEI7PYFLxqgiTxC WCWZyPnByueC
vdsRGP0lmy+Ka6SLpvnkn+K1doN3jZRF0girhOmHcWwCmWKsX1m3H3b1uq/J 8o4YU9CLLrqe
13FGK6jldwNgTa+qjt2SQ5uou4/FxSYSVVljljmoqwXcq/mcN8+o3If4o9MP kMvDzH+j1G5D
/FHph8hl4eY/0Hn65cfGuuts9kNzh2U0tXYaXNVGEq2OviYP7RugwMUTRQ7i G8lKJthsWC9m
zdu07hoQCjApRm3btF2ards3TSd/pMPUbkP8UemHyGXh5j/R6jch/ij0w+Qy 8PMf6Ag37h+0
fwYaF/zhyP8ATn9TiFa372h7mnt4ttr9SlJZYlY1JVBscvopcWUdax2mZVdk vi70W0T5DkiS
Bp+SviXoH3Dsu+YumI2NpDhwtwzJuTGzvUbkP8UemHyGXh5j/QaA234hdYt6 JSAlu0Mvvyy3
8Rbl2cOG52W1jUbiLI65aOiyEfjMTjIQIyVI5DhaRElkyWMFG4gSkUIvcRrP ujQSrK5Xq6MN
oplYlj2MyHotGowjZxkPJJEyZs22LZNutI2UfDGDmauOGKrkhJnZwsuv6Sih Dv6efbJevUbk
P8UemHyGXh5j/R6jch/ij0w+Qy8PMf6Bz+kw30/6Pg3xn8cH+w/Vzo9RuQ/x R6YfIZeHmP8A
Wsbb1v3tuaKiohKNr9SmA0PZ1J2u2XA6KXE1fKSKh7mgV4xBkuqR5DijfIKS lldhB0kbptkn
zyOuijQYRDkl2hdiFHel12k1dqrcKqFaSusc9N1sQmEElkijzN8uNwkqcDlg uXNI8TeM80X6
QUw8EoMjHYa6YkFR6rhJo+aq59lsddeo3If4o9MPkMvDzH+j1G5D/FHph8hl 4eY/0GjgHFxD
qqF9ovrDthutqzXaaeTZnVNbXFH53XANm7eNlyicTEbD1/dRiGLuEk3X5LOK yAQyHP3ipDEe
4+9Zs43ZqfoTQuoBOfzODdpxYNyW07SeWtsDdcsXsa7LC7t+6XdozOzB00YI Mw7X8u2/CAxs
SBCZZs2Kq49Zdi0VQ/X1G5D/ABR6YfIZeHmP9HqNyH+KPTD5DLw8x/oHP6yH i7/5jyb/AB/x
X/Wtx19If6jch/ij0w+Qy8PMf6bzh5Y2INy5H2VrymFzSfo7/hf16TV7AjlY w8l+Jx1cfKwv
9Ig8ksi3DQT8mFUHDyH52wpB+pFGr0u3/SWhBAGNBQ+OD9vDQv4MNXP4Pg3T n9aipPjB3toe
mqko6Ib2alEonTNYwKqIuRknHXcTyRP47XcVFRAI9PuxnJiHGujToaHbLlHA 4QLYrvlF1Wg5
i3yTbJbO9hjkP8cGmH047w80LoIZaynOSl4QpOdmsbWOvIfx1aqSeyqVuONK wcBct2yae363
vON+uUmAiO1f7LgY8CrQkNSKkWoJlg5GR6xwYUHNWE4in0VcX3vtpTTvIxG7 oAMpV7zuQ22B
t8hcNH/oDQPtlDmeqQmyJHVbPEyDOtadIlm9YgnRT9El0VQMGRTmQshjcnjc X2GOQ/xwaYfT
jvDzQuj2GOQ/xwaYfTjvDzQugnhPB1rRezarjNlOrtZa1YU4W7G++vpW+bOk pTYcnL8cXIic
TyGsZBsqzgbCJEVCMCOMSEcjyD9qZZTMsyTHwoMut8yfbpSElAAlVdruJ0se 3piQaGP7OZ2r
WE9y147akW+XsBvbcgj4EXdsTqgdsMMjjWHTGxxgGcEzioQAUJE40Rij0zZ/ 2GOQ/wAcGmH0
47w80Lo9hjkP8cGmH047w80LoIvSRhup2j2xdZuDd9VxLTVzaLxuve1Zt57c cQiVRSnaOv4r
eNxVVsZOB5uTSB+Wqk5IXFsVpPGYBxSI6BGJQgHfQGRoTspmKVr7szOwdcJD K4TaNbRGlLRc
VZskDiFfyR+JvSXtK2uF3OrNjLBsGIH3+ugxaG1iYqI6NR7pTCUXG4hpHLGX V8iOe1w9hjkP
8cGmH047w80Lo9hjkP8AHBph9OO8PNC6CVdfzzc8fLIhcluVnZSlP7EzA5H5 tVARcoYnmucE
sNOIR7XIkLikK7JyiPPYQmMIvNmSKDdU5HpVcEqlq8nbQOlI+yaZbEojcIeV 8ijz83sEs2rg
21YamYHZvchwURDldN6tOFVIWxPnyAy0/wAK7j89QbkiTeXug8zQdR4a6YuY 0wGCqT+wxyH+
ODTD6cd4eaF0ewxyH+ODTD6cd4eaF0Ekqzk11ucIfluF7WIyKKa064FK9Rpi F3uu8JWQrWLU
1fpC41NdYs9tYLbImfsMhuEPsFYTA3wRwNYR0AclZKYMmvzBPeAS2QUQnHJb PIS1FG9vpFHS
NuwVq6D2NW0elVVNNd43tWLjAQU6hZiXw01Oko7mwVilpC8RoiXygKUl4edw l/Xb2GOQ/wAc
GmH047w80Lo9hjkP8cGmH047w80LoI+vrI2vsGJ3dIZDH9laFTZ7xQ0Wwije qZXZndpT8W0/
pDtNYkPdVKREW2aouX7HoWCiEuzXRtJTzmRuUHj4cMhLueIAdk1Vja831/2Q alQmyYAhCMZC
TosgVsO/GZkyRTqpFVgOhWNh13R2zB0aPmCayrgDd7S1kiMlKKIRifSgI2ag ovTn2GOQ/wAc
GmH047w80Lo9hjkP8cGmH047w80LoI522rsfBNWePw9GW2xBidTWyqZfbZsO 7zaKYShuEI6p
XCTmqc3GVgOnNuVvH0rlShOJljCI8DYjZf8AoQR+0YtXKjbvn7qc3S8qaGrx ANeYQD7SEfY7
DvYrF9sDlqCNfXVeSldwVrQdtZX4m0SztazmcECzJGoIvIzgevyUnLQvFvN+ yT0dU32GOQ/x
waYfTjvDzQuj2GOQ/wAcGmH047w80LoJgziRz5GAWvnq4nuk6eYSfXBQL/5i iVmdoyPIFth4
w2sxnCE7vBIbPFEFq9dln1jrq4GadjUFTa9oY+AkWclaJY5trIt5w8quFKCN 5OsMbcYW88ig
Pek4tMzg7LaMMRpbGjG7ZZcSRxdW2s3eTPvW8XY5rGDyGEjyYCCPZit3b1h9 hjkP8cGmH047
w80Lo9hjkP8AHBph9OO8PNC6CYz41udAdm9NaQPM7GsipkbWtV9L9k40GFKx ya1Ax1lutSJR
bZRgAatUIHZgC1+9dpIyJiDDVxaRRMAbja8ekr4zW4NUKUk3KsfjNdojWUxb mVOOLUSV2Ivc
YIhFJe4vtzZ16o3jGa6xncM/8ZCtki0DaxVR1lbSi8WhhRlXaE2gziOTF1II 9ej2GOQ/xwaY
fTjvDzQuj2GOQ/xwaYfTjvDzQug11SJkeeqmEExrO1GDdUKkiqzu4RJglrNy DVRVqUSm7GWN
2xPuaxJIu+yr1livGSKf4T+HPH0TcBXayV2tJLHHXddSdujthnFZsh1dZawC KOGX/hBpCl6v
NnthErFluqEIntrBZwzn+BMWsMnTPGCOYIhD84rHCxIhO3fVGfYY5D/HBph9 OO8PNC6PYY5D
/HBph9OO8PNC6CHiM936xnGvk4Dx/YztC6ep/aueWBAJfH/WBxsIHgexdSQy AxuRPBlZVm5Q
taY64SWxZ3QkXNRKE2WdlEWA5zuOu3yc4Tz829pnvwoE2NsqOsL7YsrBC6YT mpazi0KsVw5r
OEE9z2cKsGINmUCiRCw21gmdZgiNk7AgwzItPq7UnMkGMk0RkaAOMbq+wxyH +ODTD6cd4eaF
0ewxyH+ODTD6cd4eaF0EVWEv3Mxi21C0JYXMsIdV7Sxqlklo3sO7cRiwMLSM BrFED8dk62h9
6m3Z+JZBSL1mFbyaFAI0CXIZZgTR1VzIXUKE9oENzdbxJpPDKlCNKbTPJ+rX wiVOIOnOBh/W
zCscJ4aKM1R4s6qPI2N3gjFR+zcFmyc0Ubt3uItfJo63sMch/jg0w+nHeHmh dHsMch/jg0w+
nHeHmhdB9/WQ8Xf/ADHk3+P+K/61uOvrD/YY5D/HBph9OO8PNC6azRvVKxNW hGwjm17hhd0T
/YbYBK9Dx6vadOUfDwH5DX+gtfhcWEQySXPfJpb8ELQw6QEDb2fKfnikhet2 4ga0Yodlw//Z

--------------060409090106010406040606--

--------------060806030809000802030206--

Re: 08.02.04.00 Updating column with Unicode

am 04.04.2011 15:18:45 von Hiroshi Inoue

(2011/04/03 20:50), Josef Springer wrote:
> Hello everybody,
>
> I have detected some strange behavior updating columns with Unicodes
> strings.
>
> Environment:
> PostgreSQL 8.2.5
> Database encoding: UTF8
> ODBC: PostgreSQL Unicode Version 08.02.04.00
>
> I am updating via ODBC a column (character varying nnn) of a record to
> an unicoded string.
>
> Updating by using the command as one parameterblock
> 'UPDATE adresse SET company =3D ''Seifert und Partner KG ₠æ–=
‡ä»¶'' WHERE id
> =3D 1'
> works right. (the whole parameterblock is encoded to UTF8)
>
> Updating the record by using the command 'UPDATE adresse SET company=3D=
?
> WHERE record.id=3D?'
> and providing the arguments for ? UTF8-encoded in an extra buffer
> destroys the columns content.
>
> If i update the column with an UTF8 encoded character in the default
> range (the EURO Sign â‚), it works.
>
> Can anybody give me some hints ?

How do you bind the parameters?

regards,
Hiroshi Inoue

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: 08.02.04.00 Updating column with Unicode

am 04.04.2011 15:47:47 von Josef Springer

This is a multi-part message in MIME format.
--------------070803080908070505080102
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Hi Hiroshi,

the parameters are bound as an UTF8-encoded bytearray. Because the=20
interface is controlled by a Smalltalk application, i think the codings=20
does not help you:
/bytes :=3D v asByteArrayEncoding: #'utf-8'.
p copyAt: 0 from: bytes size: (size :=3D bytes size) startingAt: 1.
p at: size put: 0
/
Josef Springer

Hiroshi Inoue wrote:
> (2011/04/03 20:50), Josef Springer wrote:
>> Hello everybody,
>>
>> I have detected some strange behavior updating columns with Unicodes
>> strings.
>>
>> Environment:
>> PostgreSQL 8.2.5
>> Database encoding: UTF8
>> ODBC: PostgreSQL Unicode Version 08.02.04.00
>>
>> I am updating via ODBC a column (character varying nnn) of a record to
>> an unicoded string.
>>
>> Updating by using the command as one parameterblock
>> 'UPDATE adresse SET company =3D ''Seifert und Partner KG ₠=E6=
–‡ä»=B6'' WHERE id
>> =3D 1'
>> works right. (the whole parameterblock is encoded to UTF8)
>>
>> Updating the record by using the command 'UPDATE adresse SET company=3D=
?
>> WHERE record.id=3D?'
>> and providing the arguments for ? UTF8-encoded in an extra buffer
>> destroys the columns content.
>>
>> If i update the column with an UTF8 encoded character in the default
>> range (the EURO Sign â‚), it works.
>>
>> Can anybody give me some hints ?
>
> How do you bind the parameters?
>
> regards,
> Hiroshi Inoue
>
>

--------------070803080908070505080102
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable




>


Hi Hiroshi,



the parameters are bound as an UTF8-encoded bytearray. Because the
interface is controlled by a Smalltalk application, i think the codings
does not help you:

bytes :=3D v asByteArrayEncoding: #'utf-8'.

p copyAt: 0 from: bytes size: (size :=3D bytes size) startingAt: 1.

p at: size put: 0



Josef Springer



Hiroshi Inoue wrote:

(2011/0=
4/03
20:50), Josef Springer wrote:


Hello everybody,




I have detected some strange behavior updating columns with Unicodes


strings.




Environment:


PostgreSQL 8.2.5


Database encoding: UTF8


ODBC: PostgreSQL Unicode Version 08.02.04.00




I am updating via ODBC a column (character varying nnn) of a record to


an unicoded string.




Updating by using the command as one parameterblock


'UPDATE adresse SET company =3D ''Seifert und Partner KG ₠æ–=
‡ä»¶'' WHERE id


=3D 1'


works right. (the whole parameterblock is encoded to UTF8)




Updating the record by using the command 'UPDATE adresse SET company=3D?


WHERE record.id=3D?'


and providing the arguments for ? UTF8-encoded in an extra buffer


destroys the columns content.




If i update the column with an UTF8 encoded character in the default


range (the EURO Sign â‚), it works.




Can anybody give me some hints ?





How do you bind the parameters?




regards,


Hiroshi Inoue










--------------070803080908070505080102--

Re: 08.02.04.00 Updating column with Unicode

am 05.04.2011 05:38:35 von Hiroshi Inoue

Hi Josef,

(2011/04/04 22:47), Josef Springer wrote:
> Hi Hiroshi,
>
> the parameters are bound as an UTF8-encoded bytearray. Because the
> interface is controlled by a Smalltalk application, i think the codings
> does not help you:
> /bytes :=3D v asByteArrayEncoding: #'utf-8'.
> p copyAt: 0 from: bytes size: (size :=3D bytes size) startingAt: 1.
> p at: size put: 0
> /

Unfortunately I know nothing about Smalltalk.
Anyway *Unicode* means UTF-16 as for the drivers.
Could you try to give utf-16 strings?

regards,
Hiroshi Inoue

> Josef Springer
>
> Hiroshi Inoue wrote:
>> (2011/04/03 20:50), Josef Springer wrote:
>>> Hello everybody,
>>>
>>> I have detected some strange behavior updating columns with Unicodes
>>> strings.
>>>
>>> Environment:
>>> PostgreSQL 8.2.5
>>> Database encoding: UTF8
>>> ODBC: PostgreSQL Unicode Version 08.02.04.00
>>>
>>> I am updating via ODBC a column (character varying nnn) of a record t=
o
>>> an unicoded string.
>>>
>>> Updating by using the command as one parameterblock
>>> 'UPDATE adresse SET company =3D ''Seifert und Partner KG ₠=E6=
–‡ä»=B6'' WHERE id
>>> =3D 1'
>>> works right. (the whole parameterblock is encoded to UTF8)
>>>
>>> Updating the record by using the command 'UPDATE adresse SET company=3D=
?
>>> WHERE record.id=3D?'
>>> and providing the arguments for ? UTF8-encoded in an extra buffer
>>> destroys the columns content.
>>>
>>> If i update the column with an UTF8 encoded character in the default
>>> range (the EURO Sign â‚), it works.
>>>
>>> Can anybody give me some hints ?
>>
>> How do you bind the parameters?
>>
>> regards,
>> Hiroshi Inoue

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: 08.02.04.00 Updating column with Unicode

am 05.04.2011 10:27:26 von Josef Springer

Hello Hiroshi,

the encoding of the databsase is set to UTF-8. So i think, i must use=20
UTF-8. I have tried allready giving UTF-16 strings, but with the same=20
results.

Thanks for your help,
Josef

Hiroshi Inoue wrote:
> Hi Josef,
>
> (2011/04/04 22:47), Josef Springer wrote:
>> Hi Hiroshi,
>>
>> the parameters are bound as an UTF8-encoded bytearray. Because the
>> interface is controlled by a Smalltalk application, i think the coding=
s
>> does not help you:
>> /bytes :=3D v asByteArrayEncoding: #'utf-8'.
>> p copyAt: 0 from: bytes size: (size :=3D bytes size) startingAt: 1.
>> p at: size put: 0
>> /
>
> Unfortunately I know nothing about Smalltalk.
> Anyway *Unicode* means UTF-16 as for the drivers.
> Could you try to give utf-16 strings?
>
> regards,
> Hiroshi Inoue
>
>> Josef Springer
>>
>> Hiroshi Inoue wrote:
>>> (2011/04/03 20:50), Josef Springer wrote:
>>>> Hello everybody,
>>>>
>>>> I have detected some strange behavior updating columns with Unicodes
>>>> strings.
>>>>
>>>> Environment:
>>>> PostgreSQL 8.2.5
>>>> Database encoding: UTF8
>>>> ODBC: PostgreSQL Unicode Version 08.02.04.00
>>>>
>>>> I am updating via ODBC a column (character varying nnn) of a record =
to
>>>> an unicoded string.
>>>>
>>>> Updating by using the command as one parameterblock
>>>> 'UPDATE adresse SET company =3D ''Seifert und Partner KG ₠=E6=
–‡ä»=B6''=20
>>>> WHERE id
>>>> =3D 1'
>>>> works right. (the whole parameterblock is encoded to UTF8)
>>>>
>>>> Updating the record by using the command 'UPDATE adresse SET company=
=3D?
>>>> WHERE record.id=3D?'
>>>> and providing the arguments for ? UTF8-encoded in an extra buffer
>>>> destroys the columns content.
>>>>
>>>> If i update the column with an UTF8 encoded character in the default
>>>> range (the EURO Sign â‚), it works.
>>>>
>>>> Can anybody give me some hints ?
>>>
>>> How do you bind the parameters?
>>>
>>> regards,
>>> Hiroshi Inoue
>
>

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: 08.02.04.00 Updating column with Unicode

am 08.04.2011 01:50:31 von Hiroshi Inoue

Hi Josef,

Could you send me directly the Mylog output?

regards,
Hiroshi Inoue

(2011/04/05 17:27), Josef Springer wrote:
> Hello Hiroshi,
>
> the encoding of the databsase is set to UTF-8. So i think, i must use
> UTF-8. I have tried allready giving UTF-16 strings, but with the same
> results.
>
> Thanks for your help,
> Josef

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc