Home > Default > Problem with white space

Problem with white space

November 30Hits:0
Advertisement
Hi,
I do an insert in a table. I try to insert a white space in a varchar2(1) field. I use parameter query.
But when i try to do this, odp.net insert a NULL value instead of the white space.
Is there a parameter to change to avoid this problem ??
Thanks in advance.

Answers

Not sure if this is exactly the issue but
you could try the current Patch 4147997
ODP.NET Patchset 9.2.0.4.15
or try a Workaround of binding parameters as Char which does not remove trailing spaces:
cmd.Parameters.Add(new OracleParameter("data",
OracleDbType.Char,10)).Value=" ";
or
cmd.Parameters.Add("data",
OracleDbType.Char,10," ",
System.Data.ParameterDirection.Input);

Read other 6 answers

Tags:

Related Articles

  • Problem with white spaceNovember 30

    Hi, I do an insert in a table. I try to insert a white space in a varchar2(1) field. I use parameter query. But when i try to do this, odp.net insert a NULL value instead of the white space. Is there a parameter to change to avoid this problem ?? Tha

  • Problema with white space at the bottomNovember 30

    http://formypets.net/cat_training.html I keep getting that strange white space at the bottom and I have no idea what to do. Can someone give me a hand, please?labecs wrote: > I was just hoping to get a recommendation about where I can go to have some

  • Is it possible to insert white space that will track like other characters?October 11

    I'm working with Indesign CS3, and have a problem with white space, inserted as a special character - in this case, a sixth space, used for the space between initials of a cited author: A. B. White, or whatever. Between the point after A and the B, I

  • Problem in parsing white spaces using if_ixml_parserOctober 11

    Hello People, I have a problem in parsing XML file in one of my programs. The program uses the method get_value( ) of class if_ixml_node to fetch a value. In the XML file when the value is spaceA, then after parsing, the value fetched is A and not sp

  • IE 11 white space problemOctober 11

    I created  a page with dreamweaver. It renders as intended in firefox but shows unwanted white space in ie 11. How do I fix this? Here is the page in firefox: Here is ie 11 page: Please respond to [email protected] Here is my code: <!DOCTYPE htm

  • Image problems - inline, but white space in image next to textNovember 30

    I've converted all of my images to be inline with the text in an attempt to correct alignment issues in various browsers. However, now every image is displaying as two pieces with white space adjacent to the text. What's going on? How do I fix it? ht

  • White space handling dbms_xmlstore.insertxmlOctober 11

    Hi, I have a question about white space handling. I have a column in table which holds white space character. When I loading xml file using dbms_xmlstore.insertxml white space is converted into NULL and inserted into table. It would fail if the colum

  • I am having trouble with the position of my header image across browsers. white space above it in safari, pc, and crome then all to the right in firefox.October 11

    nydogworks.net <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>NYDogWorks Long Island Dog Training and Behavior</title

  • Keep white spaces and carriage returns?October 11

    I'm viewing a column -VARCHAR2(4000)- in a standard report column. The column value contains white spaces and carriage returns. I put "white-space:pre;" in CSS Style, but it still skips carriage returns... What can I do to view white spaces and

  • How do I remove the white space when importing a site from Flash?October 11

    Okay, so I've dragged and dropped my created Flash site into Dreamweaver. One problem though, when I view it in a web browser (any web browser), it displays the site fine, however with a huge white space to the side of it. You'll see what I mean in t

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.548 s.