DataDeploy fails update deployment if path has an apostrophe in it.

System

hi

I have a client who has the error message below when trying to deploy a path with an apostrophe init:

DDELECTELECT DESCRIPTION,TITLE,CATEGORY,ALL_CLIENTS,PATH FROM METADATA_DOCUMENTS WHERE PATH = 'Documents/L'OREAL (UK) LIMITED/Investment Reviews/AR - 20040331.pdf'
DD:
DD:*******************************************************
DDQLException occured in TDbSchemaGroupInfoNode
DD:Exception Message: ORA-00933: SQL command not properly ended
DD:Vendor Error Code: 933
DDQL state: 42000
DD:*******************************************************
DD:
DD:*******STACK TRACE*************
java.sql.SQLException: ORA-00933: SQL command not properly ended
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)

The environment that the client has is:
System: Solaris 8
Database: Oracle
TeamSite: 6.1
DataDeploy: 6.0.1.0.0

I will be setting up this here to test internally but I was curious if anyone has come across this issue before? if so please let me know!

thanks