Menu
▾
▴
Re: [Firebird-odbc-devel] Turkish Charcter Problem :: JDBC
|
From: JFBPROG <jxa...@ya...> - 2004-05-22 06:38:54
|
I found this "lc_ctype=ISO8859_9" but when i execute this JSP page it gives
exception.
"C:\\Program Files\\Firebird\\Firebird_1_5\\bin\\HTTPLOGS.GDB?
lc_ctype=ISO8859_9"
Then when i run JSP page it gives this error message, please tell me
what can do ? Exception :
org.apache.jasper.JasperException: GDS Exception. 335544321.
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
""Webmaster"" <jxa...@ya...>, iletide þunu yazdý
news:c8mon3$t86$1...@ne......
> I use Firebird 1.5 Beta and i wrote JSP page like ;
>
> File Name : Test.jsp
>
> <%@ page contentType="text/html; charset=CP1254" %>
> <%@ page import="java.sql.*" %>
>
> <html>
>
> <head>
> <meta http-equiv="Content-Language" content="tr">
> <meta name="GENERATOR" content="Microsoft FrontPage 5.0">
> <meta name="ProgId" content="FrontPage.Editor.Document">
> <meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
> <title>FireBird 1.5 Beta</title>
>
>
> <%
> //DriverManager.registerDriver(new org.firebirdsql.jdbc.FBDriver());
> Class.forName("org.firebirdsql.jdbc.FBDriver");
>
> String user = "sysdba";
> String password = "masterkey";
> String database = "C:\\Program
> Files\\Firebird\\Firebird_1_5\\bin\\HTTPLOGS.GDB";
>
> Connection conn =
> DriverManager.getConnection("jdbc:firebirdsql:localhost/3050:" + database,
> user, password);
>
> Statement stmt = conn.createStatement ();
>
> ResultSet rset = stmt.executeQuery("SELECT * FROM cities");
>
> while (rset.next())
> out.println(rset.getString ("CITY_CODE") + " " +
> rset.getString("CITY_NAME") + "<br>");
>
> out.println ("<br><br><br>FireBird 1.5 JDBC installation is
correct.");
>
> rset.close();
> stmt.close();
> conn.close();
> %>
>
> ""Peter Jacobi"" <pj...@wa...>, iletide sunu yazdi
> news:40AE7048.22532.D07ED@localhost...
> > > I run a query in the JSP pages or JAVA application and then when i
> print
> > > the output of resultset; my Turkish characters are not shown
correctly.
> How
> > > can i set characterset in FireBird ? I tried this line : <%@ page
> > > contentType="text/html; charset=CP1254" %> in JSP pages but problem
> > > continues.
> >
> > Can you please provide some more information, like what's your
> > database's DDL, whether you can get the Turkish characters straight
> > out of the database, when using ISQL or some GUI Tool? And also the
> > resulting HTML page which doesn't display correctly. Preferably zipped
> > to avoid character set confusion in transmission.
> >
> > Regards,
> > Peter Jacobi
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: Oracle 10g
> > Get certified on the hottest thing ever to hit the market... Oracle 10g.
> > Take an Oracle 10g class now, and we'll give you the exam FREE.
> > http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> > _______________________________________________
> > Firebird-odbc-devel mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
> >
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
|