Re: [Squirrel-sql-users] Special Codeset conversion problem with Informix

[Peter <L....@pf...>]

Hi Rob,

Rob Manning wrote:
> Peter wrote:
>>
>> But I can't get the codeset conversion to run with the Informix 
>> driver. It should work like this:
>>
>> jdbc:informix-sqli://server:port/dbname:INFORMIXSERVER=servername;CLIENT_LOCALE=en_US.CP1252;DB_LOCALE=en_US.850;IFX_CODESETLOB=4096 
>
> Peter,
>
> This is just a guess as I have neither access to Informix, nor do I 
> have specific knowledge about charset conversions.
> But the key=value pairs after the semi-colon look like driver 
> properties to me.  Some jdbc drivers support database-specific
> driver properties.  When you modify the alias for Informix, check the 
> checkbox next to "Use Driver Properties" then click the
> "Properties" button.  If these are supported driver properties they 
> will appear in the table of the dialog that is shown and
> you can fill in the values there.  If these aren't supported driver 
> properties, they will not appear in the table.
>
> Rob Manning
Thanks for your suggestion!
These are in fact driver properties, but within the "Use Driver 
Properties" dialog only the user and password fields are provided.

IMHO I can only place them in the JDBC-URL.

cu
Peter