Hi, the current OpenCA::DBI tries to set the character set using the 'SET NAMES' SQL command from the local locale. This SQL command is not supported by Oracle (version 9.2).
Instead, Oracle uses either 'ALTER DATABASE <dbname> CHARACTER SET <charset>' or 'ALTER DATABASE <dbname> NATIONAL CHARACTER SET <national charset>' to *permanently* set the desired character set for the database. Now it would of course be easy to simply issue the commands manually in the SQL monitor and ignore OpenCA's complaining about the failed 'SET NAMES' command. Before doing so I was wondering to which character set I should set the database - ISO-8859-1 would work fine for Germany but surely would produce problems in, say, eastern Europe. Any ideas? How about UTF8? Will OpenCA be able to handle this correctly? By the way: what is the point in setting the character set in the Database depending on the current locale? The system administrator might decide to change the locale for the system, so this could influence all data in the database as well if I am not completely wrong. Cheers, Martin ------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click _______________________________________________ OpenCA-Devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-devel
