Re: Problem with accessing Russian UTF database

Hi Ronald,

This is the JSP problem, since you need to set the correct
encoding on the JSP.
<%(at)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
>
>
>