Re: Problem with accessing Russian UTF database - Mailing list pgsql-jdbc

From Alexander Panzhin
Subject Re: Problem with accessing Russian UTF database
Date
Msg-id 492DEF08.8000806@gmail.com
Whole thread Raw
In response to Re: Problem with accessing Russian UTF database  ("Ronald Vyhmeister" <rvyhmeister@aiias.edu>)
List pgsql-jdbc
Hi Ronald,

      This is the JSP problem, since you need to set the correct
encoding on the JSP.
      <%@page pageEncoding="UTF-8"%> - something like this should help.
      I have a UTF8 coded database that handles multiple
scripts(Cyrillic, Latin and Georgian) and PostgeSQL has not in 5 years
shown a problem with any store/retrieve problems with UTF8 encoding. If
you have any problems, this discussion should probably be directed to
people that handle JSP and/or Java questions.

Ronald Vyhmeister wrote:
> Oliver and all,
>
> I see that there is a Java problem...  I limited my code to this:
>
> <%@ page import="java.util.*" %>
> <%
>
>     Locale locale = Locale.getDefault();
>     locale = new Locale("ru", "RU");
>     Locale.setDefault(locale);
>     String someString =  'фывфывафыва';
>     char[] rawCharacters = someString.toCharArray();
>     for (int i = 0; i < rawCharacters.length; ++i)
>         System.out.println("#" + i + " = " +
> Integer.toHexString((int)rawCharacters[i]));
> %>
>
> And tomcat cannot handle the string
>
> An error occurred at line: 2 in the jsp file: /iutus/unicode.jsp
> Invalid character constant
> 1: <%@ page import="java.util.*" %>
> 2: <%
> 3:
> 4:     Locale locale = Locale.getDefault();
> 5:     locale = new Locale("ru", "RU");
>
>
> If I replace the String statement with this:
>
> String someString =  'ф';
>
> The error changes to:
>
> Type mismatch: cannot convert from char to String
>
> So I thought I'd be smart and just define it as a char variable, but now it
> says:
>
> Invalid character constant
>
> So I've just done them one at a time for 5 characters:
>
> ф = f4
> ы = fb
> в = e2
> ц = f6
> л = eb
>
> It would appear to me that whatever I'm entering is NOT Unicode... so how do
> I force Windows/Linux/Mac to use Unicode for input/output?  I'm trying to
> deal with an inherited app... and I'm no java guru...
>
> Ron
>
>
>



Attachment

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Problem with accessing Russian UTF database
Next
From: Kris Jurka
Date:
Subject: Re: GSSAPI support [was: Re: New drivers released]