Hi Guys,
Another challenge I am encountering while moving database between boxes is that I lost all the öäå characters.
This must be a codepage issue, but I do not really see where I can alter this.
I exported the database using phpmyadmin and all looks OK there:
Text Formatted Code
INSERT INTO `gl_stories` VALUES ('citronsill',9,0,'recept_se','2005-03-05 16:13:04','Citronsill','Ett härligt sillrecept. Platsar på midsommar,
But when I look in the updated DB I see
Text Formatted Code
Ett h?rligt sillrecept. Platsar p? midsommar, jul ...
The new MySQL is
Server version: 5.0.45
Protocol version: 10
Server: Localhost via UNIX socket
MySQL charset: UTF-8 Unicode (utf8)
The old MySQL is 3.23 and has latin1
Text Formatted Code
SELECT *
FROM `gl_stories`
WHERE `sid` LIKE CONVERT( _utf8 'citronsill'
USING latin1 )
COLLATE latin1_swedish_ci
LIMIT 0 , 30
It must be the utf8 latin1_swedish-ci that is causing the hiccup, but not sure if I need to do a full restore using a different codepage, or actually just flip a setting somewhere.
Any advice / pointer really appreciated.
Thanks,
Boris
OK, should have written it in draft and then googled :-P
Latin to UTF conversion.
Or just pay closer attention to the import options in PHPMyAdmin.
There is actually a dropdown where you specify the source encoding.
Once I selected that option and restored the database all is working as it should ...
Anyway, isn't that what we always do ... run into the wall before reading the manual or actually looking at the screen. :rtfm: