[Info-ingres] replacing special characters eg ä in SQL with a unicode script u'ä'

[Allan Biggs]

Is there a way of replacing characters such as ä  (a umlaut) as part of an 
SQL query. 

We are sometimes fed these characters by another system, 

in my case I am producing a python script which for ä needs to be 
represented by the string u'ä' or substituted for a none unicode 
character.


clearly I can do something like 

update filename_w_asd  set file_name = replace(file_name,'ä','''ä''');
\p\g

but is there a more generic way to do this?

Allan 

This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean

          http://www.DuPont.com/corp/email_disclaimer.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20160414/543ce7ed/attachment.html>