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
LANG=zh
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 "S
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 pa
> 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 wr
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 perso
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 application
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 mismat
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.
_
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 C
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 becau
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 build and test
> this patch here.
>
> Joerg.
>
> 2006/9/26, David <[EMAIL PROTECTED]>:
> > Finally, I find a way to ins
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 dat
Finally, I find a way to insert the string.
In my sample;
// insert 4 length chinese string to database
parm.Value = "测试插入";
// and give it eight space like :
parm.Value = "测试插入";
then all the string will insert into the database, and you will not
see the space
the string length in dat
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 & IS
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.
> >
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 e
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 use
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
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 ar
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 fix
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?
_
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 tabl
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
N
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 curre
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 repository? I was not able to replicate
the bug with the current svn code (although I am not 100% certain it
在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 usin
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 dat
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
28 matches
Mail list logo