Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

800381
Assuming you're using Studio 12.3, the compile-time options are one of "-xcode=pic13" or "-xcode=pic32".

The deprecated options are "-Kpic" and "-KPIC".
user458823
Thank you, that was indeed the fix. Here is a summary I sent to the mod_perl mailing list:

We could successfully build 64 bit apache with the configuration options so kindly shared by John D. Groenveld, also, in order to build mod_perl on 64 bit perl we had to recompile perl 64 bit, these are the flags we used:
./Configure -ders -Dcc=cc -Ud_sigsetjmp -Uinstallusrbinperl -Ulocincpth= -Uloclibpth= -Duse64bitint -Duse64bitall -Ud_strerror_r -Ud_signbit -Duselargefiles -Dprefix=/usr/perl10/5.18.0 -Accflags="-xcode=pic32"

The noteworthy flags in above ./Configure are -Accflags="-xcode=pic32" in ./Configure the "-Accflags=" passes the flags you want to the C compiler, in our case we wanted the -xcode=x32 flag to be passed to the C compiler(solaris studio compiler) because of the error message we were getting:
"symbol PL_check: relocations based on the ABS44 coding model can not be used in building a shared object"
So to build for "shared object" support, perl 64 bit had to be recompiled with the -xcode=pic32 flag

Building mod_perl was then seamless, perl Makefile.PL (NOTE: the perl is teh perl which was built with above arguments.
make, make install.


It is important to use the SAME COMPILER for everything. We are using Solaris Studio compiler, which, John D. Grovenfeld also used. We needed DBD::mysql to talk to the MYSql database, now Mysql was installed on Solaris 10 via pkgadd and is a 64 bit application. Needless to say it is safe to assume that Oracle built it using the Solaris Studio compiler......

DBD::mysql was built using MCPAN shell.....

Hope this helps someone in the future.......

Thanks to John D. Groenveld, The other resources online, and to my boss...
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 6 2004
Added on Aug 11 2004
5 comments
267 views