Re: Remove unicode from SQL

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 08/21/04

  • Next message: Luke Webber: "Re: JTurbor driver property for removing Unicode in SQL" 
    Date: Sat, 21 Aug 2004 08:31:41 -0700
To: Keith <mcgillivrayk@prodigy.net>

    Keith wrote:

    > Joe Weinstein <joeNOSPAM@bea.com> wrote in message news:<4126D9C3.8050607@bea.com>...
    >
    >>There should be a driver property you can define to stop the driver doing
    >>that. All commercial drivers I know of do. The default should be to do as the
    >>driver does, to ensure that any valid Java string (16-bit characters) get sent
    >>to the DBMS unchanged. However, for varchar values and indexes it makes the
    >>DBMS have to convert back to varchar, and the conversion means that the DBMS
    >>will skip indexes and do table scans (slow).
    >>Joe Weinstein at BEA
    >>
    >
    > Thanks Joe.
    > Is this the property that you are refering to on JTurbo?
    > SendStringParametersAsUnicode={true | false}.
    > Determines whether string parameters are sent to the SQL
    > Server database in Unicode or in the default character
    > encoding of the database. True means that string parameters are sent
    > to SQL Server in Unicode.
    > False means that they are sent in the default encoding.

    That's it. Set it to false.
    Joe

  • Next message: Luke Webber: "Re: JTurbor driver property for removing Unicode in SQL"

    Relevant Pages

    • Re: Remove unicode from SQL
      ... > There should be a driver property you can define to stop the driver doing ... > DBMS have to convert back to varchar, and the conversion means that the DBMS ... Determines whether string parameters are sent to the SQL ...
      (comp.lang.java.databases)
    • Re: DBI and character sets (yet again)
      ... >> If a list of charset behaviors for each DBD is needed, ... And driver authors, feel free to forward to me (and/or thlis ... Most applications only work with one character set encoding ... the dbms/driver returns UTF8, thats all great. ...
      (perl.dbi.users)
    • Re: SQLServer JDBC Encoding Conversion
      ... i just need to confirm if the SQLServer driver for JDBC ... the driver does indeed support automatic encoding conversion. ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: Java vs SQL Server float datatype limits
      ... table ischecked for data purity it will of course produce errors. ... double into a float column. ... corresponds correctly to the DBMS column. ... So I would have imagined that an SQL Server driver either handle the ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: Dont do DDL with PreparedStatement with Oracle!
      ... The driver got the expected ... response packet from the DBMS, ... in fact OCI mark the DDL for re-parsing, ... no-op on subsequent execution. ...
      (comp.lang.java.databases)