Java unable to read chinese characters from Db2 Database
up vote
0
down vote
favorite
I am trying to read from Java application Chinese characters from Db2 database
Db2 database configuration
DB2 database XDSN3T configuration:
with DB2 CLP data are displayed correctly
also from another delphi application chinese data are correct
To obtain this I set:
- Regional and language options, Advanced, non unicode programs --> Chinese RPC
non unicode programs:
- enviroment variables, DB2CODEPAGE = 1252
db2codepage:
Only Java is not able to display data correctly --> ÃæÁÏ¡¢¸¨ÁÏ¡¢¸½¼þ
Maybe something related to JDBC..
java db2 character
edited Nov 8 at 23:18
Al Fahad
735620
asked Nov 8 at 16:11
Bruno It
1
add a comment |
up vote
0
down vote
favorite
I am trying to read from Java application Chinese characters from Db2 database
Db2 database configuration
DB2 database XDSN3T configuration:
with DB2 CLP data are displayed correctly
also from another delphi application chinese data are correct
To obtain this I set:
- Regional and language options, Advanced, non unicode programs --> Chinese RPC
non unicode programs:
- enviroment variables, DB2CODEPAGE = 1252
db2codepage:
Only Java is not able to display data correctly --> ÃæÁÏ¡¢¸¨ÁÏ¡¢¸½¼þ
Maybe something related to JDBC..
java db2 character
edited Nov 8 at 23:18
Al Fahad
735620
asked Nov 8 at 16:11
Bruno It
1
Please add the code to fetch the data from the DB
– JFPicard
Nov 8 at 16:17
Nota nota = new Nota();
– Bruno It
Nov 9 at 10:45
nota.Nota = rs.getString("QUANNOTA");
– Bruno It
Nov 9 at 10:45
It's not a Java problem. Seems that the font your tool uses can't render these characters.
– Mark Barinstein
Nov 9 at 15:26
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am trying to read from Java application Chinese characters from Db2 database
Db2 database configuration
DB2 database XDSN3T configuration:
with DB2 CLP data are displayed correctly
also from another delphi application chinese data are correct
To obtain this I set:
- Regional and language options, Advanced, non unicode programs --> Chinese RPC
non unicode programs:
- enviroment variables, DB2CODEPAGE = 1252
db2codepage:
Only Java is not able to display data correctly --> ÃæÁÏ¡¢¸¨ÁÏ¡¢¸½¼þ
Maybe something related to JDBC..
java db2 character
edited Nov 8 at 23:18
Al Fahad
735620
asked Nov 8 at 16:11
Bruno It
1
I am trying to read from Java application Chinese characters from Db2 database
Db2 database configuration
DB2 database XDSN3T configuration:
with DB2 CLP data are displayed correctly
also from another delphi application chinese data are correct
To obtain this I set:
- Regional and language options, Advanced, non unicode programs --> Chinese RPC
non unicode programs:
- enviroment variables, DB2CODEPAGE = 1252
db2codepage:
Only Java is not able to display data correctly --> ÃæÁÏ¡¢¸¨ÁÏ¡¢¸½¼þ
Maybe something related to JDBC..
java db2 character
java db2 character
edited Nov 8 at 23:18
Al Fahad
735620
asked Nov 8 at 16:11
Bruno It
1
edited Nov 8 at 23:18
Al Fahad
735620
asked Nov 8 at 16:11
Bruno It
1
edited Nov 8 at 23:18
Al Fahad
735620
edited Nov 8 at 23:18
Al Fahad
735620
edited Nov 8 at 23:18
Al Fahad
735620
735620
asked Nov 8 at 16:11
Bruno It
1
asked Nov 8 at 16:11
Bruno It
1
asked Nov 8 at 16:11
Bruno It
1
1
Please add the code to fetch the data from the DB
– JFPicard
Nov 8 at 16:17
Nota nota = new Nota();
– Bruno It
Nov 9 at 10:45
nota.Nota = rs.getString("QUANNOTA");
– Bruno It
Nov 9 at 10:45
It's not a Java problem. Seems that the font your tool uses can't render these characters.
– Mark Barinstein
Nov 9 at 15:26
add a comment |
Please add the code to fetch the data from the DB
– JFPicard
Nov 8 at 16:17
Nota nota = new Nota();
– Bruno It
Nov 9 at 10:45
nota.Nota = rs.getString("QUANNOTA");
– Bruno It
Nov 9 at 10:45
It's not a Java problem. Seems that the font your tool uses can't render these characters.
– Mark Barinstein
Nov 9 at 15:26
Please add the code to fetch the data from the DB
– JFPicard
Nov 8 at 16:17
Please add the code to fetch the data from the DB
– JFPicard
Nov 8 at 16:17
Nota nota = new Nota();
– Bruno It
Nov 9 at 10:45
Nota nota = new Nota();
– Bruno It
Nov 9 at 10:45
nota.Nota = rs.getString("QUANNOTA");
– Bruno It
Nov 9 at 10:45
nota.Nota = rs.getString("QUANNOTA");
– Bruno It
Nov 9 at 10:45
It's not a Java problem. Seems that the font your tool uses can't render these characters.
– Mark Barinstein
Nov 9 at 15:26
It's not a Java problem. Seems that the font your tool uses can't render these characters.
– Mark Barinstein
Nov 9 at 15:26
add a comment |
2 Answers
2
active
oldest
votes
up vote
0
down vote
When you open the connection you can define the encoding, not sure if it's available for chinese. but here is an example:
Connection con = DriverManager.getConnection("jdbc:mysql://examplehost:8888/dbname?useUnicode=yes&characterEncoding=UTF-8","user", "pass");
answered Nov 8 at 16:23
Ângelo D
196
unfortunately it doesn't worj with db2..
– Bruno It
Nov 8 at 17:26
add a comment |
up vote
0
down vote
As it's been said the encoding might be an issue; characters in java are stored using UTF-16 encoding which has itself some issues regarding the encoding of Chinese (also some emoji) characters.
You can find the character list for UTF-16 here: https://www.fileformat.info/info/charset/UTF-16/list.htm
The issue with UTF-16 comes when characters cannot be encoded using a single 16-bit unit; these characters are encoded using two 16-bit units which is called a surrogate pair. see: https://docs.oracle.com/javase/6/docs/api/java/lang/Character.html#unicode
Sorry I cannot provide a complete answer, but I hope this will help
answered Nov 8 at 17:02
UmshiniWami
618
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
When you open the connection you can define the encoding, not sure if it's available for chinese. but here is an example:
Connection con = DriverManager.getConnection("jdbc:mysql://examplehost:8888/dbname?useUnicode=yes&characterEncoding=UTF-8","user", "pass");
answered Nov 8 at 16:23
Ângelo D
196
unfortunately it doesn't worj with db2..
– Bruno It
Nov 8 at 17:26
add a comment |
up vote
0
down vote
When you open the connection you can define the encoding, not sure if it's available for chinese. but here is an example:
Connection con = DriverManager.getConnection("jdbc:mysql://examplehost:8888/dbname?useUnicode=yes&characterEncoding=UTF-8","user", "pass");
answered Nov 8 at 16:23
Ângelo D
196
unfortunately it doesn't worj with db2..
– Bruno It
Nov 8 at 17:26
add a comment |
up vote
0
down vote
up vote
0
down vote
When you open the connection you can define the encoding, not sure if it's available for chinese. but here is an example:
Connection con = DriverManager.getConnection("jdbc:mysql://examplehost:8888/dbname?useUnicode=yes&characterEncoding=UTF-8","user", "pass");
answered Nov 8 at 16:23
Ângelo D
196
When you open the connection you can define the encoding, not sure if it's available for chinese. but here is an example:
Connection con = DriverManager.getConnection("jdbc:mysql://examplehost:8888/dbname?useUnicode=yes&characterEncoding=UTF-8","user", "pass");
answered Nov 8 at 16:23
Ângelo D
196
answered Nov 8 at 16:23
Ângelo D
196
answered Nov 8 at 16:23
Ângelo D
196
answered Nov 8 at 16:23
Ângelo D
196
196
unfortunately it doesn't worj with db2..
– Bruno It
Nov 8 at 17:26
add a comment |
unfortunately it doesn't worj with db2..
– Bruno It
Nov 8 at 17:26
unfortunately it doesn't worj with db2..
– Bruno It
Nov 8 at 17:26
unfortunately it doesn't worj with db2..
– Bruno It
Nov 8 at 17:26
add a comment |
up vote
0
down vote
As it's been said the encoding might be an issue; characters in java are stored using UTF-16 encoding which has itself some issues regarding the encoding of Chinese (also some emoji) characters.
You can find the character list for UTF-16 here: https://www.fileformat.info/info/charset/UTF-16/list.htm
The issue with UTF-16 comes when characters cannot be encoded using a single 16-bit unit; these characters are encoded using two 16-bit units which is called a surrogate pair. see: https://docs.oracle.com/javase/6/docs/api/java/lang/Character.html#unicode
Sorry I cannot provide a complete answer, but I hope this will help
answered Nov 8 at 17:02
UmshiniWami
618
add a comment |
up vote
0
down vote
As it's been said the encoding might be an issue; characters in java are stored using UTF-16 encoding which has itself some issues regarding the encoding of Chinese (also some emoji) characters.
You can find the character list for UTF-16 here: https://www.fileformat.info/info/charset/UTF-16/list.htm
The issue with UTF-16 comes when characters cannot be encoded using a single 16-bit unit; these characters are encoded using two 16-bit units which is called a surrogate pair. see: https://docs.oracle.com/javase/6/docs/api/java/lang/Character.html#unicode
Sorry I cannot provide a complete answer, but I hope this will help
answered Nov 8 at 17:02
UmshiniWami
618
add a comment |
up vote
0
down vote
up vote
0
down vote
As it's been said the encoding might be an issue; characters in java are stored using UTF-16 encoding which has itself some issues regarding the encoding of Chinese (also some emoji) characters.
You can find the character list for UTF-16 here: https://www.fileformat.info/info/charset/UTF-16/list.htm
The issue with UTF-16 comes when characters cannot be encoded using a single 16-bit unit; these characters are encoded using two 16-bit units which is called a surrogate pair. see: https://docs.oracle.com/javase/6/docs/api/java/lang/Character.html#unicode
Sorry I cannot provide a complete answer, but I hope this will help
answered Nov 8 at 17:02
UmshiniWami
618
As it's been said the encoding might be an issue; characters in java are stored using UTF-16 encoding which has itself some issues regarding the encoding of Chinese (also some emoji) characters.
You can find the character list for UTF-16 here: https://www.fileformat.info/info/charset/UTF-16/list.htm
The issue with UTF-16 comes when characters cannot be encoded using a single 16-bit unit; these characters are encoded using two 16-bit units which is called a surrogate pair. see: https://docs.oracle.com/javase/6/docs/api/java/lang/Character.html#unicode
Sorry I cannot provide a complete answer, but I hope this will help
answered Nov 8 at 17:02
UmshiniWami
618
answered Nov 8 at 17:02
UmshiniWami
618
answered Nov 8 at 17:02
UmshiniWami
618
answered Nov 8 at 17:02
UmshiniWami
618
618
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53211736%2fjava-unable-to-read-chinese-characters-from-db2-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Please add the code to fetch the data from the DB
– JFPicard
Nov 8 at 16:17
Nota nota = new Nota();
– Bruno It
Nov 9 at 10:45
nota.Nota = rs.getString("QUANNOTA");
– Bruno It
Nov 9 at 10:45
It's not a Java problem. Seems that the font your tool uses can't render these characters.
– Mark Barinstein
Nov 9 at 15:26