I'm experienced in SQL Server but new to Oracle. I've created a Oracle XE 11G database, table and inserted several records successfully. But I'm unable to insert extended characters as shown below. My column's datatype is VARCHAR(2000) but I get the error 'ORA-01722: invalid number' upon attempting to CAST CHR() to VARCHAR. What am I missing here?
insert into tblThreadContent
('Regular text followed by an extended character, with space ' + cast(chr(164) as varchar(10)))