Skip to main content

developerWorks >  Information Management  >  Forums  >  DB2 Express  >  developerWorks

how to find rows with &#x1a in a db2 table    Point your RSS reader here for a feed of the latest messages in this thread


     
 
 
My developerWorks
 Welcome, Guest
Sign in or register
Reply to this Thread Reply to this Thread Post New Thread Post New Thread Watch list Watch list Forum settings Forum settings Help Help
Permlink Replies: 2 - Pages: 1 - Last Post: Oct 18, 2009 5:30 PM Last Post By: suto Threads: [ Previous | Next ]
suto

Posts: 2
Registered: Oct 17, 2009 12:43:44 PM
how to find rows with &#x1a in a db2 table
Posted: Oct 17, 2009 12:51:49 PM
Click to report abuse...   Click to reply to this thread Reply
I have a unicode table in db2 version 9, say project, with a description field.
In my web application, I have a URL that returns an XML string of a given project ID. The issue is that some of the projects have invalid characters, such as &#x1a, for XML 1.0 standard.

My question is that how do I use a SQL query to identify all rows with &#x1a in description in the project table.

Thanks.
Valued Contributor SDas

Posts: 239
Registered: Jul 23, 2008 01:24:04 PM
Re: how to find rows with  in a db2 table
Posted: Oct 18, 2009 06:03:06 AM   in response to: suto in response to: suto's post
Click to report abuse...   Click to reply to this thread Reply
suto, you can try:

SELECT col-list
FROM table-name
WHERE col-name LIKE '%&#x1a%'
suto

Posts: 2
Registered: Oct 17, 2009 12:43:44 PM
Re: how to find rows with  in a db2 table
Posted: Oct 18, 2009 05:30:35 PM   in response to: SDas in response to: SDas's post
Click to report abuse...   Click to reply to this thread Reply
I posted this question because the plain select you suggested does not work.
Do you have a working example?

Thanks.
Pages: 1
Go Back Back to Thread List
Threads: [ Previous | Next ]
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 
MoreLess 

Update your My developerWorks profile and start connecting with others.

Point your RSS reader here for a feed of the latest messages in all forums