Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Server nvarchar and JDBC

843854Aug 11 2004 — edited Nov 8 2004
Hi to all,
My DBMS is SQL Server2000 and i created a table which has two columns. Two of them were defined as varchar, but when i wrote Turkish character, these characters automaticly were converted to the different characters. Because varchar does not support Unicode. So, I had to use nvarchar, but if i used nvarchar how can I match nvarchar values to the java.sql.Types. There is no matching values for SQL Server nvarchar type. So, that is my question, how can i write Turkish character to the SQL Server via application which uses JDBC API to connect to the SQL Server.

Regards
Bulent

Comments

thatJeffSmith-Oracle
Here's our documentation for Informix migrations
http://www.oracle.com/technetwork/products/migration/informix-085032.html
1010657
Hi im same situation.
but i not find driver JDBC of informix 11.50 for Oracle Migration Workbench
thatJeffSmith-Oracle
You won't be able to use the Migration Workbench or SQL Developer to assist with a migration using that version of Informix unfortunately.
1010657
OK, but, you could indicate some other tool?
thatJeffSmith-Oracle
Ispirer has a migration product, but it doesn't support 11 either, it goes to version 10 though.
Have a look at SQLines Data (http://www.sqlines.com/informix-to-oracle), the tool supports migration from Informix 11 to Oracle.

Dmitry
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 6 2004
Added on Aug 11 2004
#java-database-connectivity-jdbc
5 comments
293 views