[Mono-list] Problem with Oracle and Mono Charset...

Hubert FONGARNAND hubertf-1@altern.org
Mon, 28 Feb 2005 10:35:28 +0100


Thank you for your fix... It works now without any problems...
Just a question, do you plan to implement connection pooling on oracle cl=
ient=20
classes. I've seen that dealing with oracle database works well with mono=
=20
(now) but it's much more slower than MS.NET when you open and close many=20=

connections... Is there a way to speed up this process.
I'm ready to help you implementing this, if you need...


Le Samedi 26 F=E9vrier 2005 05:38, vous avez =E9crit=A0:
> I recently committed a fix to svn trunk HEAD for strings in
> OracleParameter to use OCIUnicodeToCharSet for Oracle data types dates,=

> CLOBs, VARCHAR2/CHAR, etc...
>
> Can you try your tests again to see if they work now?  I do not know
> French to test the changes.  :-)
>
> Hubert FONGARNAND wrote:
> >Thanks to Daniel Morgan
> >DataTime and OracleDateTime works now perfectly. There's still a probl=
em
> > with charset.When my NLS_LANG variable isn't set (on my mono client),=

> > french "=E9=E8" are seen as "??" in the database (MS.NET client see "=
??").
> >The only way to display the "=E9=E8" correctly is to set my NLS_LANG t=
o :
> >NLS_LANG=3D"FRENCH_FRANCE.UTF8" (but normally, the client should adapt=

> > itself to the server settings)
> >but there's still a problem with string length. eg: when I do an "INSE=
RT"
> > with a string with some "=E9=E8" the string is "cut" by oracle, so I =
can not
> > see the entire string in the database...

--=20
Hubert FONGARNAND
Fiducial IT
_______________________________________________
Ce message et les =E9ventuels documents joints peuvent contenir des infor=
mations confidentielles.
Au cas o=F9 il ne vous serait pas destin=E9, nous vous remercions de bien=
 vouloir le supprimer et en aviser imm=E9diatement l'exp=E9diteur. Toute =
utilisation de ce message non conforme =E0 sa destination, toute diffusio=
n ou publication, totale ou partielle et quel qu'en soit le moyen est for=
mellement interdite.
Les communications sur internet n'=E9tant pas s=E9curis=E9es, l'int=E9gri=
t=E9 de ce message n'est pas assur=E9e et la soci=E9t=E9 =E9mettrice ne p=
eut =EAtre tenue pour responsable de son contenu.