Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2006
    Posts
    57

    Unanswered: insert special characters in database

    I am writing a web application and everytime I attempt to insert some special characters in the database I get errors. Is there a way around this?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Depends what you mean. If you mean unicode and you are attempting to insert into CHar or VarChar fields then you need to use NVarChar or NChar. BoL has all the gory details. Otherwise you'll need to porovide more details.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Sep 2006
    Posts
    57
    it seems everytime I include an apostrophe the system gives me an error..not sure why this is happening

    my second question is-- when someone types this:

    I cant wait
    to leave
    this place

    --It come out like this
    I cant wait to leave this place



    How can I make the system print all the tab keys and return carriage?

    thank you for any responses

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You need to escape apostrophes.

    "I can't wait to leave this place"
    must be submitted as
    "I can''t wait to leave this place"

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    The latter problem is probably a presentation issue - your FE needs to interpret the carriage returns & line feeds.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Oct 2006
    Posts
    1
    hi everybody,

    This is Rajen, hope it will be nice sharing ideas with u all. Feeling nice to join u all .

Posting Permissions

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