Home » SQL & PL/SQL » SQL & PL/SQL » select sql for non-english chancter
select sql for non-english chancter [message #345765] Thu, 04 September 2008 14:14 Go to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

Is there a way to find out non english character stored in a table column using select sql?
Re: select sql for non-english chancter [message #345767 is a reply to message #345765] Thu, 04 September 2008 14:29 Go to previous messageGo to next message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
Hi,

Try using REGEXP_LIKE function if your Oracle database version is 10g and above.


Regards,
Jo
Re: select sql for non-english chancter [message #345769 is a reply to message #345765] Thu, 04 September 2008 14:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Define non english character.

Regards
Michel
Re: select sql for non-english chancter [message #345777 is a reply to message #345769] Thu, 04 September 2008 14:44 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

such as umlaut.
eg , ,

[Updated on: Thu, 04 September 2008 14:45]

Report message to a moderator

Re: select sql for non-english chancter [message #345779 is a reply to message #345777] Thu, 04 September 2008 14:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is that the only ones?

Regards
Michel

[Updated on: Thu, 04 September 2008 14:48]

Report message to a moderator

Re: select sql for non-english chancter [message #345781 is a reply to message #345765] Thu, 04 September 2008 14:49 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

yes, Michel
Re: select sql for non-english chancter [message #345782 is a reply to message #345765] Thu, 04 September 2008 14:50 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
select test_str from my_table where length(test_str) <> length(asciistr(test_str))
Re: select sql for non-english chancter [message #345783 is a reply to message #345782] Thu, 04 September 2008 15:05 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

perfect! got it
Thanks Michel...

Cheers
Nav
Re: select sql for non-english chancter [message #345785 is a reply to message #345781] Thu, 04 September 2008 15:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select col from tab where col<>translate(col,'0', '0');

Regards
Michel
Re: select sql for non-english chancter [message #345786 is a reply to message #345765] Thu, 04 September 2008 15:20 Go to previous message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

Thanks Michel and Ana
Ana solution worked perfect for all condition.

Cheers,
Nav
Previous Topic: Paritioning tables- Indexes
Next Topic: Stored procedure to delete information within number of days?
Goto Forum:
  


Current Time: Sat Dec 03 12:24:45 CST 2016

Total time taken to generate the page: 0.11842 seconds