Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2010
    Posts
    2

    Unanswered:

    how to insert semicolon using query?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    INSERT INTO MyTable (Col1) values (';')

    Andy

  3. #3
    Join Date
    Apr 2010
    Posts
    2
    by the way prob solved. i have used CHAR(59) in place of semicolon

  4. #4
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by div17283 View Post
    by the way prob solved. i have used CHAR(59) in place of semicolon
    This only works if you know the database encoding. E.g., if it is EBCDIC, you'd need CHAR(94) instead of CHAR(59). The latter works for ASCII en Unicode, though.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

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