3 Replies Latest reply on Nov 2, 2001 2:47 PM by caba

    Encoding issue with Interbase 6.01

    caba


      Hi

      I've got an issue with encoding. Problematic characters in Cp1250 from database are replaced by question marks.
      How should I configure jdbc connection, if I want to store data in Cp1250.
      In documentation, I found some instructions about setting properties for JDBC driver, but it doesn't function.


      My configuration is:

      ------JBoss--------

      JBoss-2.4.0_Tomcat-3.2.2 with Interbase 6.01

      ---jdbc driver-----

      I tried both drivers from Inprise

      lib\ext\interclient.jar
      lib\ext\interclient-core.jar - recommended in manual

      ----jboss.jcml-----


      interbase.interclient.Driver




      foo/DS
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      charSet=Cp1250
      jdbc:interbase://localhost/G:\database\Interbase\foo.gdb
      sysdba
      10
      masterkey
      true



      Have you got any idea?

        • 1. Re: Encoding issue with Interbase 6.01
          tsvetan

          Hi, I have a simillar problem. The only difference is that I'm using Cp1251.
          Does anybody have a idea how to resovle this problem?

          • 2. Re: Encoding issue with Interbase 6.01
            caba

            Hi again

            I'm looking for solution of this problem for a long time, but on whole Internet I couldn't find any.

            I think more people have the same problem.
            One man wrote me that he has similar problem with UTF-8.

            Could somebody helps me (us), please?

            Please...

            CABA

            • 3. Re: Encoding issue with Interbase 6.01
              caba

              So the solution is:

              jboss.jcml


              interbase.interclient.Driver



              foo/DS
              org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
              charSet=Cp1250;user=SYSDBA;password=masterkey
              jdbc:interbase://localhost/C:\database\foo.GDB