#3398 Variable 'character_set_client' can't be set

[Tony Marston]

OS: Windows XP
PHP: 5.2.17
MySQL: 5.1.54
PHPmyAdmin: 3.4.3.1

Export now contain the following lines at the end:

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

This is OK if there was an old value to save, but I am now getting this error:

#1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

[Marc Delisle]

I cannot reproduce this on a Linux server (MySQL 5.1.55), maybe it's specific to Windows?

Which MySQL client version are you using?

[Tony Marston]

Ignore this error. I had cut & paste part of the output file into the query window, but I had missed off the start of the file which stoed the old values.