How do you configure the encoding in Borland Appserver? Can you configure a standalone interclient connection with the desired character encoding, getting the connection from DriverManager?
Here is my AppServer configuration:
I use JDBC Pilot (integrated in JBuilder5)
Here I have to use this settings:
Use extended properties: YES
Extended properties: user=sysdba,password=masterkey,charSet=Cp1250
With this configuration everything goes fine.
Here I during registering database set
Default Character Set: WIN1250
But IBConsole has one strange feature (or bug).
If I create database in IBConsole with this default character set, I can't immediately modify the data.
I have to unregister and register again the database.
Then it goes correctly. :-)
Did you try including in the XADataSourceLoader config for interbase
Remove the userName and Password properties too... of all the ridiculous configuration methods.....grrrr...
I'm not sure if the userName and password are quite right for interclient, check the docs. This will (if the separate userName is missing) make the XADataSourceImpl use DriverManager.getConnection(url, properties) which should give you what you want.
Thank you very much, David.
It's OK now.
I wrote comma, not semicolon !!! =:-O
It was my fault, because in JBuilder I have to separate properties by comma.
So. The right configuration is here.
Thank you a lot one more time.
Have a nice weekend.