Re: SQLServer JDBC Encoding Conversion

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance





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.

.



Relevant Pages

  • Re: Acessing MS sql from Solaris
    ... Microsoft SQL Server 2000 Driver for JDBC ... delete both the log.txt file and the installation directory. ...
    (comp.unix.shell)
  • Re: Acessing MS sql from Solaris
    ... Microsoft SQL Server 2000 Driver for JDBC ... delete both the log.txt file and the installation directory. ...
    (comp.unix.shell)
  • Re: Possible Type Conversion Defect
    ... Specifically we are breaking due to the lack of conversion from BIGINT to ... Microsoft SQL Server 2000 JDBC driver. ... I'll agree that the JDBC API specifications could be a bit more precise. ... a JDBC driver attempts to convert the underlying data to the Java ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Ora10 JDBC Driver with TIMESTAMP WITH LOCAL TIME ZONE
    ... >> Robert Klemme wrote: ... >>> driver is the newest driver for Ora 10.2. ... >>> JDBC driver I suspect it's a JDBC driver issue. ... > sets the session time zone of the connection and saves the session ...
    (comp.databases.oracle.misc)
  • Re: federate several datasources
    ... >>I want to federate several physical datasources, ... >>its JDBC driver. ... >>My idea is that this aggregator could be implemented as a special JDBC ... open-source databases such as MySQL, PostGreSQL, but this is outside the ...
    (comp.lang.java.databases)