Tony
|
| Posted: 02/21/2005, 1:29 AM |
|
I use a db with diffrent character set. Will be good if the db connection has a property for character set - something like Zeos DB - codepage = xxxx, where xxxx is the code page for the db - in this case the command SET CHARACTER SET =xxxx is set again with the SQL command. (this is for MySQL)
|
|
|
 |
miko
Posts: 50
|
| Posted: 02/21/2005, 11:56 PM |
|
Tony,
you can try to do it with sql session commands. Such commands is used to set DateFormat for Oracle connections.
For example, is is supposed connection name is "Conn1" then we can add into site.properties file
Conn1.sessionCommand0=SET CHARACTER SET =xxxx
Conn1.sessionCommand1= <another init command>
... and so on
please note commands will be executed in their order and execution will be finished if command with the next number is missed.
For example:
Conn1.sessionCommand0=SET CHARACTER SET =xxxx
Conn1.sessionCommand2= <another init command>
command2 won't be performed because Conn1.sessionCommand1 is missed.
_________________
Regards,
Michael |
 |
|
|
