asked on

How to set up mysql to get both ?-sign and å,ä,ö (swedish signs)?

Hi,

I have set up my MySQL5.0 server without problems, but now when I use tables with tuples that contain ? (euro-sign) they are not shown as they should (shown as ?). I guess this is a char-set problem but I haven't been able to solve it. I currently use the latin1_swedish_ci collation. The problem is that I need to be able to show the swedish å,ä,ö (å,ä and ö) as well. Does anybody know how to solve this?

Thanks,
//madwax

madwax

ASKER

note: the euro sign isn't shown here either, I guess that EE has the same problem... :(

ajaikumarr

Hai,

Are you storing the content from HTML editors??? Might be the problem is with encoding and decoding...

Bye
ajai

madwax

ASKER

nope, the same thing happens if I just enter a normal sql query as INSERT INTO table(field) VALUES("?-sign")

madwax

ASKER

I experience the same problem with @ which is even worse... :(

thecode101

I tried the normal SQL query and it worked fine
INSERT INTO `table` ( `thefield` )
VALUES ( '@å,ä,ö å,ä and ö');

It didn't complain about any errors. Is that what your having the problem with or is it with displaying the sql field?

madwax

ASKER

I can enter the value into the database, but as soon as the value is entered it changes to a ? which I figure is the unknown character (I use phpAdmin and console mysql). It is a charset problem, but I don't know how to fix it... :(

ASKER CERTIFIED SOLUTION

thecode101

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

krazywest

Try setting the field type (encoding) to unicode.