peterlaursen wrote on Mar 20 2007, 04:44 AM:
We will release the first SQLyog (beta) with unicode support in a few days. that will make things easier. Do you want an early beta for testing? If so create a ticket and we will let you have one maybe even tonight or tomorrow.
I'd be very interested, yes. How do I create a ticket?
In the meantime, to stop me tearing any more of my hair out, can you please tell me ANY means whereby I can enter some Chinese characters into a MySQL db via an INSERT in SQLYog and then view them again via a SELECT in SQLYog? I can create a new database with any required character set, collation, etc. I just need to see one 'round trip' working. I don't know if I actually have any means of entering Chinese characters from my UK keyboard, so I imagine the best bet would be to enter something as a hex value. I have tried to enter a Chinese word by means of the decimal Unicode values, as below, but the column ends up empty (or at least length returns 0 for it, which I assume means it's empty).
set names 'big5';
CREATE TABLE `test` (
`english_name` varchar(30) default NULL,
`chinese_name` varchar(30) character set big5 default NULL
) ENGINE=InnoDB DEFAULT CHARSET=big5;
insert into test(english_name,chinese_name) values (“Accrington”,char(33406,32527,38931));
select length(chinese_name) from test;
