DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Bloody developers!!!

  1. #1
    Join Date
    Jan 2001
    Posts
    10
    One of our developers wants to put the following into his database...

    St James's

    ...including the '.

    Obviously insert into tab values ('St James's') doesn't work and not being an expert in these kind of things I'm a bit stumped. Any clues?

  2. #2
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Try double single quotes:

    e.g.

    insert into values ('St James''s')


    ___________________________


    John

  3. #3
    Join Date
    Jan 2001
    Posts
    10
    Forget this, the development department have fixed it.

  4. #4
    Join Date
    Feb 2001
    Location
    Belgium, Sint-Truiden
    Posts
    82
    If you insert 'St Jame''s' it is ok. Oracle sees this as one character ' instead of the character to open and close a textinput.

    Rik

  5. #5
    Join Date
    Nov 2000
    Posts
    178
    How did the developement department fix it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width