i don't think there is such a thing in Oracle. note that in oracle they term database is somehow different than mysql ... what is a database in mysql is a schema in oracle.
another note about character sets ... you have set the database character set during creating it (normally during installing oracle), using NLS_CHARACTERSET should be set automatically then on the server .. however on the client side you just need to set them so the client speaks the same language as the server. it is also better to use the oci driver. On Wed, Jun 11, 2008 at 11:18 AM, davidludut <[EMAIL PROTECTED]> wrote: > The issue is like this: my customer is Chinese, so I use the UTF-8 for the > database character set. The appfuse 2.X default use mysql database, for this > issue I do like this 1. change the my.ini configuration for database support > utf8 character. 2. use the default jdbc setting: This setting is copyed from > Database settings part of the pom.xml. 3. I define a CustomMysqlDialect > class, let it extends org.hibernate.dialect.MySQL5InnoDBDialect, and then I > overrides the getTableTypeString() method, let it return " ENGINE=InnoDB > DEFAULT CHARSET=utf8". So the above is ok, the mysql can support Chinese > character, but my project default use oracle 9i, I can create a database use > sql to point out the database use "NLS_CHARACTERSET UTF8". And then use the > manual create database, it can support the Chinese character. My question, > is there any method to use the jdbc setting let oracle create a utf8 > characterset database? Thank you, waiting for your reply J > ------------------------------ > View this message in context: about the oracle9i > characterset<http://www.nabble.com/about-the-oracle9i-characterset-tp17772463s2369p17772463.html> > Sent from the AppFuse - User mailing list > archive<http://www.nabble.com/AppFuse---User-f2370.html>at Nabble.com. > -- Regards, Youssef
