Re: union/collation problem, error 1267: feature or bug?
Hi Gleb, i finally found out a method to be entirely independent from any character-set as well as collation-sequence problem, when forming a UNION, where you occasionnally have to insert place-holders in one of the SELECT statements: as (text, varchar, char) placeholders use NULL instead of "" or '' if your application permits it. thanks for your suggestion an help. suomi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: union/collation problem, error 1267: feature or bug?
Hi Gleb, localhost.(none)> show session variables like "%version%"; +-+--+ | Variable_name | Value| +-+--+ | protocol_version| 10 | | version | 4.1.16-standard | | version_comment | MySQL Community Edition - Standard (GPL) | | version_compile_machine | i686 | | version_compile_os | pc-linux-gnu | +-+--+ 5 rows in set (0.00 sec) localhost.(none)> with the new version , in a first view, the problem i reported on 20. january 2006, does not occur anymore. thanks for your suggestion an help. suomi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: union/collation problem, error 1267: feature or bug?
Hello. Some times the cause of these problems is that some fields have different character sets or it is a bug. I suggest you the following steps: check if the problem still exists in 4.1.16. Then provide the create statements of your tables to the list (they include the character set information). See: http://dev.mysql.com/doc/refman/4.1/en/charset-collation-charset.html schlubediwup wrote: > Hi mysqllers, > > 1. following installation > > > localhost.addresses2> show global variables like "version%"; > +-+--+ > | Variable_name | Value| > +-+--+ > | version | 4.1.14-standard | > | version_comment | MySQL Community Edition - Standard (GPL) | > | version_compile_machine | i686 | > | version_compile_os | pc-linux-gnu | > +-+--+ > 4 rows in set (0.00 sec) > > localhost.addresses2> > > > > 2. following two tables are involved: > > localhost.addresses2> describe contacts2; > +--+--+--+-+---++ > > | Field| Type | Null | Key | Default | > Extra | > +--+--+--+-+---++ > > | name | text | YES | | NULL > || > | firm | text | YES | | NULL > || > | title| text | YES | | NULL > || > | phone| text | YES | | NULL > || > | mail | text | YES | | NULL > || > | comment | text | YES | | NULL > || > | status | text | YES | | NULL > || > | url | text | YES | | NULL > || > | businesscategory | text | YES | | NULL > || > | address | text | YES | | NULL > || > | kanton | text | YES | | NULL > || > | addon| text | YES | | NULL > || > | givenname| text | YES | | NULL > || > | history | text | YES | | NULL > || > | favorit | text | YES | | NULL > || > | last_update | timestamp| YES | | CURRENT_TIMESTAMP > || > | counter | int(10) unsigned | | PRI | NULL | > auto_increment | > +--+--+--+-+---++ > > 17 rows in set (0.00 sec) > > localhost.addresses2> > > > localhost.addresses2> describe tasks2; > +--+--+--+-+---++ > > | Field| Type | Null | Key | Default | > Extra | > +--+--+--+-+---++ > > | task_name| text | YES | | NULL > || > | actiony | text | YES | | NULL > || > | date_start | date | YES | | NULL > || > | date_end | date | YES | | NULL > || > | date_last_action | date | YES | | NULL > || > | date_next_action | date | YES | | NULL > || > | start_time | time | YES | | NULL > || > | end_time | time | YES | | NULL > || > | task_address | text | YES | | NULL > || > | task_comment | text | YES | | NULL > || > | task_responsible | text | YES | | NULL > || > | project | text | YES | | NULL > || > | task_history | text | YES | | NULL > || > | task_last_update | timestamp| YES | | CURRENT_TIMESTAMP > || > | contact_link | int(11) | YES | | NULL
union/collation problem, error 1267: feature or bug?
Hi mysqllers, 1. following installation localhost.addresses2> show global variables like "version%"; +-+--+ | Variable_name | Value| +-+--+ | version | 4.1.14-standard | | version_comment | MySQL Community Edition - Standard (GPL) | | version_compile_machine | i686 | | version_compile_os | pc-linux-gnu | +-+--+ 4 rows in set (0.00 sec) localhost.addresses2> 2. following two tables are involved: localhost.addresses2> describe contacts2; +--+--+--+-+---++ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+---++ | name | text | YES | | NULL || | firm | text | YES | | NULL || | title| text | YES | | NULL || | phone| text | YES | | NULL || | mail | text | YES | | NULL || | comment | text | YES | | NULL || | status | text | YES | | NULL || | url | text | YES | | NULL || | businesscategory | text | YES | | NULL || | address | text | YES | | NULL || | kanton | text | YES | | NULL || | addon| text | YES | | NULL || | givenname| text | YES | | NULL || | history | text | YES | | NULL || | favorit | text | YES | | NULL || | last_update | timestamp| YES | | CURRENT_TIMESTAMP || | counter | int(10) unsigned | | PRI | NULL | auto_increment | +--+--+--+-+---++ 17 rows in set (0.00 sec) localhost.addresses2> localhost.addresses2> describe tasks2; +--+--+--+-+---++ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+---++ | task_name| text | YES | | NULL || | actiony | text | YES | | NULL || | date_start | date | YES | | NULL || | date_end | date | YES | | NULL || | date_last_action | date | YES | | NULL || | date_next_action | date | YES | | NULL || | start_time | time | YES | | NULL || | end_time | time | YES | | NULL || | task_address | text | YES | | NULL || | task_comment | text | YES | | NULL || | task_responsible | text | YES | | NULL || | project | text | YES | | NULL || | task_history | text | YES | | NULL || | task_last_update | timestamp| YES | | CURRENT_TIMESTAMP || | contact_link | int(11) | YES | | NULL || | task_counter | int(10) unsigned | | PRI | NULL | auto_increment | +--+--+--+-+---++ 16 rows in set (0.00 sec) localhost.addresses2> 3. following character-sets and collations: localhost.addresses2> show session variables like "character%"; +--++ | Variable_name| Value | +--++ | character_set_client | utf8