Youssef, thanks very much your replay, i have set the NLS_CHARACTERSET during installing oracle. thanks best reagrds :)
ming Youssef Mohammed wrote: > > 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 > > -- View this message in context: http://www.nabble.com/about-the-oracle9i-characterset-tp17772463s2369p17791009.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
