NilovSerge
Posts: 16
|
| Posted: 11/07/2006, 9:42 PM |
|
Hallo!What is the problem in statment:
INNER JOIN employees E on v.pin_code = E.pin_code
Database Error: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (cp1251_general_ci,IMPLICIT) for operation '='
fields pin_code are varchar(4)
in database these tables has CHARSET=latin1 COLLATE=latin1_general_ci
server(Windows 4.1.18-nt-log) is configured with cp1251
look show variables:
character_set_client : latin1
character_set_connection : latin1
character_set_database : latin1
character_set_results : latin1
character_set_server : cp1251
character_set_system : utf8
character_sets_dir :
collation_connection : latin1_swedish_ci
collation_database : latin1_general_ci
collation_server : cp1251_general_ci
I have a lot of pages and no problem till now was but here...
NO pages with "cp1251" in project!!!
I do not like reinstall mysql server with latin server callation...
If the are desisions?
_________________
With respect,
Nilov Serge. |
 |
 |
Edd
Posts: 547
|
| Posted: 11/08/2006, 3:59 AM |
|
The problem is in your database.
When you create a database it ususally has a default collation (in other words how the data is stored / sorted / etc). I don't know mySQL but the rule of thumb is that your database's collation should match your server configuration.
Each table will have a collation as well so if you have a tableA with collation cp1251_general_ci linked to tableB with collation latin1_general_ci you might as well try and match Japanses to Swedish.
Look at each table in your database one by one.
Sorry - but your outcome may be to extract and reload unless you can find a utility / method of repairing the situation.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
|
