so here is the proposal - types.Unicode() renders VARCHAR2, not NVARCHAR2, when oracle 8 is detected.
since NVARCHAR2 is essentially useless on oracle 8, correct ? when I used to use oracle 8 we used VARCHAR2 for unicode data. i wasn't aware of the N- types at that time. also the suite of changes here is going to roll in the "use_ansi" flag into the oracle 8 detection, its a bit redundant to require it manually. On May 18, 2010, at 1:29 PM, Kent wrote: > There is a fairly short Oracle-published white paper on Unicode > support here: > http://www.oracle.com/technology/tech/globalization/pdf/TWP_AppDev_Unicode_10gR2.pdf > > It does state that starting with Oracle7 there was Unicode support and > lists a table of Oracle version, Character set and Unicode version. > It also states you can *not* store Unicode in the NCHAR datatype until > Oracle 9i. > > > > > On May 18, 1:23 pm, Kent Bower <k...@retailarchitects.com> wrote: >> No, this is what was causing "ORA-12704: character set mismatch": >> >> SQL> SELECT CAST('test unicode returns' AS NVARCHAR2(60)) AS anon_1 FROM >> DUAL; >> SELECT CAST('test unicode returns' AS NVARCHAR2(60)) AS anon_1 FROM DUAL >> * >> ERROR at line 1: >> ORA-12704: character set mismatch >> >> On 5/18/2010 1:17 PM, Michael Bayer wrote: >> >> >> >>> Sorry, I meant NVARCHAR2. >> >>> SELECT CAST('test unicode returns' AS NVARCHAR2(60)) AS anon_1 FROM DUAL >> >>> works ? or no ? >> >>> On May 18, 2010, at 12:17 PM, Kent wrote: >> >>>> Oops, my bad, I didn't notice you that statement changed NVARCHAR2 to >>>> NVARCHAR: >> >>>> Here is that result: >>>> ============================= >>>> SQL> SELECT CAST('test unicode returns' AS NVARCHAR(60)) AS anon_1 >>>> FROM DUAL >>>> 2 ; >>>> SELECT CAST('test unicode returns' AS NVARCHAR(60)) AS anon_1 FROM >>>> DUAL >>>> * >>>> ERROR at line 1: >>>> ORA-00907: missing right parenthesis >>>> ============================= >> >>>> On May 18, 12:15 pm, Kent<k...@retailarchitects.com> wrote: >> >>>>>> SELECT CAST('test unicode returns' AS NVARCHAR(60)) AS anon_1 FROM DUAL >> >>>>>> then it seems like either that fails directly, or it fails when the >>>>>> client gets a hold of it. See what happens with that statement. Not >>>>>> sure that Oracle 8 has NVARCHAR which might be the issue. >> >>>>> Please see the beginning of my previous post, that is the statement >>>>> creating the "ORA-12704: character set mismatch" >> >>>>> So, you intend to change exc.DBAPIError to Exception? (That is >>>>> actually exactly what I had just done as a workaround until I heard >>>>> back from you) >> >>>>> -- >>>>> You received this message because you are subscribed to the Google Groups >>>>> "sqlalchemy" group. >>>>> To post to this group, send email to sqlalch...@googlegroups.com. >>>>> To unsubscribe from this group, send email to >>>>> sqlalchemy+unsubscr...@googlegroups.com. >>>>> For more options, visit this group >>>>> athttp://groups.google.com/group/sqlalchemy?hl=en. >> >>>> -- >>>> You received this message because you are subscribed to the Google Groups >>>> "sqlalchemy" group. >>>> To post to this group, send email to sqlalch...@googlegroups.com. >>>> To unsubscribe from this group, send email to >>>> sqlalchemy+unsubscr...@googlegroups.com. >>>> For more options, visit this group >>>> athttp://groups.google.com/group/sqlalchemy?hl=en. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To post to this group, send email to sqlalch...@googlegroups.com. >> To unsubscribe from this group, send email to >> sqlalchemy+unsubscr...@googlegroups.com. >> For more options, visit this group >> athttp://groups.google.com/group/sqlalchemy?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.