RE: collation SQL_EBCDIC037_CP1_CS_AS
- From: evanba@xxxxxxxxxxxxxxxxxxxx (Evan T. Basalik (MSFT))
- Date: Tue, 11 Jul 2006 15:39:03 GMT
After some more internal testing, it looks like our SQL Server 2005 JDBC driver is improperly setting the codepage for that collation. We have filed a bug on
this issue. If you need further resolution beyond this, feel free to open a support ticket and we can pursue the possibility of getting a fix on a specific
timetable.
Evan
--------------------
X-Tomcat-ID: 395515774
References: <sWHhg.7613$Z67.1029@xxxxxxxxxxxxxxxxxxxx>
MIME-Version: 1.0
From: evanba@xxxxxxxxxxxxxxxxxxxx (Evan T. Basalik (MSFT))
Organization: Microsoft
Date: Tue, 20 Jun 2006 18:16:41 GMT
Subject: RE: collation SQL_EBCDIC037_CP1_CS_AS
Message-ID: <uXEMzWJlGHA.4928@xxxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.sqlserver.jdbcdriver
--------------------
From: "AdamG" <none@xxxxxxxxxxxxxxxxxx>border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newscon06.news.prodigy.com!prodigy.net!news-east.rr.com!news-
Newsgroups: microsoft.public.sqlserver.jdbcdriver
Subject: collation SQL_EBCDIC037_CP1_CS_AS
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
Message-ID: <sWHhg.7613$Z67.1029@xxxxxxxxxxxxxxxxxxxx>
Date: Wed, 07 Jun 2006 21:54:32 GMT
NNTP-Posting-Host: 204.210.35.61
X-Complaints-To: abuse@xxxxxx
X-Trace: tornado.socal.rr.com 1149717272 204.210.35.61 (Wed, 07 Jun 2006 14:54:32 PDT)
NNTP-Posting-Date: Wed, 07 Jun 2006 14:54:32 PDT
Organization: Road Runner High Speed Online http://www.rr.com
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!
feed-01.rdc-kc.rr.com!news.rr.com!cyclone2.kc.rr.com!news2.kc.rr.com!tornado.socal.rr.com.POSTED!53ab2750!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.jdbcdriver:7836
X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
I am running SQL Server 2005 and trying to connect to a DB with collation
set to SQL_EBCDIC037_CP1_CS_AS. On connection
(DriverManager.getConnection(url, userName, password); ) I am getting
"Codepage 0 is not supported by the Java environment." I am on JVM build
1.4.2_10-b03.
1) Has anyone else encountered this?
2) Will a JVM update help? 1.5? a later 1.4?
3) The end thing I am attempting to do is connect from an iSeries and have
the data sorted as if it was EBCDIC. Am I taking the wrong approach?
Thanks
Adam
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
.
- Prev by Date: Re: SQLServer 2000 Driver for JDBC]Error establishing socket
- Next by Date: Re: Advantages using 2005 JDBC Driver
- Previous by thread: JDBC and Virtual Machines
- Next by thread: RE: PreparedStatement.getParameterMetaData()
- Index(es):
Relevant Pages
|
Loading
