Encoding problem (getting data from database)

[2004 IR Help]

By: Kostya - bce77

Encoding problem (getting data from database)

2005-04-21 10:13

Database is using windows-1251 (Cyrillic) encoding. In windows I exports in pdf and xls without any problems.

But when I run exactly the same code under fedora core 3 (UTF-8) I see dots and white spaces.

Looks like someone (Jasper? or Java) transliterate data from database and parameters according to system default encoding.

So how can I change it?

p.s.

Static text looks fine in Russian in windows and Linux.

 

 

 

 

 

By: CleverFool - cleverfool

RE: Encoding problem (getting data from datab

2005-04-24 04:10

Думаю, что это делает Java. Какая база?

 

 

 

 

By: CleverFool - cleverfool

RE: Encoding problem (getting data from datab

2005-04-24 04:10

ijì¾, ??ë¥òŠ¡va. Êê¿ á§à¿Š

 

 

 

 

By: raghav - raghav_2004

RE: Encoding problem (getting data from database)

2005-04-24 22:44

Hay use this method:

 

static String NCR2UnicodeString(String str)

{

String ostr = new String();

int i1=0;

int i2=0;

 

while(i2<str.length())

{

i1 = str.indexOf("",i2);

if (i1 == -1 ) {

ostr += str.substring(i2, str.length());

break ;

}

ostr += str.substring(i2, i1);

i2 = str.indexOf(";", i1);

if (i2 == -1 ) {

ostr += str.substring(i1, str.length());

break ;

}

 

String tok = str.substring(i1+2, i2);

try {

int radix = 10 ;

if (tok.trim().charAt(0) == 'x') {

radix = 16 ;

tok = tok.substring(1,tok.length());

}

ostr += (char) Integer.parseInt(tok, radix);

} catch (NumberFormatException exp) {

ostr += '?' ;

}

i2++ ;

}

return ostr ;

}

 

Hope it works!

 

 

 

 

By: Kostya - bce77

RE: Encoding problem (getting data from datab

2005-04-25 03:14

Solution for database:

Set connection property "charSet" with appropriate value (for example: "Cp1251"). With jaybird driver the property is "lc_ctype" and value - "WIN1251"!

Actually I used something like this:

Properties p = new Properties();

p.put("user", user);

p.put("password", password);

p.put("lc_ctype", "WIN1251");

Class.forName(driver);

Connection conn = DriverManager.getConnection(connectString, p);

 

Solution for parameters from file (Cp1251):

BufferedReader file = new BufferedReader(new InputStreamReader(new FileInputStream(paramFileName), "Cp1251"));