Hi, this might be the wrong forum to ask this question. If so I'm sorry.


Anyway I have an application where I use OpenOffice as front end to the
database (firebird). I use the jdbc JayBird Driver, and I use StarBasic
as programming language. I created the database with charset ISO8859_1.
I have some code like this:

Dim dbInfoData(3) As New com.sun.star.beans.PropertyValue

dbInfoData(0).Name = "user"
dbInfoData(0).Value = "SYSDBA"
dbInfoData(1).Name = "password"
dbInfoData(1).Value = "henrikhenrik"
dbInfoData(2).Name = "JavaDriverClass"
dbInfoData(2).Value = "org.firebirdsql.jdbc.FBDriver"
dbInfoData(3).Name = "charset"
dbInfoData(3).Value = "ISO-8859-1" 'Have also tried ISO_8859_1,
ISO8859_1, ISO88591 etc.

oConnection =
DatabaseContext.getConnectionWithInfo("jdbc:firebirdsql:localhost/3050:c
:/Test/Test.fdb", dbInfoData())

This connects and there are no problems with ascii characters, but
"foreign" characters throws an exception. Any help is much appreciated.

Thx,
Henrik









[Non-text portions of this message have been removed]