Home > Archive > SQL Server JDBC > July 2005 > SQLServer JDBC Encoding Conversion









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQLServer JDBC Encoding Conversion
JDBC driver Gen Info

2005-07-12, 3:23 am

can anyone help me, i just need to confirm if the SQLServer driver for JDBC
supports Automatic Encoding Conversion?? THX!
brian

2005-07-12, 1:23 pm



JDBC driver Gen Info wrote:
> can anyone help me, i just need to confirm if the SQLServer driver for JDBC
> supports Automatic Encoding Conversion?? THX!


Yes, the driver does indeed support automatic encoding conversion.

Multi-lingual applications can be developed on any operating system
platform with JDBC using the Microsoft SQL Server driver for JDBC to
access both Unicode and non-Unicode enabled databases. Internally, Java
applications use UTF-16 Unicode encoding for string data. When fetching
data, the Microsoft SQL Server driver for JDBC automatically performs
the conversion from the character encoding used by the database to
UTF-16. Similarly, when inserting or updating data in the database, the
drivers automatically convert UTF-16 encoding to the character encoding
used by the database.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com