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: 
http://www.nabble.com/about-the-oracle9i-characterset-tp17772463s2369p17772463.html
Sent from the AppFuse - User mailing list archive at Nabble.com.

Reply via email to