-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
When you created your tables, did you define the fields as UNICODE?
CREATE TABLE PRODUCT (
PRODUCT_ID VARCHAR(20) UNICODE NOT NULL,
...
Cheers,
C.J.
Eduards Mihelovics wrote:
> I've tried parameter substitution as well, but it does not work for
> me. When I use session.sqlX ('INSERT INTO TMP(a) VALUES (?)',
> ['ā']), garbage gets inserted. Namely, I get "Ä?" value in the TMP
> table. Is there anything else that I should configure, maybe some
> session parameter?
>
> Eduard
>
> On 12/5/05, Dittmar, Daniel <[EMAIL PROTECTED]> wrote:
>>> I have a problem with inserting Unicode characters into MaxDB
>>> 7.6 from python.
>>>
>>> I use a simple statement for testing: INSERT INTO TMP(a) VALUES
>>> ('ā') (in case the values() character does not show correctly,
>>> that's Latvian a with diacritical mark)
>> The Python driver currently does support Unicode only for
>> parameters, not in SQL statements.
>>
>> The solution would be: insert = session.prepare ('INSERT INTO
>> TMP(a) VALUES (?)') insert.execute (['ā'])
>>
>> There exists a shortcut if you want to execute the prepared
>> statement only once: session.sqlX ('INSERT INTO TMP(a) VALUES
>> (?)', ['ā'])
>>
>>
>>
http://dev.mysql.com/doc/maxdb/en/26/794c3f0a38e07fe10000000a114084/frameset.htm
>>
>>
>> Daniel Dittmar
>>
>> -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED]
>>
- --
<[EMAIL PROTECTED]>
http://cjcollier.livejournal.com/
+1 206 226 5809
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFDmTCvbS8rWWzCfqgRAtYtAKCTWitNowiGE3zhrl1szcIfQEJIEACfWTkD
+guY/IdU//mafsaxkALhauI=
=4JLq
-----END PGP SIGNATURE-----
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
