Re: [ADMIN] Database encoding and collation

2013-04-20 Thread Rodrigo Barboza
On Sat, Apr 20, 2013 at 1:52 PM, Craig James wrote: > > On Fri, Apr 19, 2013 at 5:12 PM, Rodrigo Barboza > wrote: > >> Hi guys. >> I created a database with default encoding (SQL_ASCII) and default >> collate (C). >> I created a table test like this: >> create table test (a varchar (10)); >> The

Re: [ADMIN] Database encoding and collation

2013-04-20 Thread Craig James
On Fri, Apr 19, 2013 at 5:12 PM, Rodrigo Barboza wrote: > Hi guys. > I created a database with default encoding (SQL_ASCII) and default collate > (C). > I created a table test like this: > create table test (a varchar (10)); > Then i executed "insert into teste (a) values ('áéç&ã','Æ','ß'); > > Af

[ADMIN] Database encoding and collation

2013-04-19 Thread Rodrigo Barboza
Hi guys. I created a database with default encoding (SQL_ASCII) and default collate (C). I created a table test like this: create table test (a varchar (10)); Then i executed "insert into teste (a) values ('áéç&ã','Æ','ß'); After that: select * from test; a - áéç&ã Æ ß Why did it s