Welcome to Geeklog, Anonymous Friday, April 19 2024 @ 03:20 am EDT
Geeklog Forums
Database Encoding - Advice needed
Status: offline
knuff
Forum User
Full Member
Registered: 12/17/04
Posts: 340
Location:Sweden
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:
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
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
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
Vanrillaer.com - our Family Portal
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
Vanrillaer.com - our Family Portal
5
5
Quote
Status: offline
knuff
Forum User
Full Member
Registered: 12/17/04
Posts: 340
Location:Sweden
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:
Vanrillaer.com - our Family Portal
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:
Vanrillaer.com - our Family Portal
6
7
Quote
All times are EDT. The time is now 03:20 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content