Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
MIME-Version: 1.0
In-Reply-To: <1495194340137-13024.post@n6.nabble.com>
References: <1495194340137-13024.post@n6.nabble.com>
From: Igor Sapego <isapego@gridgain.com>
Date: Fri, 19 May 2017 15:25:28 +0300
Message-ID: <CALOGAozT7p7dYnFc5o_bQsDqKTSzY2nQhj8W=guTtVXa+oH54A@mail.gmail.com>
Subject: Re: ODBC driver error during SELECT query for string data type
To: user <user@ignite.apache.org>
Content-Type: multipart/alternative; boundary="001a1141067ae3297c054fdf9dfe"
archived-at: Fri, 19 May 2017 12:25:41 -0000

--001a1141067ae3297c054fdf9dfe
Content-Type: text/plain; charset="UTF-8"

Hi,

Can you provide a bit more info about your code and library you have used
to connect to ODBC?

We have not tested our driver with python so it seems very interesting, but
the only thing I can point you to right now is that our ODBC driver uses
UTF-8, not UTF-16 encoding. I'm not sure if encoding is specified in
application or library code though.


Best Regards,
Igor

On Fri, May 19, 2017 at 2:45 PM, rishi007bansod <rishi007bansod@gmail.com>
wrote:

> Hi,
>     While fetching string fields using ODBC driver from ignite cache in
> python, I am getting following error,
>
> Traceback (most recent call last):
>   File "pythonOdbc.py", line 13, in <module>
>     row = cursor.fetchone()
> UnicodeDecodeError: 'utf16' codec can't decode byte 0x00 in position 2:
> truncated data
>
>
> ODBC connection string i have used is :
> connection_string=
> 'DRIVER=/usr/local/lib/libignite-odbc.so;ADDRESS=
> localhost:10800;CACHE=Person'
>
> Is there any encoding parameter that I need to set to remove above error?
>
> Thanks
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/ODBC-driver-error-during-SELECT-
> query-for-string-data-type-tp13024.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>

--001a1141067ae3297c054fdf9dfe
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>Can you provide a bit more info abo=
ut your code and library you have used</div><div>to connect to ODBC?</div><=
div><br></div><div>We have not tested our driver with python so it seems ve=
ry interesting, but</div><div>the only thing I can point you to right now i=
s that our ODBC driver uses</div><div>UTF-8, not UTF-16 encoding. I&#39;m n=
ot sure if encoding is specified in</div><div>application or library code t=
hough.</div><div><br></div></div><div class=3D"gmail_extra"><br clear=3D"al=
l"><div><div class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><=
div dir=3D"ltr"><div>Best Regards,</div><div>Igor</div></div></div></div>
<br><div class=3D"gmail_quote">On Fri, May 19, 2017 at 2:45 PM, rishi007ban=
sod <span dir=3D"ltr">&lt;<a href=3D"mailto:rishi007bansod@gmail.com" targe=
t=3D"_blank">rishi007bansod@gmail.com</a>&gt;</span> wrote:<br><blockquote =
class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid=
;padding-left:1ex">Hi,<br>
=C2=A0 =C2=A0 While fetching string fields using ODBC driver from ignite ca=
che in<br>
python, I am getting following error,<br>
<br>
Traceback (most recent call last):<br>
=C2=A0 File &quot;pythonOdbc.py&quot;, line 13, in &lt;module&gt;<br>
=C2=A0 =C2=A0 row =3D cursor.fetchone()<br>
UnicodeDecodeError: &#39;utf16&#39; codec can&#39;t decode byte 0x00 in pos=
ition 2:<br>
truncated data<br>
<br>
<br>
ODBC connection string i have used is :<br>
connection_string=3D<br>
&#39;DRIVER=3D/usr/local/lib/<wbr>libignite-odbc.so;ADDRESS=3D<wbr>localhos=
t:10800;CACHE=3DPerson&#39;<br>
<br>
Is there any encoding parameter that I need to set to remove above error?<b=
r>
<br>
Thanks<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href=3D"http://apache-ignite-users.70518.x=
6.nabble.com/ODBC-driver-error-during-SELECT-query-for-string-data-type-tp1=
3024.html" rel=3D"noreferrer" target=3D"_blank">http://apache-ignite-users.=
<wbr>70518.x6.nabble.com/ODBC-<wbr>driver-error-during-SELECT-<wbr>query-fo=
r-string-data-type-<wbr>tp13024.html</a><br>
Sent from the Apache Ignite Users mailing list archive at Nabble.com.<br>
</blockquote></div><br></div>

--001a1141067ae3297c054fdf9dfe--