Apostrophe Problem

Results 1 to 3 of 3

Thread: Apostrophe Problem

  1. #1
    DEFOSSE Guest

    Default Apostrophe Problem

    I&#039m using ADO with SQL server to manage a kind of Forum (ASP Form with From, To, Subject,...). The problem is we are french and we are using a lot the special character "&#039" in our subject. Is there a way to transmit this character to SQL server via ODBC or Am I force to cut my text with all special characters. I would know the same for the chr(13) char.<BR>Could you also tell me if it would be better in using the ASP mail component for a forum.<BR><BR>Thanks,<BR>Marc

  2. #2
    Sathiya Guest

    Default RE: Apostrophe Problem

    Use REPLACE() function which takes care of the "&#039" easily

  3. #3
    DEFOSSE Guest

    Default RE: Apostrophe Problem

    Thanks for your answer. <BR>Could you give me more details : <BR>Does The replace() function delete the "&#039". <BR>If so, What if I want to store this "&#039" and also the carriage return in the database ?<BR><BR>Thanks,<BR>

Posting Permissions

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