I use the same sample in the new release of Mono 1.1.18 upgrading by yast
and it said:
Error is: ORA-01480: trailing null missing from STR bind value
Same error in my Website (mono+oracle)
These are my settings
[EMAIL PROTECTED]:~ env | grep LANG
NLS_LANG=simplified chinese_china.UTF8
On the other hand - after reading other people's mail, it seems to me
that all who experience the trimming have Oracle database setup as
UTF8. Mine works in EEMSWIN1250 (you can check this with SELECT value
FROM nls_database_parameters WHERE parameter='NLS_CHARACTER_SET';).
No, you're wrong
2006/10/4, David [EMAIL PROTECTED]:
On the other hand - after reading other people's mail, it seems to me
that all who experience the trimming have Oracle database setup as
UTF8. Mine works in EEMSWIN1250 (you can check this with SELECT value
FROM nls_database_parameters WHERE
On 10/4/06, David [EMAIL PROTECTED] wrote:
2006/10/4, David [EMAIL PROTECTED]:
On the other hand - after reading other people's mail, it seems to me
that all who experience the trimming have Oracle database setup as
UTF8. Mine works in EEMSWIN1250 (you can check this with SELECT value
I have started (finally!) to work on this bug. The test I am currently
using fails, with or without patch... although in an unexpected way.
On mono, it breaks with:
Failures:
1)
MonoTests.System.Data.OracleClient.Oci.OciDefineHandleTest.TrimsWideUnicodeStringsTest
: Directly passed value
Yeah, I tried looking at it the other day, but I have
no idea how to test unicode stuff.
Maybe eno on GimpNet IRC #mono can help you. He may
not be able to help with Oracle, but he knows unicode
very well. jonp is another good person to to talk to.
If possible, write a Windows.Forms
On 10/2/06, Daniel Morgan [EMAIL PROTECTED] wrote:
Yeah, I tried looking at it the other day, but I have
no idea how to test unicode stuff.
Maybe eno on GimpNet IRC #mono can help you. He may
not be able to help with Oracle, but he knows unicode
very well. jonp is another good person to to
Sorry, I don't have a Linux system with Mono build environment here.
That's why I couldn't build it yet. Maybe someone other can provide
you a patched DLL?
Joerg.
2006/9/27, David [EMAIL PROTECTED]:
Cound you give me a pathed OracleClient.dll，so I can test my project ?
2006/9/26, Leszek
2006/9/26, Leszek Ciesielski [EMAIL PROTECTED]:
It would be nice to use GetBytesCount() instead, but that would
require knowing the exact string we are going to bind - which we don't
know. (Correct me if I'm wrong)
I haven't found an OCI function for this yet.
Joerg.
Hi all,
I have attached a patch which should fix this problem.
Please check that it runs correctly because I can not build and test
this patch here.
Joerg.
2006/9/26, David [EMAIL PROTECTED]:
Finally, I find a way to insert the string.
In my sample;
// insert 4 length chinese string to
Cound you give me a pathed OracleClient.dll，so I can test my project ?
2006/9/26, Leszek Ciesielski [EMAIL PROTECTED]:
On 9/26/06, Jörg Rosenkranz [EMAIL PROTECTED] wrote:
Hi all,
I have attached a patch which should fix this problem.
Please check that it runs correctly because I can not
Hi David,
2006/9/18, David [EMAIL PROTECTED]:
...
You will see the result is not we expected,not all the character insert into
the database.
I suspect the problem lies in OciDefineHandle.DefineChar. There a
buffer of 2 * character length is allocated and filled. This is enough
for all
Just some info, UTF-8 for Unicode 3.x, goes up to 6 bytes per character.
:|
On 9/25/06, Jörg Rosenkranz [EMAIL PROTECTED] wrote:
Hi David,
2006/9/18, David [EMAIL PROTECTED]:
...
You will see the result is not we expected,not all the character insert into
the database.
I suspect
On Mon, 2006-09-25 at 21:36 -0300, Rafael Teixeira wrote:
Just some info, UTF-8 for Unicode 3.x, goes up to 6 bytes per character.
:|
IIRC, UTF-8 should never be 6 bytes per character. It *can* be, to
encode the entire 31-bit address space of UCS-4, but since IIRC they
limited Unicode ISO
David,I will argue that if OracleParametr a better solution because I dislike the Parameter personally :) By the way, this is not only bug in the Parameter. The reality is that is not a bad workaround if you don't have the time(like me). The other options are to wait the bug fixed or you go to
2006/9/21, Tony Gu [EMAIL PROTECTED]:
David,I will argue that if OracleParametr a better solution because I dislike the Parameter personally :) By the way, this is not only bug in the Parameter. The reality is that is not a bad workaround if you don't have the time(like me). The other options are
On 9/21/06, David [EMAIL PROTECTED] wrote:
2006/9/19, Leszek Ciesielski [EMAIL PROTECTED]:
This has already been reported (check
http://bugzilla.ximian.com/show_bug.cgi?id=79004 and
http://bugzilla.ximian.com/show_bug.cgi?id=78840 ). Could
you please
try the OracleClient from the
Could you please clarify this? If I get you right, you mean that the
code in the repository does not work, and mono 1.1.17.1 does not
work.
Surely the code will work if you do it as a single sql statement (if
it does not, things are FUBAR ;-) ), but it is (in regard to
performance) better to
2006/9/19, Leszek Ciesielski [EMAIL PROTECTED]:
This has already been reported (checkhttp://bugzilla.ximian.com/show_bug.cgi?id=79004 andhttp://bugzilla.ximian.com/show_bug.cgi?id=78840
). Could you pleasetry the OracleClient from the repository? I was not able to replicatethe bug with the
Does your insert statement work in sqlplus?
Also, does your test case work on microsoft .net?
Have you used this:
OracleParameter parm = new OracleParameter(:name,
OracleType.NVarChar);
Which has OracleType of NVarChar instead of VarChar.
And in your table you created, have it created with
2006/9/21, Daniel Morgan [EMAIL PROTECTED]:
Does your insert statement work in sqlplus?Also, does your test case work on microsoft .net?Have you used this:OracleParameter parm = new OracleParameter(:name, OracleType.NVarChar);
Which has OracleType of NVarChar instead of VarChar.And in your table
2006/9/21, Tony Gu [EMAIL PROTECTED]:
David,Could you try to not use OracleParameter, just CommadText?I think the bug is in the Parameter decode.TonyIf not use the OracleParameter,the problem will not happen But not using OracleParametr is not a better solution, don't you think so?
You have to have the column as NVarchar, Which is national character
set, It saves all data as unicode (utf8) instead of ASCII
On 9/17/06, David [EMAIL PROTECTED] wrote:
I use System.Data.OracleClient to connect and operate oracle database;
But I find a problem when inserting into oracle
在06-9-18，John Anderson [EMAIL PROTECTED]
写道：
You have to have the column as NVarchar, Which is national characterset, It saves all data as unicode (utf8) instead of ASCIIYes, I've also tried nvarchar2, it also have the same problem
You cat try the above my code.my oracle database is also using
I use System.Data.OracleClient to connect and operate oracle database;But I find a problem when inserting into oracle database with chinese character;Here is a simple exapmle:using System;using System.Data
;using System.Data.OracleClient;namespace Test{ class MainEntry{ public static void
25 matches
Mail list logo
