Re: query special character

From: BJ <bernhard.jongejan_at_born2run.tmfweb.nl>
Date: Sat, 21 Jul 2001 12:44:51 +0200
Message-ID: <9jbmhk$q4j$1@cyan.nl.gxn.net>

Tuan,

SQL> create table mail ( email varchar2(30) );

Table created.

SQL> insert into mail values ( 'bernhard.jongejan_at_topficie.nl');

1 row created.

SQL> select * from mail
  2 /

EMAIL

---

bernhard.jongejan_at_topficie.nl

SQL> select * from mail where email = 'bernhard.jongejan_at_topficie.nl';

EMAIL

---

bernhard.jongejan_at_topficie.nl

seems to work for Oracle 8.1.7 on NT4 and NLS_CHARACTERSET
WE8ISO8859P1 What is your database version and NLS_CHARACTERSET?

Regards

Bernhard Jongejan

bernhard.jongejan_at_topficie.nl

Tuan Tran <tuan.tran_at_verizon.net> schreef in berichtnieuws 4a17640d.0107202343.5931a3e_at_posting.google.com...
>
Received on Sat Jul 21 2001 - 05:44:51 CDT