>>> It would be handy to have a function that, given a $dbh, >>> returns 1 if the >>> database national char set supports unicode (which would be >>> true for Oracle >=9) >>> and 2 if the database default charset is unicode. >>> >>> Could even live in the driver as an $dbh->ora_can_unicode; method.
>> 0 = Neither character set is Unicode. >> 1 = National character set is Unicode. >> 2 = Database character set is Unicode. >> 3 = Both national and database character sets are Unicode. > > And please, > just for now, stick to adding $dbh->ora_can_unicode so as not to tread > on Jeff Urlwin and Lincoln Baxter's toes, as they're working with > me on utf8 support. Attached is the patch for adding ora_can_unicode. I've dug out 8i and checked whether you can have a Unicode main character set, with a non-Unicode national character set - you can: SQL> select * from v$nls_parameters where parameter like '%CHARACTERSET'; PARAMETER VALUE -------------------------------- -------------------- NLS_CHARACTERSET UTF8 NLS_NCHAR_CHARACTERSET WE8ISO8859P15 thanks, -- Andy Hassall <[EMAIL PROTECTED]> / Space: disk usage analysis tool <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>
DBD-Oracle-rev237-ora_can_unicode.patch
Description: Binary data
