Feb 172014
 

Two tables that look the same, but for some reason I can insert my pounds (£) into the first one, but not the second:

create table i_can_insert (
  into_this varchar2(1)
);

insert into i_can_insert (into_this)
values ('£');

-- I execute some code here

create table but_i_cant_insert (
  into_this varchar2(1)
);

insert into but_i_cant_insert (into_this)
values ('£');

ORA-12899: value too large for column

Why? Put your answers in the comments!