08.02.04.00 Updating column with Unicode

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 ?

mit freundlichen Grüßen / best regards,

Josef Springer

(Geschäftsleitung/Management)

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 --

Re: 08.02.04.00 Updating column with Unicode

(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

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

Re: 08.02.04.00 Updating column with Unicode

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

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

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