Special characters - Mailing list pgsql-general

From Mihai Gheorghiu
Subject Special characters
Date
Msg-id 001d01c1272e$dc83f960$6e646464@New6.Travel
Whole thread Raw
List pgsql-general
Yet another newbie question...
The database I'm working on will have fields with special characters: CR/LF,
' (like in O'Malley) etc.
Is there an easy way to deal with this (in INSERT, UPDATE and SELECT), or
should the front end application (Java) take care of escaping those
characters?
E.g. The user searches for O'Malley in the lastname field.

Thank you,

Mihai Gheorghiu


pgsql-general by date:

Previous
From: "Jeff Eckermann"
Date:
Subject: Re: slow update but have an index
Next
From: Doug McNaught
Date:
Subject: Re: Special characters