[LUGOS-PROG] JSP & MYSQL in SLOVENSKI SUMNIKI

[Peter Valencic]

S spodnjim programom dobim (sumnike)...   z istim pod tomcatom (s tem da
laufajo kot JSP) pa ne dobim sumnikov ampak cisto drugacne asci znake.....

1. Zdej ne vem, ali obstaja kaksna nastavitev, da spremenim LOCALE od
Tomcata,
2. Mogoce obstaja kaksen trik z paketom sun.io.*  (kjer je en kup
konverterjev med Char2Byte in obratno)

primer:
--------------------------------------

 import java.sql.*;
 import sun.io.*;
 public class Startek {

  public Startek() {
  }
  public static void main(String[] args)
  {

   try
   {
    System.out.println("begin...");
    Class.forName("org.gjt.mm.mysql.Driver");
    Connection connection =
DriverManager.getConnection("jdbc:mysql://192.168.80.12:3306/pero");
    Statement statement = connection.createStatement();
    ResultSet resultset = statement.executeQuery("SELECT * FROM tabelca");

     while( resultset.next() )
     {
           System.out.println( resultset.getString(2) + " " );
           char[] ch = resultset.getString(2).toCharArray();
            for (int i=0; i<ch.length; i++)
            {
              System.out.print(ch[i]);
            }
     }
         resultset.close();
         statement.close();
         connection.close();
    System.out.println("end...");
   }
   catch(Exception e)
   {
      System.out.println("Napakca: "+e.toString());
   }
}
}

-----------------------------------

----- Original Message -----
From: "Peter Valencic" <valencic at e-tree.com>
To: <lugos-prog at lugos.si>
Sent: Thursday, October 25, 2001 11:31 AM
Subject: Re: [LUGOS-PROG] JSP & MYSQL in SLOVENSKI SUMNIKI


> hmmm...
> ce isti program pozenem brez tomcata  (kot normalno aplikacijo) dobim
> c,s,z...
>
> Mislim, da mora biti kaksen locale nastavitev pod Tomcatom...
>
>
>
> ----- Original Message -----
> From: "Rok Krulec" <Rok.Krulec at acm.org>
> To: <lugos-prog at lugos.si>
> Sent: Thursday, October 25, 2001 10:38 AM
> Subject: Re: [LUGOS-PROG] JSP & MYSQL in SLOVENSKI SUMNIKI
>
>
> > Nebi bilo slabo, ce bi poskusil v MySQL bazo preko MySQL admina =
> > web interface za MySQL, dodati kaksen sumnik in potem pregledati, ce ga
> > je zapisalo, saj bi tako lahko ugotovil ali je napaka v MySQL ali v
> Tomcat.
> >
> > Sicer nisem nek strokovnjak ampak le: ali JAVA ne uporablja unicode = 2
> byta za eno crko ?
> >
> > On Thu, 25 Oct 2001 valencic at e-tree.com wrote:
> > > Lep pozdrav!
> > > No... kot ste mi svetovali sem bazo nastavil na pravilni encoding..
> > >
> > > V konzoli od Tomcat-a dobim (namesto sumnikov 'kvake' (asci znake)
> > > v generiranem HTML-ju pa dobim povsod ??? (vprasaje).. Torej tam kjer
> morajo biti sumniki se pojavijo ?
> > >
> > > ali ve kdo za kaksno resitev?  mogoce kaksen charToByte converter  ali
> sprememba iz enega nabora znakov v drugi...?
> > > Al je to Tomcatovo maslo???
> >
> > Rok Krulec
> >
> > Portoroz, 25.Oct 2001 @ 10:32 CET
> > Public GnuPG key @ http://rok.fpp.edu/pgp.key
> >
>