MySQL Forums
Forum List  »  Newbie

Character sets dont match
Posted by: Maxim Vexler
Date: June 03, 2005 11:02AM

Hello and thank you for your time.

I have a number of questions that rose when I was trying to figure out the best path to migrate a mysql server from windows to linux.

1. Is "character set" a different name for the term "encoding" ?
2. How can I know the effective character set of a table / column ?
3. Is it possible for a column to have character set of typeX while the data (text) is saved with char set Y ?
4. Is it possible that in the same table, different rows will be stored with different character sets ?

The mysql server version on linux is : 4.0.24
The mysql server version on windows is : 4.0.23

I backed up the db (scheme + data) on the windows server to a .sql file.
The trouble is that when importing the data back into the server on the linux side, I got the text in the wrong encoding (i.e. "gibrish").
I think it's pointless to mention the the text is not english, its hebrew.

// I wouldn't like to use iconv before I know from what, to what encoding I need to convert the file.


Appreciate any suggestions,
Maxim.

Options: ReplyQuote


Subject
Written By
Posted
Character sets dont match
June 03, 2005 11:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.