Subject | Re: Strange character sets or.........u figure it out |
---|---|
Author | bkdc |
Post date | 2002-06-27T11:45:56Z |
--- In Firebird-Java@y..., "rrokytskyy" <rrokytskyy@y...> wrote:
The configuration I use is Orionserver + firebirdsql(configured as a
data-source for orion) + firebird 1.0 superserver;
The datasource is configured as follows:
____________________
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="FirebirdTS"
location="jdbc/FirebirdTSCoreDS"
xa-location="jdbc/xa/FirebirdTSXADS"
ejb-location="jdbc/FirebirdTSDS"
connection-driver="org.firebirdsql.jdbc.FBDriver"
username="sysdba"
password="1234"
url="jdbc:firebirdsql:localhost/3050:/var/lib/interbase/topsport/TOPSPORT.G=
DB"
inactivity-timeout="30"
/>
____________________
and i'm connecting to it:
____________________________________________________________
InitialContext ic=new InitialContext();
Datasource ds=(Datasource) ic.lookup("jdbc/FirebirdTSDS");
____________________________________________________________
> Hi,k, I understand that but i just don't know how i could do that :(
>
> > "Presedintele LPF l-a indicat pe Dragos, fiul fostului presedinte
> > dinamovist Vasile Ianul, drept martor la o discutie în care Cornel
> > Dinu a recunoscut "mocirla" de la Piatra Neamt. Martorul este mîna
> > dreaptã a lui Gigi Becali"
>
> In the word "dreaptã" you have letter that does not belong to a
> charset you specified on connection. You have to specify the correct
> charset in property lc_ctype.
The configuration I use is Orionserver + firebirdsql(configured as a
data-source for orion) + firebird 1.0 superserver;
The datasource is configured as follows:
____________________
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="FirebirdTS"
location="jdbc/FirebirdTSCoreDS"
xa-location="jdbc/xa/FirebirdTSXADS"
ejb-location="jdbc/FirebirdTSDS"
connection-driver="org.firebirdsql.jdbc.FBDriver"
username="sysdba"
password="1234"
url="jdbc:firebirdsql:localhost/3050:/var/lib/interbase/topsport/TOPSPORT.G=
DB"
inactivity-timeout="30"
/>
____________________
and i'm connecting to it:
____________________________________________________________
InitialContext ic=new InitialContext();
Datasource ds=(Datasource) ic.lookup("jdbc/FirebirdTSDS");
____________________________________________________________
>where do i set the lc_ctype=..... ?
> For example, when you have database (or column) defined with
> character set WIN1252, you have to set also the JDBC connection
> property to
>
> lc_ctype=WIN1252
>
> otherwise you will get such exceptions.
>
> Best regards,
> Roman Rokytskyy