[solved] Problem with characters like åäö

[boppen]

Hi!

I'm having problems with the Program Guide and åäö, they are displayed like ö Ã¥.
But if I record a program and the look at the decription in the Recording menu åäö shows up correctly??!!

Whan I download the EPG using xmltv åäö looks correct in the console output.

I have tried to make my box use unicode and I have tried UTF8 and 8859-15 but I dont know if that has anything to do with t?

As I've understood the database is using latin1? When I tried to import mc.sql from a stable version of myth I got some error where MySQL complained about latin1, but I am now using the latest svn and now I could import mc.sql so maybe something have changed?

Thans for any help!

/Boppen

[apanloco]

I'm having the exact same problem. The swedish chars (åäö) are inserted or fetched errnoneously and mythtv shows strange chars instead.

This is what I have done to try to make it work:

I have made sure that mysql is using latin1 as charset (exchanged all occuranses of charsets to latin1 in /etc/mysql/my.cnf):

mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

I have made sure the mythconverg database is latin1:

mysql> SHOW CREATE DATABASE mythconverg;
+-------------+------------------------------------------------------------------------+
| Database    | Create Database                                                        |
+-------------+------------------------------------------------------------------------+
| mythconverg | CREATE DATABASE `mythconverg` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+-------------+------------------------------------------------------------------------+
1 row in set (0.00 sec)

But all items are stored erroneously:

mysql> select title from program limit 10;
+-----------------+
| title           |
+-----------------+
| (P) Banbrytare  |
| (P) Banbrytare  |
| (P) Banbrytare  |
| (P) Banbrytare  |
| (P) Blitzkrieg  |
| (P) Blitzkrieg  |
| (P) Bobs värld |
| (P) Bobs värld |
| (P) Bobs värld |
| (P) Bobs värld |
+-----------------+
10 rows in set (0.00 sec)

I am using xmltv/tv_grab_se_swedb

/D

[apanloco]

Wow it works now!

Above is almost all I did. I also did this (before doing the above) if it helps anyone. basically changing everything to support latin1 swedish.

Createt /etc/env.d/02locate:

da@brutus ~ $ cat /etc/env.d/02locale
LC_ALL="sv_SE"

Added correct keymap:

da@brutus ~ $ cat /etc/conf.d/keymaps
...
KEYMAP="sv-latin1"
...

Added correct font (must be unnesseccary):

da@brutus ~ $ cat /etc/conf.d/consolefont
...
CONSOLEFONT="lat9-16"
...

And ofcourse added swedish XkbLayouy to xorg.conf:

da@brutus ~ $ cat /etc/X11/xorg.conf | grep Xkb
        Option      "XkbLayout" "se"
        Option      "XkbModel"  "pc105"

Adding correct locale.gen:

da@brutus ~ $ cat /etc/locale.gen | grep sv
sv_SE ISO-8859-1

And ofcourse regenerating it with:

sudo locale-gen

OBSERVE!!! mysql -u mythtv mythconverg -p STILL SHOWS BAD CHARACTERS but mythtv can show them.

Hope this helps you or anyone else!

/D

[boppen]

Hi!

My prolem was that the mysql-server (I have it installed but not running) on the frontend-box was using utf8, so I (I'm using Gentoo) did;
USE="-utf8 -latin1" emerge mysql

And then changed all utf8 in my.cnf to latin1 - and now ÅÄÖ works!

Thanks for the help!

/Boppen