Re: OT: SQL Question

2012-03-25 Thread David Turner
Jeff, I would use a join table, teacher_flights. create table teacher_flights( teacher_id int(11) not null, flight_id int(11) not null, primary key(teacher_id, flight_id)); Dave From: Mark Phillips m...@phillipsmarketing.biz To: Mysql List

Re: big character constant

2012-03-25 Thread David Turner
select 'U02714','U02718'; insert into my_table values('U02714'); insert into my_table values('U02718'); Let me know if this is what you intended. Dave From: h...@tbbs.net h...@tbbs.net To: mysql@lists.mysql.com Sent: Friday, March 23, 2012 5:14 PM

Re: big character constant

2012-03-25 Thread Walter Tross
I guess what you mean is Unicode characters U+2714 'HEAVY CHECK MARK' and U+2718 'HEAVY BALLOT X' (http://www.fileformat.info/info/unicode/char/2714/index.htm and http://www.fileformat.info/info/unicode/char/2718/index.htm). Unicode has several encodings, of which the most used are UTF-8 and