mail-archives/mono-list/2005-February/026038.html

76 строки
2.9 KiB
HTML

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE> [Mono-list] Problem with Oracle and Mono Charset...
</TITLE>
<LINK REL="Index" HREF="index.html" >
<LINK REL="made" HREF="mailto:danielmorgan%40verizon.net">
<META NAME="robots" CONTENT="index,nofollow">
<LINK REL="Previous" HREF="025914.html">
<LINK REL="Next" HREF="026073.html">
</HEAD>
<BODY BGCOLOR="#ffffff">
<H1>[Mono-list] Problem with Oracle and Mono Charset...
</H1>
<B>Daniel Morgan
</B>
<A HREF="mailto:danielmorgan%40verizon.net"
TITLE="[Mono-list] Problem with Oracle and Mono Charset...">danielmorgan@verizon.net
</A><BR>
<I>Fri, 25 Feb 2005 23:38:36 -0500</I>
<P><UL>
<LI> Previous message: <A HREF="025914.html">[Mono-list] Problem with Oracle and Mono Charset...
</A></li>
<LI> Next message: <A HREF="026073.html">[Mono-list] Problem with Oracle and Mono Charset...
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#26038">[ date ]</a>
<a href="thread.html#26038">[ thread ]</a>
<a href="subject.html#26038">[ subject ]</a>
<a href="author.html#26038">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>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:
&gt;<i>Thanks to Daniel Morgan
</I>&gt;<i>DataTime and OracleDateTime works now perfectly. There's still a problem with
</I>&gt;<i>charset.When my NLS_LANG variable isn't set (on my mono client), french &quot;éè&quot;
</I>&gt;<i>are seen as &quot;??&quot; in the database (MS.NET client see &quot;??&quot;).
</I>&gt;<i>The only way to display the &quot;éè&quot; correctly is to set my NLS_LANG to :
</I>&gt;<i>NLS_LANG=&quot;FRENCH_FRANCE.UTF8&quot; (but normally, the client should adapt itself to
</I>&gt;<i>the server settings)
</I>&gt;<i>but there's still a problem with string length. eg: when I do an &quot;INSERT&quot; with
</I>&gt;<i>a string with some &quot;éè&quot; the string is &quot;cut&quot; by oracle, so I can not see the
</I>&gt;<i>entire string in the database...
</I>&gt;<i>
</I>&gt;<i>
</I>
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI> Previous message: <A HREF="025914.html">[Mono-list] Problem with Oracle and Mono Charset...
</A></li>
<LI> Next message: <A HREF="026073.html">[Mono-list] Problem with Oracle and Mono Charset...
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#26038">[ date ]</a>
<a href="thread.html#26038">[ thread ]</a>
<a href="subject.html#26038">[ subject ]</a>
<a href="author.html#26038">[ author ]</a>
</LI>
</UL>
</body></html>