
November 1st, 2004, 07:30 AM
|
|
Registered User
|
|
Join Date: Oct 2004
Posts: 7
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Problem in Searching Japanese Strings
Hello All,
I have Firebird 1.5 Database. I am trying to search for names from the Database table which start from "Tanaka" (String in Japanese Characters) from my Java Code.
Ex : Select * from Employee where name like 'TANAKA'
When i execute this I get a Exception :-
"Cannot Transliterate Character between Character Sets"
1) Database Character Set is :- SJIS_0208
2) I can very well see the Japanese Data in the Database through the Flame Robin IDE.
3) But the Select Query Gives the same result (IBPP exception)
4) When i use the EMS IBManager IDE, i can successfully execute the query !!!
Question
---------
1) Do i need to specify the character set again while connecting to the database ? If yes ... how to specify it to the JDBC Driver ?
Please Help !!!
- Sanket
|