--e0cb4e887bb19429db04848e308e
Content-Type: text/plain; charset=ISO-8859-1
Hello PGSQL Team,
We have a serious problems changing the driver from postgresql to
postgresql unicode.
We are using postgre sql DB since long time.
There is a requirement for our application to insert Latin chars into
postgre. So, Changed driver from PostgreSQL to *PostgreSQL** UNICODE.*
There are quite a few issues occuring using this driver.
Issue 1: When we mention *BoolsAsChar**=1* in connection string, its
returning empty value instead of 1 or 0 based on true or false.
Issue 2: we are trying to fill dataset through OdbcDataAdapter.
Code Snippet:
OdbcDataAdapter odbcAdapt = new
OdbcDataAdapter("Select * from table1;"+ "Select * from table2;" ,
cdbConn.Conn);
odbcAdapt .Fill(dataset)
always dataset is returning 0 tables.
Can you please help us. If we change the driver from postgresql unicode to
postgresql will there be much differences in the behavior?
Please previous your valuable inputs.
Regards
Goutham J
--e0cb4e887bb19429db04848e308e
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><font color=3D"#000000" size=3D"2" face=3D"Tahoma">Hello=
=A0PGSQL Team,</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma"></font>=A0</div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">=A0=A0=A0=A0=A0=A0=A0We h=
ave a serious problems changing the driver from postgresql to postgresql un=
icode.</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">=A0=A0=A0=A0=A0=A0 We are=
using postgre sql DB since long time.</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">=A0=A0=A0=A0=A0=A0=A0</fo=
nt></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">=A0=A0=A0=A0=A0=A0 There =
is a requirement for our application to insert Latin chars into postgre. So=
, Changed driver from PostgreSQL to <strong>PostgreSQL</strong><strong> UNI=
CODE.</strong></font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">=A0=A0=A0=A0=A0=A0 There =
are quite a few issues occuring using this driver.</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma"></font>=A0</div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">Issue 1: When we mention =
<strong>BoolsAsChar</strong><strong>=3D1</strong> in connection string, its=
returning empty value instead of 1 or 0 based on true or false.=A0</font><=
/div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">Issue 2: we are trying to=
fill dataset through OdbcDataAdapter.</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0 </font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0 Code Snippet: </font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0 OdbcDataAda=
pter odbcAdapt =3D new OdbcDataAdapter("Select * from table1;"+ &=
quot;Select * from table2;" , cdbConn.Conn);</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0 odbcAdap=
t .Fill(dataset)</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma"></font>=A0</div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">always dataset is returni=
ng 0 tables.</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma"></font>=A0</div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">Can you please help us. I=
f we change the driver from postgresql unicode to postgresql will there be =
much differences in the behavior?</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">Please previous your valu=
able inputs.</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma"></font>=A0</div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma">Regards</font></div>
<div dir=3D"ltr"><font size=3D"2" face=3D"tahoma"><font size=3D"2" face=3D"=
tahoma">Goutham</font> J</font></div>
--e0cb4e887bb19429db04848e308e--
