[sqlalchemy] blob column - how to define in model

2007-10-04 Thread Werner F. Bruhin
I have just started to work with sqlalchemy and there is one thing I can't figure out. I am using Firebird SQL 2.0 and kinterbasdb 3.2, and I have some blob columns defined as: NOTES MEMO /* MEMO = BLOB SUB_TYPE 1 SEGMENT SIZE 80 */, CREATE DOMAIN MEMO AS BLOB SUB_TYPE 1 SEGMENT

[sqlalchemy] convert_unicode problem

2007-10-04 Thread Moo
Hi all. I'm trying to switch from SA 0.3 to 0.4. I tested simple SELECT, I've got a NotSupportedError. Python: 2.5.1 SQLAlchemy: 0.4 beta6 cx_Oracle: 4.3.2 Environment variable: NLS_LANG=JAPANESE_JAPAN.JA16SJIS sample code) - from

[sqlalchemy] Firebird - column types

2007-10-04 Thread Werner F. Bruhin
Scanning firebird.py I noticed that: FBText returns BLOB SUB_TYPE 2 Shouldn't that be BLOB SUB_TYPE 1 or BLOB SUB_TYPE TEXT and FBBinary returns BLOB SUB_TYPE 1 Shouldn't that be BLOB SUB_TYPE 0 See Helen's FB Book on page 182 and/or page 78 of the IB 6 Data Definition Guide (DataDef.pdf).

[sqlalchemy] Re: Firebird - column types

2007-10-04 Thread Roger Demetrescu
Hi Werner ! On 10/4/07, Werner F. Bruhin [EMAIL PROTECTED] wrote: Scanning firebird.py I noticed that: FBText returns BLOB SUB_TYPE 2 Shouldn't that be BLOB SUB_TYPE 1 or BLOB SUB_TYPE TEXT and FBBinary returns BLOB SUB_TYPE 1 Shouldn't that be BLOB SUB_TYPE 0 Well, I personally

[sqlalchemy] Re: convert_unicode problem

2007-10-04 Thread Michael Bayer
this is ticket #800 in trac, which will be fixed soon. in the meantime, heres a patch you can apply which will fix for now: http://www.sqlalchemy.org/trac/attachment/ticket/800/patch.diff On Oct 4, 2007, at 5:25 AM, Moo wrote: Hi all. I'm trying to switch from SA 0.3 to 0.4. I tested

[sqlalchemy] Re: Supporting sybase backend through mx.ODBC driver

2007-10-04 Thread Michael Bayer
hey Alexander - thats incredible test results you got ! our non-mainstream databases usually get nowheres near that level of passed tests (regardless of @unsupporteds). if you can attach your patch as an attachment to the ticket itself that would be very helpful...in the email here its

[sqlalchemy] Re: blob column - how to define in model

2007-10-04 Thread Michael Bayer
On Oct 4, 2007, at 5:07 AM, Werner F. Bruhin wrote: I have just started to work with sqlalchemy and there is one thing I can't figure out. I am using Firebird SQL 2.0 and kinterbasdb 3.2, and I have some blob columns defined as: NOTES MEMO /* MEMO = BLOB SUB_TYPE 1 SEGMENT

[sqlalchemy] Re: blob column - how to define in model

2007-10-04 Thread Werner F. Bruhin
Michael Bayer wrote: On Oct 4, 2007, at 5:07 AM, Werner F. Bruhin wrote: I have just started to work with sqlalchemy and there is one thing I can't figure out. I am using Firebird SQL 2.0 and kinterbasdb 3.2, and I have some blob columns defined as: NOTES MEMO /* MEMO =

[sqlalchemy] Re: Supporting sybase backend through mx.ODBC driver

2007-10-04 Thread Alexander Houben
Hi Michael, Michael Bayer wrote: hey Alexander - thats incredible test results you got ! our non-mainstream databases usually get nowheres near that level of passed tests (regardless of @unsupporteds). if you can attach your patch as an attachment to the ticket itself that would

[sqlalchemy] Problems with Sequence on PostgreSQL.

2007-10-04 Thread Gustavo Schneider
Hi all SQLAlchemists, I'm having some problems with Sequence. Can someone tell me what is wrong and put me in right way? The code: code table1 = Table('table1', metadata, Column('id', types.Integer, Sequence('table1_id_seq'), primary_key=True) ) /code Last error message: error ...