Remove unicode from SQL

From: Keith (mcgillivrayk_at_prodigy.net)
Date: 08/21/04 

Date: 20 Aug 2004 18:58:48 -0700

When using Jturbo 3.0 JDBC driver we are seeing the SQl sent to MS SQL
Server 2000 with Unicode N prepended to the string parameters.

Example:
Parameterized SQL: Select name, address, phone from myaddresstable
where name = ?

Resulting SQL:
Select name, address, phone from myaddresstable where name = N'myname'

The collation settings are set to Latin1_General_BIN and the JTurbo
connection string has the charset=Cp1252.

The string fields are of Char type, not nchar.

We are using the setString method on the preparedstatement.

The execution plans on these queries are showing that the indexes are
not being used because of the conversion that needs to be done.

Any ideas?
Thanks in advance for any help on this.

Relevant Pages

  • Re: Remove unicode from SQL
    ... > When using Jturbo 3.0 JDBC driver we are seeing the SQl sent to MS SQL ... > Server 2000 with Unicode N prepended to the string parameters. ... Have you tried the jTDS JDBC driver? ...
    (comp.lang.java.databases)
  • Re: Problems with Delete Command
    ... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need help with Code Please!!!
    ... posted in response to my last post was some SQL, but this is not the SQL that ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)
  • RE: Web Part and Access database
    ... I dont know if it is possible to connect to access,but you can download SQL ... Server Error in '/Webparts' Application. ... The connection string specifies a local Sql Server Express instance ... String user, String password, Boolean trusted, String connectionString) ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: INDEXES: BTRIEVE vs EXTFH (cobol)
    ... In SQL, you can specify just about anything, but at the lower MKDE ... the engine has to pick the right Btrieve ... When COBOL needs to find this value, it knows that the key is a string. ...
    (comp.databases.btrieve)