Re: Different default collation in each connection

2004-09-29 Thread Jeremy March
> Ok, I thought that I will be misunderstood... > > I'll try to explain this in example below: > > I have table > > CREATE TABLE `product_descriptions` ( > `id_product_description` mediumint(8) unsigned NOT NULL auto_increment, > `id_product` mediumint(8) unsigned NOT NULL default '0', >

Re[2]: Different default collation in each connection

2004-09-28 Thread Piotr Duszynski
Hi Jeremy, >> P.S2 I store data in one table which has no default collation set only >> UTF-8 charset. In >> this table I can have data in different collations. > Every table does have a default collation either you specify it or it > comes from the default collation for your database or the ser

Re: Different default collation in each connection

2004-09-28 Thread Jeremy March
> P.S2 I store data in one table which has no default collation set only > UTF-8 charset. In > this table I can have data in different collations. Every table does have a default collation either you specify it or it comes from the default collation for your database or the server default. You n

Different default collation in each connection

2004-09-28 Thread Piotr Duszynski
Hi, I have a problem setting default collation for each connection. I have multilanguage site and I don't want to add COLLATE statement to every SQL - I could set it once during PHP startup and forget about it... But there's a problem. I tried to do SET names 'utf-8'; SET collation_connection