3 Replies Latest reply on Feb 10, 2004 9:44 AM by dabrigo

    MySQL Greek characters

    dabrigo

      Hi all!

      how can configure my mysql datasource to use the greek encoding?
      BTW, this must be compatible with other languages like swedish, dutch, norwegian and so on...is UTF-8 the solution? I'm using MySQL 4.

      thanks for any reply! :)

        • 1. Re: MySQL Greek characters
          jonlee

          It has been a long time since I tried this as I am not a MySQL user by preference:

          URL:jdbc:mysql://localhost/mydb?useUnicode=true&characterEncoding=UTF-8


          This should allow the use of unicode strings. Have you tried that?

          I'm not sure whether the connection-property tags with the latest JBoss releases work. You can experiment.

          Hope that might help.

          • 2. Re: MySQL Greek characters
            dabrigo

            Tnx Jonlee!
            i'll give it a try as soon as possible and report the results.

            • 3. Re: MySQL Greek characters
              dabrigo

              a little time has passed but my problem still exists :(
              i have tried with the connection string properties as suggested by jonlee:
              now the string are written apparently correct in the db but, when i read them back, i get a series of ??????? instead of greek characters.
              I'm a little stuck :-\