>This isn't a Struts prolem, and it's not a MySQL problem either. As usual, >it's "user error" :-) >These are two things to do:
>[1] If you're importing through Java, you need to make sure your file reader >is properly decoding >UTF-8 stings: >http://javaalmanac.com/egs/java.io/ReadFromUTF8.html >[2] An optional step is to make your MySQL tables have their encoding set to >UTF-8. Your >destination columns need this, at least. >[3] A very required step is to have UTF-8 be the default encoding for Strings >to and from the >database driver. Alter the URL of your database to contain these 2 paramters: >jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=utf-8 -- Paul I tried that, but... :-((((( here i give you some code examples, maybe it help's... struts-config <data-source type="org.apache.commons.dbcp.BasicDataSource"> <set-property property="driverClassName" value="org.gjt.mm.mysql.Driver" /> <set-property property="url" value="jdbc:mysql://localhost:3306/crm" /> <set-property property="useUnicode" value="true" /> <set-property property="characterEncoding" value="UTF-8" /> <set-property property="username" value="root" /> <set-property property="password" value="" /> <set-property property="maxActive" value="10" /> <set-property property="maxWait" value="5000" /> <set-property property="defaultAutoCommit" value="false" /> <set-property property="defaultReadOnly" value="false" /> </data-source> witn this code: jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=utf-8 i get error. something like "your characterEncoding parameter must end with ";" ... " server.xml <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="org.gjt.mm.mysql.Driver" connectionURL="jdbc:mysql://localhost:3306/crm" connectionName="root" connectionPassword="" userTable="users" userNameCol="user_name" userCredCol="user_pass" userRoleTable="user_roles" roleNameCol="role_name"/> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
